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

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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.