Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Data migration: Which processor to use?

avatar
Contributor

Hi,

I want to migrate data from a remote db tables to a destination folder.

What processor is optimal for processing a table whose records get updated.

Thanks.

2 REPLIES 2

avatar
Super Mentor

@rafy 
Have you looked at the following processors:
1. GenerateTableFetch 
2. QueryDatabaseTable 

3. QueryDatabaseTableRecord 

Thanks,

Matt

avatar
Contributor

Thank you Sir for the reply.

Yes i have looked into them.

The issue i have is that my query statement has multiple join conditions. And also the table is incremental. 

So, someone proposed i should convert the query to a database table view, then i can now supply the view name to any of the processors you mentioned above.

Please, do you have a better approach. 

Thank you sir.