Data sources custom(load from script) example

[TM19]

Hi
I want to try out the data source of type 'Custom (Loaded from script)'. Is there any place where I can get a sample of the same to get the basic idea of its syntax and other rules?

[Ankur Bawiskar]

Hi,

If your question is still unanswered I would encourage to set this to unanswered so that people can help you and advice you.

If it shows as answered people tend to ignore the questions.

If you want to take data from table X and load to another table then 2 approaches

1) get table X data in excel and then create data source, transform map, field map etc

OR

2) use scheduled job to insert table X data to another table

Also for future insert you can use after insert BR on table X which would insert data into table B

Regards
Ankur

[Ankur Bawiskar]

Hi,

Let me know if I have answered your question.

If so, please mark appropriate answer as correct & helpful to close the thread.

If not, please let us know if you need some more assistance.

Regards
Ankur

[louis5]

The documentation mentionned getting data from attachment but I couldn't find any information about how we can get the attachment from the current data source. I'm using sys_import.do which create a clone of the original data source. So I could use the import table name and other criteria to get the data source sys_id (current is not defined) and then retrieve the attachment but I was wondering if there is a better solution.