Save to Oracle Database - Action
Deployment Feature Availability
Available in on-premise deployments only.
Overview
SmartIQ can connect to ORACLE via OLEDB and ODBC providers. In all scenarios an ORACLE client needs to be installed and configured on the web server.
It is good practice to ensure a connection between the SmartIQ Web Server and the ORACLE database is achievable before testing in SmartIQ A good test is to use a UDL file from the web server.
Once a connection is possible a Data Source can be added in SmartIQ, depending on the drivers you have installed on the web server the following are good connection string examples.
Attributes
| Attribute | Description |
|---|---|
| Oracle Connection String | Enter the Oracle Server connection string if you wish to override the Default Connection String that is stored within Manage > Settings > Connector Settings. |
| Stored Procedure Name | The name of the stored procedure. |
| Stored Procedure Parameters | Add your stored procedure parameters here. One per line. |
Connection Strings
Provider=OraOLEDB.Oracle.1;Password=infiniti;Persist Security Info=True;User ID=infiniti;Data Source=TESTORACLE
Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myUsername;Pwd=myPassword;
Driver={Oracle in OraDb11g_home1};Dbq=TESTORACLE;Uid=infiniti;Pwd=infiniti;
Description
The below steps define how to add an Save to Oracle Database action:
- Click and drag an action onto the Finish page within your question set and select: Save to Oracle Database from the Select Action dialog.
- Click on the newly added action to enable the action's properties tab.
- Define your action properties and attributes.
Updated almost 3 years ago