Oracle
The following versions of Oracle are supported
- Oracle 11g database
- Oracle 10g database
- Oracle 9i database
- Oracle 8.0.5 - 8.1.7 databases
- Oracle 7.3 database
Oracle supported Data Types
Additional installation
Installing the RapidiConnector
If you want to transfer data to/from Oracle Data Sources, you have to do the following:
- Install "Oracle Call Interface" on the computer (is part of the Oracle Client).
- In the Oracle System environment you have to create a connection in the usual way for each database you want to transfer data to/from. In other words, you have to "open" a passage so that your program will be able to locate the Oracle database.
Configuration
The fields of the Oracle Data Source Card are described as follows:
- Description: Fill in a descriptive text.
- Server Connect: Here you specify the name of the connection you created during the additional installation. If the Oracle database is a local database you leave this field blank; but you have to specify a UserID and a Password.
- UserID: If the database needs a UserID, you specify it here.
- Password: If the database needs a Password, you specify it here.
- Schema: If you want to use a certain schema you can specify which one here.
- Installation Path: Specify the name of the directory Oracle is placed in (where the OCIW32.DLL file is). If left blank, it tries to use the PATH from the environment.
Copy, Test, Activate Changes, and Read Design
Copy Connection
Connection Test
Activate Changes
Read Design