How do we ingest data from a flat file to any relational database table in Diyotta?
How do we ingest data from a flat file to any relational database table in Diyotta?
We can ingest data from any Flat file to a relational database table in Diyotta through a data flow. We can create a dataflow under generic or any native databases for which we are licensed. Drag the source file and target table into the data flow and link them.
Under file source we have extraction properties in which we have File Name property to refer the file we are using. File should be available in the location which we mention in the File data point.
From the target end, we have load properties which defines the properties which we have for the target.
We must execute the data flow using Run option in the Actions tab and view the target data in the Data table available in the target transform.