Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-04-03 07:00 PM

how to backup hundreds of schema/files from SalesforceDB to postgreSQL

I want to backup hundreds of schema/files from SalesforceDB to postgreSQL. The Salesforce schemas/files are under
Repository>Metadata>Salesforce>myDB>.
In the case of several schemas/ files need to backup, I use Designer to build the job:
SFfile1->tMap1->tPostgresqlOutput_1
| OnSubjobOK
SFfile2->tMap2->tPostgresqlOutput_2
| OnSubjobOK
SFfile3->tMap3->tPostgresqlOutput_3
...
But now I have hundreds of Salesforce files to be backup. Since the subjobs have the same structure, I guess there must be programatic way to do it, instead of manually building subjob one by one. NOW HOW?
Labels (3)
Labels
77 Views
0 Likes
2 Replies
premchandkar
Contributor
Contributor
‎2017-04-04 05:50 AM

Hi,
Is the file structure and schema are same for all ?
Thanks,
Premchand
77 Views
0 Likes
Anonymous
Not applicable
‎2017-04-05 01:17 PM
Author

Simply put those files/schemas are tables with each row as a record and each column as a feature. Those tables are not totally independent in Salesforce's end, but here I do NOT need to worried about their dependency and the issues related to how to restore them back to the Salesforce.
77 Views
0 Likes