topic Export objects with metadata from salesforce and import into MySQL in Talend Studio

Export objects with metadata from salesforce and import into MySQL

Anonymous — Sat, 16 Nov 2024 10:06:29 GMT

Hi. I would like to analyse the whole data model of one salesforce org using some DQ tool, such as Talend Studio for Data Quality. From what I understand I cannot create connection to salesforce. I have to import all objects to either Access, MySQL or another database to where I can connect with Talend Studio for DQ.
So in my case I created MySQL db for that purpose and used Talend Studio for DI to export objects and import into db. This is however time consuming as I need to move them one by one and add relationships and if you have about 100 objects... horrible. Is there a way how to easily export multiple objects including metadata (such as relationships) and import them into db?

Re: Export objects with metadata from salesforce and import into MySQL

TRF — Thu, 02 Feb 2017 13:56:07 GMT

Hi,
In Salesforce, metadata are available using... Salesforce Metadata API

Re: Export objects with metadata from salesforce and import into MySQL

Anonymous — Thu, 02 Feb 2017 16:02:13 GMT

Hi TRF, yes I know.. Im rather business analyst though, not developer and kind of new to DBs, integrations, apis etc. So all I need to know is if there is a way to export e.g. whole data model (all objects) out of salesforce including all relationships in simplified way? (I mean not object by object, then metadata, etc)

Re: Export objects with metadata from salesforce and import into MySQL

TRF — Thu, 02 Feb 2017 16:59:13 GMT

You export export WSDL from Salesforce but how to create tables in MySQL from this XML file?
Maybe someone already did it...