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

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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now