Page History
Div | |||||||||
---|---|---|---|---|---|---|---|---|---|
| |||||||||
|
...
When installing the BRIDGE, all additional libraries (E2E SQL Libraries, E2E SAP Libraries, and E2E Java Libraries) are being installed as well.
After a successful installation, the BRIDGE is capable to connect to database backends.
First, you need to install the client tools or the ODBC drivers and configure each database access if needed.
Databases like DB2 or Oracle are usually running on a dedicated database server. The BRIDGE opens a connection to the database server via the database client tools or ODBC.
...
Prerequisites
The BRIDGE has been successfully installed. When running the BRIDGE in server mode (as opposed to workstation mode), the BRIDGE node instance has to be a member of a BRIDGE domain. For more information on installation modes and BRIDGE domains, refer to Installation Modes and Bridge Domain.
Database Client Library Versions (32 or 64 bit)
The database client library must have the same number of bits as the xUML Runtime.
...
For ODBC configuration, you have to consider the following, if using a Windows 64-bit system:
...
.
...
...
For Windows 32-bit, always use Control Panel > Administrative Tools > Set up data sources (ODBC).
Installing Database Access
...
If you want to access the installed database via the xUML Runtime RUNTIME that is embedded in Scheer PAS BUILDER, please note that you have to make the database client available to the BUILDER:
...
Select the xUML service in the navigation (in this example CustomerQuery and stop the service.
Switch to tab Settings. From the dropdown list, select the option SQL Adapter Connection in the Add-ons category.
The default parameters are defined in the component diagram of the xUML service (see CustomerQuery example below). The connection is defined by a dependency between the composite named CustomerQuery and the SQL alias customers. The database user and password are defined in the tagged value user on the SQL alias.
Enter the following database parameters and click Apply:
Key | Value | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
customers: DBType | Name of the SQL Service component e.g. ODBC | ||||||||||||||||
customers: DBName | Name of the database, e.g. NorthwindCustomers | ||||||||||||||||
customers:Connection Pooling |
| ||||||||||||||||
customers:Max Connection Reuse |
| ||||||||||||||||
customers: Max Connection Age |
| ||||||||||||||||
customers: Max Connection Idle Time |
|
Info | |
---|---|
false | For each SQL adapter alias found in the activity diagrams of a UML model, you will find a pair of the two parameters DBType and DBName on the SQL adapter connection settings. According to the example with the both parameters in the table above, you would find an alias called customers in the UML model of the deployed xUML service CustomerQuery. |
Now, select SQL Adapter Authorization from the list.
Enter the following database parameters and click Apply:
Key | Value |
---|---|
customers: DBUser | Database user |
customers: DBPassword | Database password |
Info | icon | false
---|
Users who do not have the permission to view the settings cannot see the Settings tab at all. This prevents that unauthorized users access sensitive information like passwords, etc. |
...