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.
- Select Windows > Preferences.
- Expand the view of Mapping and select SQL Database.
- Click New.
-
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.
- Click OK to add the new connection in the SQL Connectivity list.
-
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.
- Optionally, select this SQL server and click Make Default.
- Click Apply to save the connection settings.
- Click OK.
- Exit Eclipse.