> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle CRM on Demand Connector

## Intro

Oracle's CRM On Demand solutions help organizations drive sales, marketing, loyalty, and service effectiveness through a CRM that integrates with other Oracle products and services.

You connect to your Oracle CRM On Demand account in the Data Center. This topic discusses the fields and menus that are specific to the Oracle CRM On Demand connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [a DataSet Using a Data Connector](/s/article/360042926274 "Adding a DataSet Using a Data Connector").

## Prerequisites

To connect to your Oracle CRM On Demand account and create a DataSet, you must have the following:

* The user host where your Oracle CRM On Demand account is located
* Your Oracle CRM On Demand username and password

## Connecting to Your Oracle CRM On Demand Account

This section enumerates the options in the **Credentials** and **Details** panes in the Oracle CRM On Demand Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Data Connector](/s/article/360042926274 "Adding a DataSet Using a Data Connector").

### Credentials Pane

This pane contains fields for entering credentials to connect to your Oracle CRM On Demand account. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p><span class="s1"> Field </span></p></th><th colspan="1" rowspan="1"><p><span class="s1"> Description </span></p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Host </p></td><td colspan="1" rowspan="1"><p> Enter the host name where the Oracle CRM On Demand account is found. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Username </p></td><td colspan="1" rowspan="1"><p> Enter the username for the Oracle CRM On Demand account. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Password </p></td><td colspan="1" rowspan="1"><p> Enter the username for the Oracle CRM On Demand account. </p></td></tr></tbody></table>

Once you have entered valid Oracle CRM On Demand credentials, you can use the same account any time you go to create a new Oracle CRM On Demand DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Managing User Accounts for Connectors](/s/article/360042926054 "Managing User Accounts for Connectors").

### Details Pane

This pane contains two primary menus from which you select your resource and the attributes (columns) for the resource you want to appear in the DataSet. You can also add an optional query expression to filter resources.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Resources </p></td><td colspan="1" rowspan="1"><p> Select the Oracle CRM On Demand resource (record) you want to pull into Domo as a DataSet. </p><p /></td></tr><tr><td colspan="1" rowspan="1"> Attributes </td><td colspan="1" rowspan="1"> Select all the attributes (columns) of the selected resource you want to appear in your DataSet. </td></tr><tr><td colspan="1" rowspan="1"> Advanced Options </td><td colspan="1" rowspan="1"> Check this box to reveal the optional <b> Query Expression </b> field. </td></tr><tr><td colspan="1" rowspan="1"> Query Expression (Optional) </td><td colspan="1" rowspan="1"><p> Enter a query expression to filter resources in a collection. A query expression is comprised of one or more "field expressions." The maximum supported query expression length is 4096 characters. </p><p> The following is the query expression syntax: <br /><br /><code> QUERY EXPRESSION = FIELD EXPRESSION \[; FIELD EXPRESSION] <br /><br /> \[FIELD EXPRESSION] = \<Field> \<OPERATOR> \<VALUE> \[ANDOR CLAUSE] <br /><br /> \[ANDOR CLAUSE] = \<AND/OR> \<OPERATOR> \<VALUE> \[ ANDOR CLAUSE] </code><br /><br /> The following example shows a query expression with two field expressions separated by a semicolon: <br /><br /><code> AccountName='PSKDemo02' OR = 'A. C. Networks'; Reference = false </code></p> <Tip><div class="info-box-wrapper"><div class="info-box-icon-container"><span class="info-box-icon" /></div><div class="info-box-content-container"><div class="info-box-content"><span><b> Tips: </b></span></div><ul><li> Use single quotes around values. </li><li> Use the same date format as exists in the field you are writing the expression for. </li></ul></div></div> </Tip></td></tr></tbody></table>

### Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [a DataSet Using a Data Connector](/s/article/360042926274 "Adding a DataSet Using a Data Connector").