Create a data source type

Contributors

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

What you’ll need
  • You must have created the required dictionary entry and scheme if you are creating a custom data source type that is not predefined in WFA.

  • You must be aware of PowerShell scripting to create a data source type that uses the script method.

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.

    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.