I using Skyvia for data transfer from My-SQL to Salesforce.com and vice versa. But I am facing some issue over here. Please find my below questions.
I need to fetch record details from My-SQL. Because of that I need to schedule the package.
Note: The same package can be schedule for multiple times.
Example: Package1: Schedule @ 10.00 am from My-SQL.
Package1: Schedule @ 10:05 am from My-SQL.
Package1: Schedule @ 10.10 am from My-SQL
Question 1: Can we fetch the records based on the schedule job time?
Example: 1st time: When we run @10.00 am, it will pick up some records.
2nd time: When we run @ 10.05am, it should pick up the records which has createdBy 10.05am before. So that I can pickup only newly created/updated records.
3rd time: When we run @10.10am, it should pick up only the records which has createdBy 10.10am before and 10.05 after. So that I can pickup only newly created/updated records. Likewise it should continue.
Please suggest. How we need to do in this scenario?
Note: This question is mainly to avoid repeated fetch of the same records multiple times.
My contact details as below.
Phone Number: +91 8073126025.
Thanks in advance.