You are here:
Oracle Eloqua Connection
Create a remote connection using the Oracle Eloqua connector to sync data from Oracle Eloqua to CRM Analytics.
Create the Connection
- On the Data Manager Connections tab, click New Connection.
- Click the name of the connector, and click Next.
- Enter the connector settings.
- To validate your settings and attempt to connect to the source, click Save & Test. If the connection fails, CRM Analytics shows possible reasons.
All settings require a value, unless otherwise indicated.
| Connection Setting | Description |
|---|---|
| Connection Name | Identifies the connections. Use a convention that lets you easily distinguish between different connections. |
| Developer Name | API name for the connection. This name can’t include spaces. The API name is used in your recipes to reference data extracted through this connection. You can’t change the developer name after you create the connection. |
| Description | Description of the connection for internal use. |
| Base URL | URL to connect to the Eloqua application. Enter in the format https://<Base Name>.eloqua.com The data center that hosts your Eloqua account determines the base URL. For help with finding your account’s base URL, see Determining base URLs in the Oracle Eloqua Developer Help Center. For example: |
| Username | User name for the Eloqua account. |
| Time Zone Offset | Time zone in the Eloqua system settings relative to GMT. For example, if the Eloqua system time zone is GMT-06:00, enter -06:00 |
| Domain Name | Company name for the Eloqua account, used at Eloqua sign-in. |
| Password | Password for the Eloqua account. |
Oracle Eloqua Connector Considerations
Keep these behaviors in mind when working with the Oracle Eloqua connector.
- Connected object names must start with a letter and contain only letters, digits, or underscores. Object names can’t end with an underscore.
- Only field names with combinations of alphanumeric, dot, underscore, or dash characters are supported. If a connector includes field names that contain other characters, such as spaces or brackets, the sync fails.
- The connector can sync up to 10 million rows or 5 GB per object, whichever limit is reached first.
- Object names must not contain special characters, such as spaces.
- You can select up to 250 fields for each connected object.
- You can export up to 5 million activity records from Oracle Eloqua. For more information, see the Oracle Eloqua export limits.
