One Star

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?
2 REPLIES
One Star

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

Hi,
Is the file structure and schema are same for all ?
Thanks,
Premchand
One Star

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

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.