Before being able Prior to connect connecting to an oracle Oracle database it is necessary to configure the connection to the server on your local environment. {{UBIK }} uses OLEDB to connecti to Oracle via TNS (Transparent Network Substrate).1. After installing the oracle client you have to configure the oracle server in the TNS Names: In [ORACLESOFTWARE]\network\admin\ you can find "tnsnames.ora".Configure the connection and call it (like in this example TESTDB):
= Instructions =
# After the installation of the Oracle client you have to configure the Oracle server in the TNS Names:
## Locate the file ''tnsnames.ora'' in the directory '''[ORACLESOFTWARE]\network\admin\'''
## Configure the connection and call it (like in this example TESTDB):
<code>
TESTDB=
)
</code>
# Use the [[CreateOLEOracleScope (Activity)}} activity to configure the connection via the arguments:
#* the Oracle database '''DataSource'''
#* the '''InitialCatalog'''
#* '''UserName''' and '''Password'''
# Use the [[CreateOLETableScope (Activity)]] activity or a [[CreateOLEQueryScope (Activity)]] to define the table you want to fetch data from. Set the tablename in the '''DisplayName''' argument.
# Use a '''ForEach<DataRow>''' activity to iterate over the records fetched from the table.
# A column of the recordset (table) can be accessed by its index.
=Example Workflows=2. Use a "CreateOLEOracleScope" Activity Connecting to configure the connection.You have to configure the connection to the an Oracle database DataSource, the InitialCatalog and you need to fill out UserName and Password.<br/><br/>3. Use a "CreateOLETableScope" or a "CreateOLEQueryScope" to define the table you want to fetch fetching data from.Configure with the tablename in DisplayName.<br/>CreateOLETableScope activity<br/>4. Use a ForEach<DataRow> Activity to iterate over the records in the table.<br/><br/>5. Access the columns of the record by using the index of the column.<br/><br/> '''Example Workflows:'''<br/><br/>Connecting to oracle DB and fetch data with a CreateOLETableScope: [[File:oratestora_example_worfklow.uwfJPG|220px440px|border|alt=Example Workflow|Example Workflow]]<br/><br/>[[File:ora_example_worfkloworatest.JPGuwf|440px220px|border|alt=Example Workflow|Example Workflow]]
<br/><br/><br/>