You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
Turn on Animations
SharePoint
Sign In
Use SHIFT+ENTER to open the menu (new window).
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Browse
Tab 1 of 2.
Page
Tab 2 of 2.
Follow
Bluespring Online
Bluespring ProcessView
Bluespring LeanView
BPM5 Documentation
Currently selected
Creating a Connection to an Oracle Database
It looks like your browser does not have JavaScript enabled. Please turn on JavaScript and try again.
Updated Pages
Update Specific Group LDAP Entries
Home
Write Values to a Password-protected Workbook and Worksheet
Write Data Item Values to a Delimited Text File
Update Specific User LDAP Entries
Documents
Welcome & Introduction
Guides
Hardware & Software Requirements (PDF)
Install Guide (PDF)
Activity Reference Guide (PDF)
BPM Designer Topics
Workspace and Solution Topics
Solution Item Topics
Activity Topics
Common Expression Functions
BPM Admin Topics
Process and Activity Monitoring (with Filters)
Service Monitoring
View All Site Content
Recent
Images
Business View Topics
Feedback
Solution Items and Activities
Guides
Home
About
To create a connection to an Oracle database that can be used by the
Database Activities
you need to create an ODBC System Resource.
The system resource supportcs ODBC-compliant databases. An ODBC system allows you to access data, regardless of the database management system, as long as the system supports ODBC.
To create a connection to an Oracle database, complete the following steps:
Check out the solution.
Click the
Create
tab. The
Solution Items
ribbon menu is displayed.
Click
New Resource
. A drop-down list is displayed.
Select
ODBC System Resource.
The
ODBC System Resource
window is displayed.
In the
ODBC System Resoure name
field, type a name for the new ODBC resource.
In the
Connection string
field, click
Edit.
The
Data Link Properties
window is displayed.
Note:
If you already know the connection string, type the string into the field and proceed to step 12.
Select
Microsoft OLE DB Provider for Oracle
from the
Provider tab
.
Click
Next
. The
Connection
tab and the corresponding screen are displayed.
Type the server name in the
Enter a server
name field.
In the
Enter information to log on to the database
field, type the username and password in the corresponding fields.
Note:
If you want to save your credentials, select the
Allow saving password
check box.
If you want to save your credentials, select the
Blank password
check box.
Note:
Click
Test Connection
, if you want to ensure that BPM can access the selected database.
Click
OK
. The connection string is displayed.
From the
SQL Syntax
drop-down list, select the syntax appropriate for your database management system.
Click the save button. You created a connection to an Oracle database.
Related Topics
Database Activities
Creating a Connection to a SQL Server Database
Deleting a System Resource
Source
BPM Designer Topics
>
Overview of Solution Items and Solution Item Topics
>
System Resources
Last modified at 7/31/2020 11:21 AM
