1. General

1.0. Only partial support

1.0.1. RK7 does not fully support any DBMS besides MSSQLS since 7.4.21.1.

1.1. Versions

Tested with 
                       Oracle 11g
                       R-Keeper – 7.3.7.0 and higher

1.2. Common

1.Install Oracle (no special settings required)
2.Create database inside, e.g. KEEPER (use Database Configuration Assistant application)
3.Create user in this database, e.g. user1, and give him all privileges (use Toad For Oracle application (Database -> Create -> User))
4.There is no need to edit any хххх.ora files
5.Make sure that TNSListener is started, if not – start it in Services (its default name is - OracleOraDb11g_home1TNSListener)

2. Manager station settings

2.1.Make sure, that Report server is running, i.e. license is ok
2.2.In Service -> Data Export -> External Database Configuration, copy Oracle configuration and in
   2.2.1.SqlTimeConversion insert:  to_char(%s, 'HH24:MI:SS')
   2.2.2.BaseParams insert:


Provider=OraOLEDB.Oracle.1;Persist Security Info=True;Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = ххх.ххх.ххх.ххх)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = KEEPER)))


ххх.ххх.ххх.ххх – IP address where Oracle is installed
1521 – port (you may leave it by default)
KEEPER – database name defined on creation. Usually, SID is the same.

3. Export

Perform export: 
В Service -> Data Export -> Export To Other DB
   3.1. In Connection Parameters select copy of Oracle configuration, which was created in p. 2
   3.2. In User name insert user name which was created in p. 3 COMMON
   3.3. In Password insert password of this user
   3.4. In Export Parameters select desired tics except Structure only. (You can use Structure only if you need only base structure in Oracle)
   3.5. Press Test. If connection established properly – OK button will become active and export will become possible
 

4. Report server settings

Specify:
   4.1. Database, user which was created in p. 3 COMMON and his password
   4.2. Cash servers, set tics on Build Cubes and Gather Data
   4.3. Queries Logging Type set as Erroneous
   (Make sure that SQLQueryDebugLevel parameter set as Erroneous Queries)
 



5.Recalculate all cubes