Creating a data source type

You must create a data source type to enable data acquisition from a data source, which is not predefined in OnCommand Workflow Automation (WFA).

Before you begin

Steps

  1. Click Data Source Design > Data Source Types.
  2. Click New icon on the toolbar.
  3. In the New Data Source Type dialog box, enter or select the required details in the Data source, Data source version, and Scheme fields.
  4. In the Default port field, enter the port number.
    Example
    2638
    The port number you have entered is populated when you add this data source type for data acquisition. By default, the port is used by WFA to communicate with the data source and the port should be open on the data source server.
  5. From the Method list, select the method that WFA must use to acquire data:
    If you have selected... Then...
    SQL From the Driver type list, select one of the following drivers that is appropriate for the data source:
    • Sybase jConnect3
    • MySQL Connector/J
    • MySQL Server JDBC Driver 3.0
    • Oracle JDBC Driver 11.2.0.3
    SCRIPT In the Script field, enter the PowerShell script that is used to connect and retrieve data from the data source.
    Note: The data in the dictionary entry equivalent CSV files should include tabs as field separator. For example, see the PowerShell script for the VMware vCenter data source type.
  6. Click Save.