Difference between revisions of "HowTo:Connect To Oracle With A Workflow"
| Line 21: | Line 21: | ||
You have to configure the connection to the Oracle database DataSource, the InitialCatalog and you need to fill out UserName and Password. | You have to configure the connection to the Oracle database DataSource, the InitialCatalog and you need to fill out UserName and Password. | ||
<br/><br/> | <br/><br/> | ||
| − | 3. Use a "CreateOLETableScope" to define the table you want to fetch data from. | + | 3. Use a "CreateOLETableScope" or a "CreateOLEQueryScope" to define the table you want to fetch data from. |
Configure the tablename in DisplayName. | Configure the tablename in DisplayName. | ||
<br/><br/> | <br/><br/> | ||
| Line 30: | Line 30: | ||
| + | Example Workflows: | ||
| + | |||
| + | Connecting to oracle DB and reading data with a CreateOLETableScope | ||
| + | [[File:oratest.uwf|220px|border|alt=Example Workflow|Example Workflow]] | ||
[[File:ora_example_worfklow.JPG|440px|border|alt=Example Workflow|Example Workflow]] | [[File:ora_example_worfklow.JPG|440px|border|alt=Example Workflow|Example Workflow]] | ||
<br/><br/> | <br/><br/> | ||
| − | [[File: | + | |
| + | Connecting to oracle DB and reading data with a CreateOLEQueryScope | ||
| + | [[File:example_workflow_sql_statement.uwf|220px|border|alt=Example SQL Statement Workflow|Example SQL Statement Workflow]] | ||
| + | |||
Revision as of 14:38, 23 January 2015
Before being able to connect to an 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):
TESTDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host =AUGTESTORACLE.cloudapp.net)(Port = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = UBIKTEST)
)
)
2. Use a "CreateOLEOracleScope" Activity to configure the connection.
You have to configure the connection to the Oracle database DataSource, the InitialCatalog and you need to fill out UserName and Password.
3. Use a "CreateOLETableScope" or a "CreateOLEQueryScope" to define the table you want to fetch data from.
Configure the tablename in DisplayName.
4. Use a ForEach<DataRow> Activity to iterate over the records in the table.
5. Access the columns of the record by using the index of the column.
Example Workflows:
Connecting to oracle DB and reading data with a CreateOLETableScope
Oratest.uwf
Connecting to oracle DB and reading data with a CreateOLEQueryScope Example workflow sql statement.uwf
