Configuring the Connection to the Oracle Database with the SQL Gateway Console

Preconditions

Before you configure the connection to the Oracle database with the SQL Gateway Console, make sure that you already executed the steps for establishing an Oracle connection:

Step 1: Set up the PC on which you intend to install the SQL Gateway.
Step 2: Set up your Oracle database.
Step 3: Install the SQL Gateway.

To configure a connection to a database, you first have to configure a general Database Server for Oracle. In a second step, configure one or more Database Connections to specific databases that are accessible via the Database Server.

Configuring Access to Database Servers

This procedure describes how to define the access to a database server:

Step	Action	Remark
1	In the Configuration tab of the SQL Gateway, right-click the Database Servers node in the tree structure on the left-hand side and execute the command New Database Server.	Result: A new subnode with a default name is created.
2	Enter a unique Server Name in order to identify this database server.	–
3	Select Oracle from the Server Type list.	After you have selected Oracle as Server Type, the configuration parameters described in this chapter are displayed.
4	Enter the Server Address in order to identify the Oracle instance.	The Server Address contains the host name or IP address of the Oracle PC: If the Oracle is running on the same PC as the SQL Gateway, enter `localhost` as `host-name`. For a detailed description of the address formats, refer to your Oracle user documentation.
5	Select the Authentication Mode.	–
6	Enter login information.	–
7	Click the Test Server Connection button in order to verify whether the connection to the database server can be established with the parameters configured. Result: A message is displayed indicating the result of the test.	To test the server connection, you must define a default service in the Oracle configuration beforehand.

Configuring the Database Connections

This procedure describes how to create a connection to a specific database:

Step	Action	Result/Remark
1	In the Configuration tab of the SQL Gateway, right-click the Database Connections node in the tree structure on the left-hand side and execute the command New Database Connection.	Result: A new subnode with a default name is created.
2	Enter a unique Connection Name in order to identify this database connection.	Make sure that exactly the value of the parameter Connection Name is used in the client configuration: The element wsDbConnectionName configured in the EcoStruxure Machine Expert SqlRemoteAccess library must have the identical value as the parameter Connection Name.
3	From the Server Name list, select the database server that hosts the database you want to connect to.	The Server Name list contains entries for those servers that are defined under the Database Servers node. After you have selected a database server as Server Name, the configuration parameters described in this chapter are displayed.
4	Enter the Service Name and Service Type of the database.	The SQL Gateway does not support access via Oracle SID (System ID).
5	In order to add further parameters to the configuration of your database connection, click the Select button and activate the parameters of your choice in the Select Advanced Properties dialog box.	Result: After you have confirmed your selection with OK, the selected parameters will be displayed in the editor and can be configured.
6	Click the Test Database Connection button in order to verify whether the connection to the database can be established with the parameters configured.	Result: A message is displayed indicating the result of the test.