Oracle SQL Developer Data Modeler with Snowflake

Federico Sicilia Oracle, Snowflake

Why Oracle SQL Data Modeler Oracle Sql Developer Data Modeler (SDDM) is a free-to-use data modeling tool born to support developers while designing their database, or architecture, at a logical, relational or physical level, even storing and versioning changes in an easy and comprehensible way. However, if you are a data engineer, then you might have already used it at ...

Converting and analysing Rugby JSON data to Oracle Data Visualization Desktop

Uli Bethke Flexter, JSON, Oracle

Here is another post that will show how you can work with the output from Flexter to analyse your data. In this post we will show you how to convert complex JSON files to Oracle Data Visualization Desktop. Oracle Data Visualization Desktop Oracle Data Visualization Desktop is a competing product to Tableau and PowerBI. It makes it easy to visualize ...

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.

Convert Oracle XMLTYPE to Oracle tables

Chinmay Sinha Oracle, XML

In this example we will read XML data from a table with an XMLTYPE column in the Oracle database and convert the XML to tables in the same Oracle database. We will use Flexter to extract the data to and from the same database in this example. We need to give Flexter table and column name that contains the XML ...

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 ...

Tips for Reverse Engineering complex XSDs such as SEPA and NDC in ODI

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

In this post we will show you a few tips and ODI issues when reverse engineering complex industry XML schemas (XSD) such as NDC FlightPriceRS or SEPA Pain.001. This is the first part in a multi part series. The second part gives you some tips and tricks when parsing XML files in ODI. The third part compares ODI to Flexter, ...