Automatic import sets

[ant_niopires]

Hi all,

I have a question about import sets.

I want to make regular (once a week) data updates to a table created in my instance.

Is there a way to automate an import set to run at x hours, on y day, using the same data source, with the created transform map

and to the same target tabel? and that repeats itself after a few days?

This way i could only change my data in the data file and then the update in my instance would be done.

If this is not possible, is there a close solution to this? Maybe not everything in this process can be automated but perhaps

some of the steps on it might be automated.

Thank you for you attention,

António Pires

[Rakesh Mamidi · Accepted solution]

You can schedule a data source- Create a entry in "scheduled_import_set" table

[ant_niopires]

Thanks for your fast reply.

So, if i have say a local excel file with my data. If i change the data in the file will it be captured only by doing the schedule import set?

Meaning, the scheduled import set, besides running the transform map also fetches the updates done in a local file to the corresponding data source?

Thanks again

[Rakesh Mamidi]

Nope, scheduled import set will only transform data from current file to target table.

In the data source if you use the FTP or SFTP method in that case , you always make a unique file name in local and transform

[ant_niopires]

If the method is either FTP or SFTP, changes in the local excel file will be reflected in the Data Source?

Thanks