Create a SQL Data Source

Edit online

About this task

To create a SQL data source:

Procedure

  1. Right-click the SQL root element. From the shortcut menu, select Properties.
  2. In the SQL File Properties dialog box, click the Data Sources tab to access the data source options.

    For more information about properties, see Sterling B2B Integrator Map Editor Properties.

  3. Click SQL Data Sources.
  4. If you want to select a computer data source, select the Machine Data Source tab in the SQL Data Sources dialog box.
    Note: Map Editor does not support file data sources.
  5. In the Machine Data Source tab, select the computer data source you want to use and click OK.

    Sterling B2B Integrator Map Editor closes the Select Data Source dialog box and displays a Login dialog box.

  6. Verify the login information and click OK.
  7. In the SQL File Properties Data Sources tab, complete the following fields:
    • DSN (required)
    • DATABASE (optional)
    • Password (optional)
    • User-defined name for this data source (optional)
  8. Click Add.

    Sterling B2B Integrator Map Editor adds the data source to the list and prompts you that it is creating the schema for that data source if you selected the connect option.

  9. Do you want to test the connection to a data source?
    • If Yes, select the data source and click Test Connection.

      Map Editor attempts to rebuild the schema whenever you perform an update or check database consistency, and it tests all queries running against that data source.

      Sterling B2B Integrator Map Editor tests the connection of the selected data source and prompts you with a dialog box containing the results of the test. Click OK to close the dialog box.

    • If No, continue with the next step.
  10. Click OK to close the SQL File Properties dialog box.