Oracle Connection
The Oracle Connection is used to query data from an Oracle database. This also applies to SDE data in 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.
Define the name of the connection and press Build ...
New Oracle Connection
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.
Connection Properties
Via Test Connection the connection can be tested. If the connection could be established successfully, the new Oracle connection is created. Next, the tables and feature classes can be included.
Choose the connection from the New Data Source window.
Create new data source
Select the Oracle connection.
Tables and feature classes are not displayed in the data selection dialog. These must first be selected via a Select statements must be queried. Therefore, click on Query New.
New query
|
IMPORTANT! 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. •The Select statement for feature classes have to be created manually. For feature classes, the Query Builder doesn't work. |
|
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.
"Select statement" for tables
"Select statement" for feature classes
Close the window and choose the new table from the Select Data window.
Choose table
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. Since in many cases it is necessary to link the data with other tables, this can cause problems when establishing the connection. 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.
Click on the column with the decimal data type and choose Edit.
Edit field
Edit column
Change the data type