Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# SQL Server

If you are using a SQL Server database, the following table contains detailed information for configuration options available in the Database Details dialog box.

Configuration Options in the Database Details Dialog Box- SQL Server

Configuration Option | Description | Default Value
ODBC Source | The ODBC Data Source being used appears in this field. You cannot change this value. If it is not the ODBC Data Source you want to use, click the Back button to return to the SQL/ODBC Details and select a different ODBC Data Source. | The ODBC Source that is defined in SQL/ODBC Details
Database Details |  |
Database Name | Specify the name of the database that you want to create. Note: If you chose to use an existing ODBC Data Source, you cannot change the value shown, which is the name of the database associated with that ODBC data source. If this is not the database you want to use, click the Back button to return to the SQL/ODBC Details and choose a different ODBC Data Source. In the SQL/ODBC Details, if you do not check the You Have DBA Privileges check box, you must specify the name of an existing database here. 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 ODBC Source. See Microsoft SQL Server documentation for information regarding applicable naming conventions. 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. These 32-bit data sources are temporary to connect to database during installation and will be removed once the installation is complete. A 64-bit is created to use during run-time. | The name of the database associated with the selected ODBC data source
iPE DB Owner Login | Specify the name of the SQL Server login that owns the iProcess Engine database. Note: In the SQL/ODBC Details, if you do not check the You Have DBA Privileges check box, you must specify the name of an existing SQL Server login here. If you are using Windows-authenticated accounts, you must enter the simple username not the fully qualified name, for example, `swpro` rather than `EMEA\swpro`. For more information, see Authentication Requirements. See Microsoft SQL Server documentation for information regarding applicable Naming Conventions. | N/A
iPE DB Owner Password | Specify the password for the iPE DB owner. Note: When entering a password, you must ensure that the password conform to the password complexity requirements of your site. If you are unsure of the password complexity requirements, contact your system administrator. | N/A
iPE DB User Login | Specify the name of the SQL Server login that the iProcess Engine will use for read access to the iProcess Engine database. Note: See Microsoft SQL Server documentation for information regarding applicable Naming Conventions. In the SQL/ODBC Details, if you do not check the You Have DBA Privileges check box, you must specify the name of an existing SQL Server login here. | N/A
iPE DB User Password | Enter the password for the specified iPE DB User Login. Note: When entering a password, you must ensure that the password conforms to the password complexity requirements of your site. If you are unsure of the password complexity requirements, contact your system administrator. | N/A
Support Unicode Encoding | Check this check box if you want the iProcess database to support unicode (UTF-8) encoding. For more information, see Does the iProcess Engine Database Support UTF-8 Uncheck it to disable this function. | Unchecked

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.