Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Supported Databases

The following database types are supported for TIBCO iProcess Engine on Windows platforms:

| • | Oracle Database

| • | SQL Server Database

## Oracle Database

TIBCO iProcess Engine requires one of the following Oracle database versions:

| • | Oracle 12c R2 (server) with 19c (client)

| • | Oracle 18c (server) with 19c (client)

| • | Oracle 19c (server) with 19c (client)

Note | You must install TIBCO iProcess Engine with 32-bit and 64-bit Oracle 19c client before beginning the iPE installation. Set ORACLE_HOME to 32-bit Oracle installed path in the environment variable.

The exact Oracle version requirements depend on which of the following two types of database connections you intend to use:

| • | a direct connection to the default database hosted on the computer where you will install or upgrade TIBCO iProcess Engine. For detailed information, see Direct Connection Requirements for Oracle.

| • | a Transparent Network Substrate (TNS) connection, connected to one of the following databases:

| — | the default database hosted on the computer where you will install or upgrade TIBCO iProcess Engine, or to

| — | a remote database, meaning a database that is either hosted on a remote computer, or a non-default database on the computer where you will install or upgrade iProcess Engine.

For detailed information, see TNS Connection Requirements for Oracle.

## Direct Connection Requirements for Oracle

Direct Connection illustrates an example of a direct connection from TIBCO iProcess Engine to the default Oracle database:

Figure 81: Direct Connection

Required Database Versions When Using a Direct Connection shows the required Oracle database versions when using a direct connection to the default database.

Required Database Versions When Using a Direct Connection

Database Release | Additional Requirements
18c 19c | Oracle Services for Microsoft Transaction Server (ORAMTS) To see if ORAMTS is installed on your system, run the Oracle Universal Installer and click the Installed Products button. If you need to install this component, perform a Custom installation and select the appropriate product from the list.

## TNS Connection Requirements for Oracle

When using a TNS connection, you must:

| • | ensure that the remote Oracle database uses one of the Oracle Database releases specified in Required Oracle Database and Client Versions.

| • | ensure that the correct Oracle Client release is installed on the computer where you will install or upgrade the iProcess Engine, as described in Required Oracle Database and Client Versions.

TNS Connection illustrates an example of a TNS connection from TIBCO iProcess Engine to the default database:

Figure 82: TNS Connection

| • | have the indicated Oracle Client release (and any specified additional patches or components) installed on:

| — | the computer where you will install or upgrade the iProcess Engine, and

| — | if you are using a Windows cluster, on each machine in the cluster.

Each Oracle Client must be pointing to the same Oracle Database.

| • | use the TNS name to connect the iProcess Engine to the Oracle Database. See Database Details for details.

Required Oracle Database and Client Versions shows the required Oracle database and client versions when you use a TNS connection connecting to the default database or to a remote database.

Required Oracle Database and Client Versions

Certified Database Release | Compatible Database Release | Additional Requirements |  | Client Release | Additional Requirements
18c | 18.1.0 or higher | Oracle Services for Microsoft Transaction Server (ORAMTS) | with | 19c | Oracle Services for Microsoft Transaction Server (ORAMTS)
19c | 19.1.0 or higher | Oracle Services for Microsoft Transaction Server (ORAMTS) | with | 19c | Oracle Services for Microsoft Transaction Server (ORAMTS)

Note | To see if ORAMTS is installed on your system, run the Oracle Universal Installer and select Installed Products. If you need to install this component, perform a Custom installation and select the product from the list.

If you are using an Oracle version (Database or Client) that is:

| • | earlier than the releases explicitly mentioned in the table above, you must upgrade to one of the specified releases.

| • | later than the releases explicitly mentioned in the table above, contact TIBCO Support to confirm whether or not that release is supported by your iProcess Engine version.

Note | You will need access to an Oracle Metalink account to be able to access the required patches and patch sets. TIBCO iProcess Engine uses Oracle Call Interface (OCI) to access data in the Oracle database. For stability purposes only, TIBCO iProcess Engine is statically linked with the Oracle client libraries that provide the required OCI routines. Oracle only supports products that run against the same set of libraries that they were built with. This means you must use particular Oracle Client versions, depending on the method you use to connect to the database. If you are using Oracle Real Application Clusters (RAC), TIBCO recommends that you install the iProcess Engine on a machine that is not part of the RAC, and use a TNS connection to connect to the remote database.

## SQL Server Database

TIBCO iProcess Engine requires one of the following SQL Server database versions:

| — | SQL Server 2016

| — | SQL Server 2017

| — | SQL Server 2019

If you are using a SQL Server version that is:

| • | earlier than the releases explicitly mentioned above, you must upgrade to one of the specified releases.

| • | later than the releases explicitly mentioned above, contact TIBCO Support to confirm whether or not that release is supported by your iProcess Engine version.

The SQL Server must be installed either:

| • | on the computer where you intend to install the iProcess Engine, or

| • | on a computer which is in the same domain or workgroup as the computer where you intend to install the iProcess Engine.

Note | When you install iProcess Engine with SQL Server, but without the DBA role, the following error message appears: `The User does not have permissions to add the linked server`. You can ignore this message and continue to install iProcess Engine. To make sure that SSOLITE works correctly, you need to use the DBA role to run the following script after the installation: `$SWDIR``/util/sql_check_linkedserver.sql`

## Authentication Requirements

Note | TIBCO strongly recommends that you install iProcess Engine against a SQL Server instance that uses `Mixed Mode` authentication (where database connections can be authenticated using either SQL Server login IDs or passwords, or Windows accounts). The installer normally creates or uses SQL Server logins to enable the iProcess Engine to connect to the SQL Server instance. Although iProcess Engine can use Windows-authenticated accounts to access the SQL Server database, there are currently some restrictions associated with this mode of operation that require changes to the installation procedures described in this documentation. If you want to install the iProcess Engine against a SQL Server instance that uses `Windows Only` authentication, see `“`Installing iProcess Engine Against a SQL Server Instance That Uses Windows Only Authentication” in TIBCO iProcess Engine (SQL Server) Release Notes for more information before proceeding further.

## ODBC Driver Requirements

This version of iProcess Engine requires an ODBC driver to allow iProcess Engine to connect to the SQL Server database. The driver required depends on the type of database you are using, as shown in ODBC Driver Requirements.

ODBC Driver Requirements

Database | Required ODBC Driver
SQL Server 2016 | SQL Native Client
SQL Server 2017 | SQL Native Client
SQL Server 2019 | SQL Native Client

Note | The SQL Native Client driver is not automatically provided on the Windows operating systems supported by this version of the iProcess Engine. It is installed as part of SQL Server. If you do not have SQL Server installed on the computer where you intend to install iProcess Engine, and you intend to use a SQL Server that is installed on a remote computer, you have to download the SQL Native Client version 11 or above from the Microsoft Download Center. For example, you can download the SQL Native Client driver for SQL Server from https://www.microsoft.com/en-us/download/details.aspx?id=50402.

## Additional Requirements

To enable the TIBCO iProcess COM Server Plug-in, you must enable `network DTC access`. If it is not enabled, database transactions are limited to the local server.

For more information about how to enable `network DTC access`, see article “Enable Network DTC Access” on the Microsoft website.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.