Overview |
In this article you will learn how to transfer data from a file residing in an FTP server to a table in a database. First, you will see a data flow diagram, a process map and a field mapping. Then you will learn the preliminary steps necessary to prepare a database. Finally, you will see how to create your integration.
Data Map |
In this case we are matching data from a file to data in a database. There is no specific requirement on names. All that is necessary is that the columns belonging to a table in the database must be mapped by the user to the columns defined in the file. For example the below table matches the columns of a table named Account (see below Preliminary Steps) with the fields in the file.
Preliminary Steps (Database preparation): |
Database Script : MYSQL | Database Script : SQLSERVER | Database Script : Oracle | |||
|
|
|
Creating the Integration |
Once you have your database ready, do the following steps: