Difference: APPX500ToOracleOnWindows (27 vs. 28)

Revision 282010-07-08 - JoeOrtagus

Line: 1 to 1
 

APPX 5 connectivity to Oracle on Linux

How to configure APPX 5 to store data inside Oracle on Linux.

Line: 109 to 109
 The two environment varialbes needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.

FMS settings

Added:
>
>		We need to create an FMS group of type 5 (Oracle) that will point to the Oracle server. To do this we will need the same five pieces of Oracle configuration data that we used when we performed a test connection to Oracle using the Instant Client version of SQL*Plus. The values that I'm using in this example are listed below in parenthesis.

  • Oracle SID (customer)
  • TCP port number that Oracle is configured to listen (TCP 1521)
  • Resolvable DNS name or IP address of the Oracle server (10.50.0.6)
  • Oracle user ID (larry)
  • Oracle password (yacht)

After creating the FMS group, we will define an APPX DMO PROSPECT to make use of this FMS group, finally performing a CREATE FILE from within APPX to create the file in Oracle. These steps are documented in screen shots below.

 001.png

Fig. 1

Added:
>
>		First we need to go to our FMS seetings inside APPX.

 002.png

Fig. 2

Added:
>
>
Go into APPX ADD mode and create an FMS group with a meaningful name of a type 5 for your Oracle data.
 003.png

Fig. 3

Added:
>
>
Now you need to fill out at least Server Name and Table Naming Scheme. You can select the HINTS button to see other suggested formats for the Table Naming Scheme if you wish.
 004.png

Fig. 4

View topic | History: r43 < r42 < r41 < r40 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback