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

The future of ETL and the limitations of data virtualisation and NoETL.

Uli Bethke ETL

Data has limited value if we don’t transform, integrate, model (either data modelling and building predictive models) or cleanse it. Collecting raw data for no apparent reason or business case leads to the widespread data hoarding disorder. The concept of NoETL and related ideas of data federation for logically integrating data from disparate data stores (now rebranded as data virtualisation) ...

Sampling in Snowflake. Approximate Query Processing for fast Data Visualisation

Martin Goebbels Snowflake

Introduction Making decisions can be defined as a process to achieve a desirable result by gathering and comparing all available information. The ideal situation would be to have all the necessary data (quantitatively and qualitatively), all the necessary time and all the necessary resources (processing power, including brain power) to take the best decision. In reality, however, we usually don't ...

Converting NETCONF XML to SQL Server tables

Uli Bethke Flexter, MS SQL, XML

In this guide we will show you how to process NETCONF XML files with the enterprise version of Flexter and convert it to SQL Server. NETCONF XML The Network Configuration Protocol (NETCONF) is a network management protocol developed and standardized by the IETF. NETCONF provides mechanisms to install, manipulate, and delete the configuration of network devices. Its operations are realized ...