You must add an external data system to CCS before you can import data into CCS. Use the Add Data System wizard to add a new data system.
To add an external data system
Go to Manage > External Data Integration.
On the taskbar, click Add External Data System.
In the Specify the External Data System panel, provide the System name and then click Next.
In the Specify Data Connection Parameters panel, provide the Connection name, Data import site, and Connection type. Click Next.
In the Select Data Fields panel, select the data fields that you want to include when you import the external data and then click Next.
You must select minimum two fields to import data.
In the Select Data Schema panel, select one of the following options and then click Next:
Create new schema
The Map Data Fields to CCS Schema Fields panel displays the data fields that you specified in the Select Data Fields panel.
Do the following and then click Next:
Drag the data fields from the Field Name column in the left-hand box to the Mapped Field Name column against the corresponding CCS field in the right-hand box. To identify unique fields in the external data, you must map the external data fields with key fields in the schema. The Is a Key Field column in the existing schema displays the key fields in the schema. If all the external data fields are mapped to CCS schema, go to 12.
Check Extend CCS Schema to import unmapped fields if you want to extend the selected CCS schema to import the fields that are unmapped, and click Next.
The Associate imported data with CCS panel displays the data fields that you specified in the Select Data Fields panel or the fields that were unmapped in the Map Data Fields to CCS Schema Fields panel.
Enter the following information in the CCS fields list box and then click Next:
CCS data type
Is a key field
Perform this step only if you have selected a data type as DateTime, in 8
In the Format and Date Time panel, provide the following information and then click Next:
Evaluation date field
In the Data Import Schedule panel, select one of the following schedule options and then click Next:
Select this option to run the job immediately after you click Finish.
Select this option to run the job on a specified date and time.
Provide the following information:
Run every <number of days>
In the Email Notification panel, check Send Notification if you want to send a notification upon the success or failure of the data import execution. Both the tabs in the Email Notification panel contain the same options. Enter the required information and then click Next:
In the Summary panel, view the summary and then click Finish.