Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

9.7. Import From Salesforce

You can create relational source models from your Salesforce connection using the steps below.

Note

Depending the detail provided in the database connection URL information and schema, Steps 5 through 7 may not be required.
  1. In Model Explorer, right-click and then click Import... or click the File > Import... action in the toolbar or select a project, folder or model in the tree and click Import...
  2. Select the import option Teiid Designer > Salesforce >> Source Model and click Next>
  3. Select existing or previous connection profile from the drop-down selector or click New... button to launch the New Connection Profile dialog or Edit... to modify or change an existing connection profile prior to selection. Note that the Connection Profile selection list will be populated with only Salesforce connection profiles.
    Select Salesforce Credentials Dialog

    Figure 9.24. Select Salesforce Credentials Dialog

  4. After selecting a Connection Profile, enter the password (if not provided). Click Next> to display the Salesforce Objects selection page.
    Select Salesforce Objects Dialog

    Figure 9.25. Select Salesforce Objects Dialog

  5. On the Target Model Selection page, specify the target folder location for your generated model, a unique model name and select desired import options. You have to enter the JNDI name. Click Next> (or Finish if enabled).
    Target Model Selection Dialog

    Figure 9.26. Target Model Selection Dialog

  6. If you are updating an existing relational model, the next page will be Review Model Updates page. Any differences. Click Finish to create your models and tables.
    Review Model Updates Dialog

    Figure 9.27. Review Model Updates Dialog

  7. When finished, the new or changed relational model's package diagram will be displayed showing your new tables.
    New Saleforce Tables Diagram

    Figure 9.28. New Saleforce Tables Diagram