Data lake is consuming salesforce data.We need to create salesforce tables in data lake.I am looking for Salesforce Table creation script.Is there any tool or utility we can use to generate create table of salesforce objects script.Boomi is used for integration. I will appreciate your help.
-
Are you using SOAP or REST and do you own the org or are you doing the integration?– crmprogdevDec 5, 2016 at 14:51
-
We are using boomi for integration.It seems boomi does not provide utilty to create script– crmsjDec 5, 2016 at 14:59
-
I'm sorry, but that doesn't tell me anything. I suspect you're asking how to get the Org's Enterprise WSDL. See this question which should provide the answer to your question: salesforce.stackexchange.com/questions/56114/…– crmprogdevDec 5, 2016 at 15:15
-
@crmprogdev I am sorry if i did not make myself clear.I am looking for DDL for salesforce objects with filenames datatype and length etc.Enterprise WSDL does not provide that details– crmsjDec 5, 2016 at 16:37
-
2this tool can output the schema as an excel workbook schemalister.herokuapp.com so it goes part way towards your goal– cropredyDec 6, 2016 at 1:28
3 Answers
Each org will be customized and will have custom fields. The org admin should be able to provide you with the info you're seeking. For general Standard Objects, see the Object Reference. You can also use Workbench to obtain the info as well for a specific org.
In addition to that, I suggest you take a look at the SOAP Developers Guide and the REST Developer Guide. You can find the links to them from https://developer.salesforce.com/docs along with any other developer related documentation. Unfortunately, at this particularly moment, the documentation links seem to be down for me.
-
We can see fields in Workbench and WSDL document but not in friendly format of field, data type and length etc to create similar table in Outside database.Is there any place we can get that kind of information– crmsjDec 5, 2016 at 20:11
Salesforce has a way to get the metadata details of the objects and fields in the database. It isn't exactly a database creation script by itself, but it should have enough information for you to build a somewhat equivalent schema in your target database.
curl -H 'X-PrettyPrint: 1' -H 'Authorization: Bearer <sessionId>' https://<instance>.salesforce.com/services/data/v38.0/sobjects/[nameSpace__]CustomObject__c/describe