Salesforce Data Asset Properties
Create a data asset to extract data from a Salesforce data source.
The Salesforce DI Connector, by design, doesn't automatically synchronize with any metadata changes made in the source system after creating a Data Asset. You must update the Data Asset to ensure that such metadata updates are reflected in existing Data Assets within a DIS (Data Integration Service) workspace. This update can be as simple as adding more information to the description.
You can use a secret for the password. See OCI Vault Secrets and Oracle Wallets.
To create a data asset that connects to a Salesforce source, complete the following properties and connection details.
The salesforce user used in Data Asset should have API access enabled. For best performance, we recommend using a user that has access to specific Salesforce objects that you intend to extract data from. If the user has many more permissions, the first attempt to connect to Salesforce might fail but pass after a few minutes if all the provided details are correct. For Salesforce, an async schema creation process happens as part of establishing connection.
| Field | Description |
|---|---|
| Properties | |
| Name |
Enter a name for the data asset. |
| Identifier |
The identifier is a system-generated value based on the name you specify. You can change the identifier value, but after you create and save the data asset, you can't update the identifier. |
| Description |
Add a description. This field is optional. |
| Type | Displays the data asset type based on the icon you select in the Select data asset type panel. For more information, see Creating a Data Asset. |
| Host |
Enter the IP address of the host. |
| Port |
Enter 443, the default port for HTTPS-enabled endpoints. |
| Default connection information | |
| Name |
Enter a name for the default connection. |
| Identifier |
The identifier is a system-generated value based on the name you specify. You can change the identifier value, but after you create and save the connection, you can't update the identifier. |
| Description |
Add a description. This field is optional. |
| Username |
Enter the username. |
| Use password |
If you select this option, in the Password field, enter the password appended by the security token. For example, pwdXaBARTsLZReM4Px47qPLOS, where pwd is the password and the rest is the security token. The password and security token are case-sensitive. |
| Use vault secret OCID |
If you use a secret in Oracle Cloud Infrastructure Vault to store the password, select this option. The following field appears:
|
| (Optional) Test connection | |
| Test connection |
After you complete all the required fields, you can click Test connection to ensure you have entered the data asset details correctly. A success or failure message displays, indicating whether the test was successful or not. If the test fails, review your connection settings and try again. |