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?
    – crmprogdev
    Dec 5, 2016 at 14:51
  • We are using boomi for integration.It seems boomi does not provide utilty to create script
    – crmsj
    Dec 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/…
    – crmprogdev
    Dec 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
    – crmsj
    Dec 5, 2016 at 16:37
  • 2
    this tool can output the schema as an excel workbook schemalister.herokuapp.com so it goes part way towards your goal
    – cropredy
    Dec 6, 2016 at 1:28

3 Answers 3


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
    – crmsj
    Dec 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

enter image description here


schemalister.herokuapp.com is really helped me for my ask

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.