Home Recent Sign up Sign in

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

The following data-types are supported:   CHAR: Yes    VARCHAR2: Yes    NCHAR: Yes    NVARCHAR2: Yes    NUMBER: Yes    DATE: Yes    LONG: Yes    RAW: No    LONG RAW: ...

 

Additional installation

In order for RapidiOnline to connect to your local database server, you need to download and install a small service, that we call 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.

 

Test and Read Design

 

You can Test that the access to a DataSource works using the Test button on the DataSource. Select the Configure Tab and then go to ...

 

Read Design is the way to read the layout - the information about tables and fields - from a DataSource. Reading the design is necessary ...