...
- Go to www.mydbsync.com and, click on CustomerLogin. Enter your Username and Password and click on Development Studio to open the Project console.
- Create a project with a project, process, workflow. Use the names of your choice.
- Click on Connectors on the left section of Project Console and create a DB and an FTP connector. (Note: Enter the required details in Database and FTP credentials in the fields and validate the connections).
- Click on Project ->Process -> Workflow
- From the Workflow section, proceed to the Trigger Section.
- In the Triggers section, you can use three tabs - namely, Query Builder, Advanced Query Builder, & Properties. You need to select data-source as FTP. You can make additional changes to the Query by using the Advanced View section of the Advanced Query Builder.
- In the Rules section, select target connector as "Database", operation, target object respectively.
- Click on Map to see the Mapping screen. You will see a list of Database fields in the left section. On In the right section, in Schema, you see a list of selected File columns.
- Drag & drop the fields from Schema next to the required Database fields. Click on Save and Close once the mapping is completed. Now, click on Save Workflow.
- Ensure that Workflow status is On.
- You are now ready to run the sync. Click on the Run Button on the Top Right corner of the page.
- After successful sync, open the log and the table. Check and make sure that the data has been rightly inserted into the database table.
...
{"serverDuration": 103, "requestCorrelationId": "d0c342bbdea1dc00"}