Activity Forums Salesforce® Discussions How exactly i can relate a database table with salesforce object ?

  • How exactly i can relate a database table with salesforce object ?

    Posted by Suraj on March 28, 2017 at 12:24 pm

    I have previously worked on oracle database so can i relate this database in anyway with salesforce objects ?

    Anita replied 3 years, 11 months ago 3 Members · 2 Replies
  • 2 Replies
  • Saurabh

    Member
    March 28, 2017 at 2:28 pm

    Hi Suraj,

    You can relate  database table with salesforce object something like that:-

    A database is simply a way to collect and organize information in a series of rows and columns.

    This table is a specific collection of data points organized by rows and columns.

    Salesforce changes the terminology a little bit. Tables in Salesforce are called Objects.

    Within the table/object, we have rows and columns. Each row is referred to as a record. Every record contains individual data points that make up the sum of that record

    The columns contain a range of data specific to the column name. Salesforce calls columns fields.

    In this way you can relate database to salesforce object.

    Moreover.

    what you see on the Accounts Tab, on the Leads Tab, on the Contacts tab etc. are in fact records that reside in the Database. And back at the Database Layer, you will have tables named Contact, Lead, and Account and so on. In fact when we create a Custom Object in Force.com, a Table is actually created at the Database Layer and when we add new Custom Fields in fact new Columns are added to the Table that you just created.

    But remember we do not have any direct access to it and the Salesforce UI is what we have at our disposal to create New Records into the Table, modify the Table by adding New Columns(aka Custom Fields) and so on.

    Hope this may help you:

    Thanks

     

  • Anita

    Member
    December 1, 2020 at 6:12 pm

    Hello,
    Please go through this link: https://www.xplenty.com/blog/the-salesforce-database-explained/ this link will help you a lot to understand.
    One more thing, if any one want to learn about Oracle, check this link: https://mindmajix.com/oracle-ebs-training
    Thanks & Regards,
    Anita

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos