Flexter, Informatica, and Redshift work Hand in Hand to convert ESMA XML

Anvesh Gali ETL, Uncategorized, XML

In this walk-through, we combine two powerful software platforms to present a highly efficient and user-friendly method to perform ETL of complex XML files. This implementation uses Flexter, which is a powerful tool for converting complex XML files to a database or text and Informatica for ETL. We will convert ESMA XML files (these files contain the reporting specifications and ...

Convert FpML XML to BigQuery

Anvesh Gali BigQuery, XML

About this walk-through In this walk-through we will load XML files processed by Flexter into BigQuery. Flexter is a powerful XML parsing tool that can convert complex XML files into readable format which can then be loaded into BigQuery which is an enterprise data warehouse available on the Google cloud platform. FpML XML Data We have chosen the XML data ...

Automating XML Conversion with Oracle's ETL Tool ODI

Uli Bethke Big Data, Data Warehouse, Flexter, Oracle Data Integrator (ODI), XML

In the previous posts we demonstrated how Flexter liberates data from complex XML  files (Converting complex XML to CSV and Bulk loading XML files to Oracle with Flexter), we also presented the challenges when using ODI for the same purpose (Tips for Reverse Engineering complex XSDs such as SEPA and NDC in ODI and Tips for Parsing and Loading complex ...

Parsing XML to Oracle. ODI vs Flexter Enterprise XML Parser

Maciek Kocon Flexter, Oracle, Oracle Data Integrator (ODI), SQL, XML, XSD

In some previous posts we demonstrated how to load XML data into an Oracle database using ODI. We first looked at some of the issues when reverse engineering an XSD in ODI. Next we looked at various issues when parsing and processing XML files in ODI. We also showed that Flexter parses XML files without creating a single data flow ...