HomeGuidesRecipesAPI
HomeGuidesAPILog In

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:

  1. Click and drag an action onto the Finish page within your question set and select: Save to Oracle Database from the Select Action dialog.
  2. Click on the newly added action to enable the action's properties tab.
  3. Define your action properties and attributes.