Converting Workday XML to Snowflake
Uli Bethke
Overview In this post we will show you how you can easily convert Workday XML or any other XML to a Snowflake database. We will use Sonra’s Paranoid to mask the XML data and Flexter to convert Workday XML automatically without any manual coding. What is Flexter? Flexter converts any XML/JSON to a readable format ...
Read MoreConverting CRS XML to AWS Athena
AWS Athena does not have native support for XML. Processing XML files on AWS Athena is slow, manual, and error prone. One option is to use AWS Glue and convert your XML to CSV, TSV or Parquet. You would need to have technical knowledge to use AWS Glue and to do a lot of manual ...
Read MoreConverting XML and JSON to a Data Lake
Data lakes are a popular design pattern in data analytics. A data lake is used to store a copy of data coming from operational source systems such as relational databases. You can choose from dozens of tools to populate a data lake from relational and structured data sources. However, it gets tricky when you want ...
Read MoreConverting SDMX XML to BigQuery
You don’t have many options for processing XML on BigQuery. If our data is in Avro, JSON, Parquet, etc. then you can load it easily to BigQuery. But what about XML? BigQuery does not provide any native support to deal with XML documents. Converting XML to BigQuery is a manual, time consuming and error prone ...
Read More