Navigation:  GeoOffice ePaper designer > Dictionary - Features > Description of the Actions > New Element > New Connection & New Data Source > Oracle Connection

The Oracle Connection is used to query data from an Oracle database, including SDE inside an Oracle environment. It is required to install the Oracle Client to use this connection type. Additionally, the connection has to be established, that the Oracle connection exists in the tnsnames.ora file.

 

Specify a name for the connection and press Build....

 

Insert a Server Name and a Login Name/Password to connect to the server. The server name is the Net Service Name as defined via Oracle Net Manager.

 

Press Test Connection to test if the the connection to the server is successful.

Next, the tables and feature classes can be added.

 

Choose the connection from the New Data Source Window.

 

The Select Data Windows doesn't list any tables or feature classes, because they fist have to be queried by a Select statement. Therefore, click on Query New.

 

Consider that there exist differences in building up the Select statement between tables and feature classes:

•For tables you can use the Query Builder to create the Select statement. Alternatively, the statement can be created manually.

•For feature classes, the Query Builder doesn't work. The Select statement for feature classes have to be created manually.

Note: For feature classes the select * from xxx is not supported. Select * queries all columns of a table, including BLOB and geometry fields. These GIS data fields are not supported in the ePaper designer. The consequence would be an error message. The select statement has to include the single columns of a feature class.

 

To retrieve the columns of the table, click on Retrieve Columns. If you receive an error message, the syntax of the statement is incorrect or includes unsupported characters.

 

 

Close the window and choose the new table from the Select Data window.

 

Advantages of an Oracle Connection:

Numeric fields of an Oracle database are automatically displayed as Decimal, even though the original data type is a Long Integer. This depends on the provider in the ePaper designer. In many cases it is necessary to relate tables via a key field. If the key field is a numeric field, you will get problems when you establish the relation, because the key fields from both tables have to be from the same data type. If you use a Oracle Connection for the data source you can change the data type:

Click on the column with the decimal data type and choose Edit.

 

Change the data type to, e.g., Int.