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?
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.