Setting the SQL connectivity

SQL connectivity is needed only if the SQL feature is used to access an SQL database in a mapping.

If you are upgrading the Mapper from an old version, existing SQL Connectivity settings are automatically imported as new entry in the SQL location list.

  1. Select Windows > Preferences.
  2. Expand the view of Mapping and select SQL Database.
  3. Click New.
  4. Specify this information:
    Alias

    Specify a descriptive name for this connection.

    Host

    Specify the IP address or the host name of the SQL server.

    Instance

    Specify the SQL Server instance name. By default, the SQL Server instance name is blank.

    Database

    Specify the host database name to access.

    Use the IEC database name, for example, IEC_Storage.

    Schema

    Specify the schema name where the database objects are located. For MSQL, specify dbo.

    Port

    Specify the SQL Server port number.

    Note: 

    Specify port number -1 if you are using a named SQL

    Username

    Specify the username to access the SQL Server.

    Password

    Specify the user password to access the SQL Server.

  5. Click OK to add the new connection in the SQL Connectivity list.
  6. Optionally, select the new SQL Server and click Test Connection to verify the connection to the SQL Server.

    If the connection is successful, the SQL Server version is shown. Otherwise, an error message is shown. Click OK to return to the SQL Server Connectivity page.

  7. Optionally, select this SQL server and click Make Default.
  8. Click Apply to save the connection settings.
  9. Click OK.
  10. Exit Eclipse.