Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# SQL/ODBC Details

The SQL/ODBC Details dialog box allows you to configure the ODBC data source that is used to connect to SQL Server through iProcess Engine.

The following table contains detailed information for configuration options available in the SQL/ODBC Details dialog box.

Configuration Options in the SQL/ODBC Dialog Box

Configuration Options | Description | Default Value
Choose An Existing ODBC Data Source | Select this radio button if you want to use an existing ODBC data source, then select the ODBC data source you want to use from the drop-down list. Note: When installing the iProcess Engine on a 64-bit Windows system, only ODBC data sources created for 64-bit applications will appear in the drop-down list. See Creating the ODBC Data Source for detailed information. | Cleared
Enter A New ODBC Data Source | Select this radio button if you want to create a new ODBC data source, and then enter a name in the field for the new ODBC data source. Note: This name must not be the same as any existing ODBC data source name on the computer where you are installing the iProcess Engine. If you intend to use the TIBCO iProcess Connector for ActiveMatrix BusinessWorks with this iProcess Engine, this name must be the same as the name of the database you want to use. If you are installing the iProcess Engine into a Microsoft Windows Cluster, the `mscluster`command automatically creates an ODBC data source with the same name and details on each secondary machine in the cluster. See Configuring the Microsoft Windows Cluster for detailed information. Note: A 32-bit data source is created with <datasourcename>, <datasourcename>_master because the installer is 32-bit and it requires a 32-bit data source to connect to the database. The odbc data source <datasourcename>_master is generated temporarily to connect to the master database. Once the installation is complete, this is removed. | Selected
| SQL Server
Choose The SQL Server To Connect To | Select the name of the SQL Server that you want your new ODBC Data Source to connect to in the drop-down list or enter its name in the field directly. Note: If the SQL Server you want to connect to is not listed in the drop-down list, make sure that the `SQL Server Browser` service is running. This service runs automatically, but if it is not running for any reason, the SQL Server will not be shown in this list. | N/A
Use Integrated Windows Authentication | This setting determines the authentication method that the ODBC data source will use when connecting to the SQL Server. Check this check box if you want the ODBC data source to connect to the SQL Server using Windows authentication. Uncheck this check box if you want the ODBC data source to connect to the SQL Server using SQL Server authentication (SQL Server login ID and password). | Checked
You Have DBA Privileges | Check this check box if you have the name and password of a SQL Administrator login. This SQL Server login must be a member of the `sysadmin` fixed server role. Note: You must check this check box if you want the installer to create the iProcess Engine database and iPE DB Owner and iPE DB User logins for you. For detailed information about iPE DB Owner and iPE DB User, see Database Details. Uncheck this check box if you do not have the name and password of a SQL Administrator login. In this situation, the installer will not be able to create the iProcess Engine database and iPE DB Owner and iPE DB User logins. To continue with the installation, you must have created the iProcess Engine database and iPE DB Owner and iPE DB User logins before running the installer. For detailed information, see Creating the SQL Server Database and Logins. Note: It is mandatory to enter SQL Administrator login and password for Azure SQL. | Checked
| SQL Server Login Name | This field is only available if you check the You Have DBA Privileges check box. Specify the username of the SQL Administrator login that you want the installer to use to connect to this SQL Server. | `sa`
SQL Server Login Password | This field is only available if you check the You have DBA privileges check box. Enter the password for the specified SQL Administrator login. | N/A

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.