Versions Compared

Old Version 1

changes.mady.by.user Iouri_Jaryi

Saved on

compared with

New Version Current

changes.mady.by.user AntonA

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

How to configure FIXEdge to work with Oracle database

Prerequisites:

  1. Make sure that Oracle driver is installed on the machine, which you are going to connect to Oracle database from One can  install necessary driver by downloading it here: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
  2. In case if Oracle database resides on remote server, make sure that you can access server with the database
  3. Make sure that you have your database connection parameters (Host, port (if different from default), Server name, Username, Password) handy 

...

  1. Check if you can access database server. Run 'cmd.exe' and execute the following command 'tnsping host:port'  Example: tnsping evuakyisd0084.kyiv.epam.com:1521 If command output is 'OK' (see example below), continue from step 3. Otherwise, move to step 2. Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.17.9.56)(PORT=1521))) OK (360 msec)
  2. Add definition of remote database TNS name on your machine. Open 'tnsnames.ora' and specify new TNS name (see example below). Save the file. TNS file location should be similar to: ..\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN (depending on installed Oracle version) Example: EPMBFIX = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = EVUAKYISD0084.kyiv.epam.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = EPMBFIX) )) 
  3. Create System DSN: Open ODBC Data Sources Administrator (Start > Administrative Tools > Data Source (ODBC)) and create new DSN. 3.1 Choose System DSN and click 'Add' 3.2 In 'Create New Data Source' wizard select Oracle ODBC driver and click 'Finish' 3.3 Specify Oracle ODBC Driver configuration parameters and click 'OK':
    • Data Source Name = any value (this parameter will be used in BL_Config.xml)
    • Description = optional and can be omited
    • TNS Service Name = specify name of service name of database you are going to connect to Note, if new TNS was created in tnsnames.ora, its name should be used here (for our example it should be EPMBIX).  If database and FIX Edge are on different servers and step 2 was skipped, specify service name so: @//Database_Host:Database_port/Database_Service_Name  If database and FIX Edge are on the same server, specify database service name
    • Username = database username

...