RE: 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?

Pshah Beginner Asked on July 15, 2019 in Diyotta Studio.
Add Comment
1 Answers

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.

RE: How do we ingest data from a flat file to any relational database table in Diyotta?

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.

RE: How do we ingest data from a flat file to any relational database table in Diyotta?

 

From the target end, we have load properties which defines the properties which we have for the target.

 

RE: How do we ingest data from a flat file to any relational database table in Diyotta?

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.

Expert Answered on July 15, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.