Configuring a Web Service
You must add a Web services data connection to import data from a data system by using a Web service.
- To configure a Web service data connection
- Go toManage > External Data Integration.
- From the External Data Systems list, select the data system and then do one of the following:
- From the taskbar, selectSystem Tasks > Add Data Connection.
- Right-click the data system and then selectAdd Data Connection.
- In theSpecify the External Data Systempanel, do the following and then clickNext:System nameEnter a name for the external data system that you want to add.DescriptionAdd a brief description on the external data system.This step is optional.
- In theSpecify Data Connection Parameterspanel, do the following and then clickNext:Connection nameEnter the name of the external data connection that you want to create.Data import siteSelect a site to route the job to the CCS Managers that are present in it.Connection typeSelectWeb service.Data LocationTo specify a new data location, clickNew.
- In theAdd Data Locationdialog box, provide the following information and then clickOK:NameEnter a name for the data location that you want to create.DescriptionEnter a brief description about the data location that you want to create.Discovery URLEnter the metadata (WSDL) URL of the service.Click Discover to auto-populate theService URLdrop-down list with the available endpoints.Service URLDisplays the available endpoints that are available at the specified location.Enter the endpoint URL or select the appropriate endpoint from the list.Binding TypeSelectBasic HTTP,WSHTTP, orBasic HTTP(SSL)from the drop-down list.User nameProvide the user name to connect to the service.PasswordProvide the password to authenticate the user account that you have specified.Confirm passwordRe-type the password.Test ConnectionClick to test the connection to the Web service.
- After specifying the data location, the parameters for scoping the data are displayed in the Parameters grid. This information is fetched from the GetParameterInformation method implemented in the Web service. In the Parameters grid, for each parameter, in the Values column, click the (...) button to add the parameter value.
- In theWeb Service Parameterdialog box, from theValues to adddrop-down list, enter the parameter value or select the appropriate value from the list, and clickAdd.You cannot set multiple values for a parameter.
- ClickOKand then clickNext.
- In theSelect Data Fieldspanel, select the data fields that you want to include when you import the external data and then clickNext.You must select minimum two fields to import data.
- In theSelect Data Schemapanel, select one of the following options and then clickNext:Create new schemaSchema is a representation of external data in CCS.Enter the following information:
- In theSchema nametext box, enter a name for the new schema that you want to create.
- In theDescriptionfield, enter a brief description of the new schema.
If you clickCreate new schema, then go to Step 12.Existing schemaFrom theSelect CCS schemadrop-down list select the matching CCS schema to the external data.If you clickExisting schema, then go to Step 11. - TheMap Data Fields to CCS Schema Fieldspanel displays the data fields that you specified in theSelect Data Fieldspanel.Do the following and then clickNext:
- Drag the data fields from theField Namecolumn in the left-hand box to theMapped Field Namecolumn 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. TheIs a Key Fieldcolumn in the existing schema displays the key fields in the schema. If all the external data fields are mapped to CCS schema, go to Step 16.
- CheckExtend CCS Schema to import unmapped fieldsif you want to extend the selected CCS schema to import the fields that are unmapped, and clickNext.
- TheAssociate imported data with CCSpanel displays the data fields that you specified in theSelect Data Fieldspanel or the fields that were unmapped in theMap Data Fields to CCS Schema Fieldspanel.Enter the following information in theCCS fieldslist box and then clickNext:CCS FieldDisplays the fields that you selected in theSelect Data Fieldspanel.Click the CCS field name to edit the name.CCS data typeSelect the data type from the drop-down list.For Incremental Data Import select the data type of one of the fields as DateTime.This field is used for incremental data collection as evaluation date time field. In incremental data import, the records only beyond the maximum date in the evaluation date time field, are fetched in subsequent imports.DescriptionAdd some description text for the field.Attribute ofSelect the CCS attribute to which you want to map the specified external data field. For example, Asset, Assessment, or Status.Is a key fieldCheck to specify if the selected field is a key field. Key field is a mandatory field in CCS schema.You must specify minimum one field as a key field for asset and assessment.
- Perform this step only if you have selected a data type as DateTime, in Step 12In theFormat and Date Timepanel, provide the following information and then clickNext:Evaluation date fieldThis field is used for incremental data collection. In incremental data import, the records only beyond the maximum date in the evaluation date time field, are fetched in subsequent imports.Select the evaluate date field from theEvaluation date fielddrop-down list.Date-time formatSpecify the date time format that you want to apply for all DateTime fields in the schema.To specify the date time format for a particular field, select the date time format in Date Time Format column for that field, in the schema.CheckApply to all fieldsif you want your selection to be applied to all the DateTime data fields.Refer to the Date-time formats supported in Control Compliance Suite section to view the datetime formats supported while importing external data.Time zoneSelect the time zone.To specify the time zone for a particular field, select the time zone in Time Zone column for that field, in the schema.CheckApply to all fieldsif you want your selection to be applied to all the Time Zone data fields.
- In theData Import Schedulepanel, select one of the following schedule options and then clickNext:
- Run nowSelect this option to run the job immediately after you clickFinish.
- Run periodicallySelect this option to run the job on a specified date and time.Provide the following information:Start onSelect the date and time to execute the data import.Run onceSelect this option to execute the data import one time on the specified date and time.Run every <number of days>Select this option to specify how often (in days) you want to schedule the data import execution.
- In theEmail Notificationpanel, checkSend Notificationif you want to send a notification upon the success or failure of the data import execution. Both the tabs in theEmail Notificationpanel contain the same options. Enter the following information and then clickNext:SubjectEnter the subject of the notification mail.MessageEnter the message of the notification mail.From (Email ID)Enter the sender's email ID.To (Email IDs)Enter the receiver's email ID.Notification can be sent to multiple recipients. Separate each email ID with a comma.
- In theSummarypanel, view the summary and then clickFinish.