2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Go to www.mydbsync.com and, click on CustomerLogin. Enter your Username and Password and click on Development Studio to open the Project console.
  2. Create a project with a project, process, workflow. Use the names of your choice.
  3. 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). 
  4. Click on Project ->Process -> Workflow
  5. From the Workflow section, proceed to the Trigger Section.



  6. 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.
  7. In the Rules section, select target connector as "Database", operation, target object respectively.
  8. 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.
  9. 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.
  10. Ensure that Workflow status is On.
  11. You are now ready to run the sync. Click on the Run Button on the Top Right corner of the page. 
  12. After successful sync, open the log and the table. Check and make sure that the data has been rightly inserted into the database table.

...