You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-04-03 23:00:45

wjlgatech
Member
2 posts

wjlgatech said:

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?

Offline

#2 2017-04-04 09:50:10

premchand.kar
Member
16 posts

premchand.kar said:

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

Offline

#3 2017-04-05 17:17:59

wjlgatech
Member
2 posts

wjlgatech said:

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.

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy