Establishing a Connection
Connecting with the Oracle Sales Cloud Connection Manager
Adding a new Oracle Sales Cloud connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the Oracle Sales Cloud Connection Manager from the Add SSIS Connection Manager window.
Alternatively, you can create a new connection directly using the Oracle Sales Cloud Source or the Oracle Sales Cloud Destination. You can set the connection properties in the Oracle Sales Cloud Connection Manager window.
Oracle Sales Cloud uses Basic authentication over SSL; after setting the following connection properties, you are ready to connect:
- Username: Set this to the user name that you use to log into your Oracle Cloud service.
- Password: Set this to your password.
- HostURL: Set this to the Web address (URL) of your Oracle Cloud service.