You can load the ETL into a CSV file, and save the new file to a shared folder location. When the ETL is run, the data will be loaded into the given file. Each table in the data flow will be saved to a separate CSV file. To use a CSV file as a target, add the CSV node from the Targets panel to the data flow.
Configure a CSV Target
From the target's Properties panel, name the new database that will be created, and provide a pointer to a shared folder where the file will be located:
- Database Name: name the new database that will be generated when the ETL is run.
- UNC Path: provide a pointer to a shared folder where the new database will be saved.
- Separator: select the value separator from the drop-down.
- Create Folders: generate folders and save the database file within these folder:
- Database Name: create a folder named according to the given database name, and save the database file inside this folder.
- Date Time: create a folder named according to the date and time at which the ETL is run, and save the database file inside this folder. If a database folder is also created, the Date Time folder will be a subfolder.
Finally, click ‘Connect All’ to connect the target node to the data flow. As usual, you can add a description to the node's Properties panel.
Expand the Description window to add a description or notes to the node. The description is visible only from the Properties panel of the node, and does not produce any outputs. This is a useful way to document the ETL pipeline for yourself and other users.
Run the ETL
- Click here to learn how to process the ETL.
In this example, the ETL was loaded from an SQL server into an CSV database. As seen in the Target properties (green highlight below) the CSV target database was named 'Customers' and saved to a shared folder call DataModeling. Both Database Name and Date Time folders were enabled before connecting the tables to the target. The next step is to process the ETL.
Once the ETL is executed, the CSV files are saved to the given folder location, inside the Database Name folder and Date Time subfolder. Here we see the database folder 'Customers':
Inside the 'Customers' folder is the Date Time subfolder:
The CSV database files are inside the Date Time subfolder. Each table in the ETL is converted to a separate CSV file.