Installed connectors File Reader, Base64 to Text Converter, CSV Parser, Microsoft SQL database (see tutorial 1. Connector) and created DX Agent local (see tutorial 3. Agent)
In the following tutorial, we create a new integration task that loads the CSV file and imports the content into a Microsoft SQL database. Then we explain how to work with the contents of a Base64 file, its conversion to CSV format, data access and the difference between bulk and record-by-record data processing.
Part of the solution is using external DX Agent to get resources from your Windows machine. In our case, we set the reading CSV task step to use Agent on your machine to read CSV file.
Log in to Xeelo DX and press the Tutorials tile in the Companies section. If you do not see the company Tutorials, it is necessary to create it (see tutorial 2. Hello World!)
Press Task tile and press Add. Integration task editor appears. It consists of the task name and control panel, the information panel below it and the integration steps. Change the name of the integration task and press the check mark