Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Export objects with metadata from salesforce and import into MySQL

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?
Labels (4)
3 Replies
TRF
Champion II
Champion II

Hi,
In Salesforce, metadata are available using... Salesforce Metadata API
Anonymous
Not applicable
Author

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)
TRF
Champion II
Champion II

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