Is there a simple process to create a flat file (CSV) Connector?
Release : 14.3
Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)
A data source is a reference to schema-related information that Connector Xpress uses to map with a connector. You can connect to the data source to read its schema and then use Connector Xpress to map the schema to a new endpoint type.
When you create a Connector Xpress project, Connector Xpress prompts you to set up your data sources. In this example we are using a simple CSV flat file.
Example Data Source (No header):
Follow these steps:
1. In Connector Xpress, click New ProjectThe Source Types dialog appears.
The Edit Source dialog appears, specific to the type of data source you are adding.
The Enter Password for Data Source Dialog appears.
9. Enter the password for the selected data source, then click OK.The Save Project As dialog appears.
18. Specify the folder to save the connector project in, the file name and the file type for the saved connector, and click Save.Connector Xpress saves the project.
We recommend that you use the default file extension (.con) and that you keep a copy of the project. You cannot view the stored procedure bindings after you deploy a connector, unless you open the Connector Xpress project file where your bindings are stored.
You can create an endpoint type using the loaded metadata.
You can only create an endpoint type when a Connector Xpress project is open.
Follow these steps:
1. Open the Flat File project.The Create New Endpoint Type dialog appears.
3. Complete the fields on the dialog, then click OK.You have defined the name of your new endpoint type and added the endpoint type to the Endpoint Types node of the Provisioning Server you specified.
You can select a connector server to manage a particular endpoint type or endpoint from the endpoint type node.
Follow these steps:
1. In the Provisioning Servers tree, right-click the endpoint type you want to manage, then click Set Managing CS.The Select Connector Servers dialog appears.
2. Select the Connector Server or Connector Servers from the list, then click OK.You have specified the Connector Server or Connector Servers you want to manage. Connector Xpress adds the endpoint type or endpoint to the managed branches of the selected Connector Servers.
Once you have created a connector, you can deploy the metadata for that connector to a Provisioning Server.
This procedure assumes that you have created the connector server configuration.
Follow these steps:
1. Open the existing project that contains the metadata you want to deploy.Connector Xpress opens the project and displays the metadata in the Edit pane of the Connector Xpress window.
2. In the Provisioning Servers tree, expand the Provisioning Servers node and then choose the server where you want to deploy the connector.The Provisioning Server Password Required dialog appears.
3. Complete the fields on the dialog to specify the password for the server, and click then OK.The Create New Endpoint Types dialog appears.
5. Complete the fields on the dialog to define the name of your new endpoint type, then click OK.In some cases, a delay occurs before endpoint management screens are available. To check the status of the screen creation, use View Submitted Tasks in the User Console or configure a workflow process to send an email notification when the deployment completes.
6. Right-click on your new endpoint and select Acquire Endpoint.The Create New Endpoint dialog appears.
7. Complete the fields on the dialog to specify the name and password for your new endpoint, then click OK.The Explore/Correlate Endpoint dialog appears.
9. Complete the fields on the dialog to specify how Connector Xpress explores and correlates the endpoint, then click OK.Connector Xpress deploys the connector to the Provisioning Server.
After you deploy a connector, you can explore and correlate endpoint content in the Provisioning Manager.
Follow these steps:
1. Log into the Provisioning Manager as an administrator.The Explore and Correlate Endpoint dialog appears.
4. Select the Explore endpoint for managed objects and Correlate accounts to global users check boxes.The List Accounts for Global User dialog appears.
9. Click Search. The account for the global user appears.The User Account dialog appears, which shows the user and account details.