{"repo":"dalenewman/Transformalize","free":true,"listed":false,"github":"https://github.com/dalenewman/Transformalize","clone":"git clone https://github.com/dalenewman/Transformalize.git","description":"Configurable Extract, Transform, and Load","language":"C#","stars":162,"topics":["etl","etl-framework","denormalize","elasticsearch","solr","sql-server","mysql","postgresql","sqlite","files"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Transformalize Transformalize is a configuration based ETL tool that automates incremental denormalization of relational data. It may be used for other types of ETL as well. The supported providers are SQL Server, MySql, PostgreSql, SQLite, Elasticsearch, Excel, Files, Mail, GeoJson, Console, Razor, Forms, Bogus, JSON, Lucene, and Solr. --- Getting Started This readme demonstrates how to denormalize a relational database and load it into Elasticsearch. To follow along, see the prerequisites. When you start denormalizing a database, it's good to have a diagram. This shows eight normalized tables related to Order Details . This section introduces , , and the page and size attributes. Transformalize arrangements are written in XML or JSON. They are validated before execution. To get started, open VS Code and paste this in: This defines an input as the Order Details table inside the Northwind database. Save it as NorthWind.xml and press CTRL-P to find and execute the tfl:run command. Transformalize returned the first page of rows from the Order Details table. To transform and save this data, the must be defined. Introducing . To see the schema, press CTRL-P to find and execute the tfl:schema command: tfl -a NorthWind.xml -m schema ... <fields> <add name=\"OrderID\" type=\"int\" primary-key=\"true\" /> <add name=\"ProductID\" type=\"int\" primary-key=\"true\" /> <add name=\"UnitPrice\" type=\"decimal\" precision=\"19\" scale=\"4\" /> <add name=\"Quantity\" type=\"short\" /> ","default_branch":null,"files":null,"tree":[],"storefront":"/r/dalenewman","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dalenewman/Transformalize/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}