Conecting to Salesforce database

Applies to: Dataedo 23.x versions, Article available also for: 24.x (current), 10.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

Salesforce native connector was introduced in Dataedo 10.1.

Add new connection

To connect to Salesforce create new documentation by clicking Add documentation and choosing Database connection.

Image title

On the Add documentation screen choose Salesforce:

Image title

Connection details

Select authentication type:

  • Interactive sign-in - upon clicking Connect button, you will see a Salesforce webpage where you provide a Username and a Password
  • Sing in with values - in order to Connect you need to configure Connected app and then provide the values.

connection_options

Provide connection details:

connection details

  • Server URL - URL of your Salesforce organization's domain e.g. https://yourcompanyname.my.salesforce.com
  • User
  • Password
  • Consumer Key - Check out how to obtain a Consumer Key and Consumer Secret from Salesforce down below.
  • Consumer Secret

Get Consumer Key and Secret Key from Salesforce

To connect Salesforce with Dataedo app the Salesforce administrator needs to set up Connected app within the admin panel.

Step 1. Click setup icon in a top right corner and then Setup

Image title

Step 2. In the left sidebar within a PLATFORM TOOLS group you can find Apps and then App Manager. Click it to list all the connected Applications used across your organization.

Image title

Step 3. Select New Connected App on the right.

Image title

Step 4. Fill in all the required information inside the Basic Information section. Here's an example configuration: Image title

Step 5.

  1. Select Enable OAuth Settings
  2. Set Callback URL to http://localhost:5005/oauth2
  3. Make sure that Require Secret for Web Server Flow and Require Secret for Refresh Token Flow are unselected
  4. In Selected OAuth Scopes add:
    • Access unique user identifiers (openid)
    • Manage user data via APIs (api)
    • Manage user data via Web browsers (web)
  5. Submit with Save on top of the page.

Image title

Step 6. After creating Connected App you can see a summary. To unlock signing in with password:

  1. Click Manage Image title
  2. Then press Edit Policies Image title
  3. Inside OAuth Policies change Permitted Users to All users may self-authorize and IP Relaxation to Relax IP restrictions .
  4. Submit changes by clicking "Save" at the bottom. Image title

Step 7. In Setup sidebar under Settings section expand Identity menu. Go to OAuth and OpenID Connect Settings and enable 'Allow OAuth Username-Password Flows'. Image title

You might need to wait around 10 minutes to let changes propagate through Salesforce systems.

Step 8. Go to Apps > App Manager click down arrrow icon next to the newly created app and View. Image title

Step 9. You can find the Consumer Key on the left side. To get Consumer Secret click "Click to reveal" on the right and copy the key. Image title

Saving password

You can save password for later connections by checking Save password option. Password are saved in the repository database.

Importing metadata

When connection was successful Dataedo will read objects and show a list of objects found. You can choose which objects to import. You can also use advanced filter to narrow down list of objects.

Image title

Confirm list of objects to import by clicking Next.

Next screen allows you to change default name of the documentation under which it will be visible in Dataedo repository.

Click Import to start the import.

Image title

When done close import window with Finish button.

Image title

Outcome

Your Salesforce objects have been imported to new documentation in the repository.

Image title

Salesforce support

Salesforce support details