Extracting Data From Oracle CRMOD

Prior to setting up data extraction from Oracle CRMOD familiarize yourself with the latest implementation and usage notes at Oracle CRMOD Connector.

To extract data from Oracle CRMOD

1. On the Home page select a space or create a new one. This is the space to which the data will be uploaded.
2. Go to Admin - Define Sources - Application Connectors. Alternatively, click the Use Extractors link on the Admin Navigation page.
3. Click New in the Connections panel.
4. In Connection Details name the connection.
5. Select Oracle CRM On Demand as the Connector Type.
6. Set the Connector API Version.

For new spaces, select the latest API version (highest version number). 

For existing spaces, test the latest API version before changing from the default API version to the latest API version.

Birst determines which version is the default. If the selected API version is no longer available in Birst, the default API version will be automatically assigned. If the default API version is selected, when Birst changes to a new API version as the default, existing spaces will be automatically upgraded to the new default API version.

7. Login to Oracle CRMOD:
h. Enter your Oracle CRMOD user name and password.
i. Enter the Oracle CRMOD site name that your company uses to connect to your Oracle CRMOD site. Oracle CRMOD refers to this as your Company Name.
j. Choose either the Production or Sandbox environment.
k. Specify a Source File Prefix. Use an alphanumeric string that Infor will prepend to the Oracle CRMOD data source names so that you can easily recognize them and differentiate objects that may have similar names. For example, use the string "OCRM" to easily identify Oracle CRMOD objects.
l. Click Login. Infor shows the list of data objects available from Oracle CRMOD, as indicated by the Show All Objects option.  
13. Select the objects you want to upload to Infor.  

Tip: For better performance, Infor recommends using the Add Object feature to select only the columns that are required for reporting rather than extracting all columns from an object. See Adding a Source Based on an Oracle CRMOD Object.
14. Click Show Selected Objects. 
15. Optionally, specify the name of one or more extract groups, separated by commas, for each object In the Extract Group Name(s) field. Extract groups make it possible to extract specific objects and process them separately from other objects.  See Creating Extract Groups.  
16. Click the Save button after adding extract group names.
Tip: To remove an object from the extraction list, click the icon in the Remove column on the right.
17. Click Extract to upload the selected objects to Infor. If you have extract groups defined, you will be prompted to select the extract group or groups to use.
Important: Selecting All in the Extract Group dialog box will extract all selected objects, even those that do not belong to extract groups.
18. Click Extract. Depending on the size of the data objects, the extraction may take a few minutes. When the extraction completes Infor lists the date and time of the extraction in the Data Sources table of the Show Selected Objects view.
Tips:

You can safely log out of Infor while the extraction takes place and log back in later.

To cancel the extraction, click the Cancel Extract link under the progress bar. 

Click the Last Extract Log link to view the logs from the data extraction and check for errors. 

19. Look at the raw data in Manage Sources page. Iterate the extraction process, if needed, to get the data you expect.

Next Steps

Setting Up Incremental Extractions from Oracle CRMOD

Process the data in the Process Data, Process New Data page. See Processing Data.

Set up scheduling in the Process Data, Schedule Data Processing page. See Scheduling Extraction and Data Processing for Cloud Applications.