Versions Compared

Old Version 1

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

compared with

New Version 2

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space WINSTALLATION and version 1.0.1

...

  • Installing SQL client tools
  • Defining the SQL adapter preferences
  • Defining database parameters

When installing the E2E BridgeBRIDGE, all additional libraries (E2E SQL Libraries, E2E SAP Libraries, and E2E Java Libraries) are being installed as well.
After a successful installation, the Bridge 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 BRIDGE opens a connection to the database server via the database client tools or ODBC.

Preconditions

The E2E Bridge BRIDGE has been successfully installed. When running the Bridge BRIDGE in server mode (as opposed to workstation mode), the E2E Bridge BRIDGE node instance has to be a member of an E2E Bridge a BRIDGE domain. For more information on installation modes and E2E Bridge and BRIDGE domains, refer to Installation Modes and Bridge Domain.

...

The database client library must have the same number of bits as the E2E xUML Runtime.

E2E xUML RuntimeDatabase Client Library
Windows 32-bit32-bit
Linux 32-bit32-bit
Windows 64-bit64-bit
Linux 64-bit64-bit

For ODBC configuration, you have to consider the following, if using a Windows 64-bit system:

E2E xUML RuntimeODBC Configuration
Windows 32-bit%systemdrive%\Windows\SysWoW64\Odbcad32.exe
Windows 64-bitControl Panel > Administrative Tools > Set up data sources (ODBC)

...

If you want to access the installed database via the xUML Runtime that is embedded in E2E Builder Scheer PAS BUILDER, please note that you have to make the database client available to the BuilderBUILDER:

  • Install a database client to the system you are running the Builder BUILDER on.
  • Make sure that the database client location makes part of the PATH variable.
    After having changed PATH, you need to restart MagicDraw to make it read the new content of PATH.

...

Before starting a deployed xUML service that connects to a database backend, you may want to redefine required database parameters in the BridgeBRIDGE.
You find more information about database-specific information (database names and mappings) in section Database-Specific Mappings.

...

KeyValue
customers: DBTypeName of the SQL Service component e.g. ODBC
customers: DBNameName of the database, e.g. NorthwindCustomers
customers:Connection Pooling
Multiexcerpt include
MultiExcerptNameconnectionPooling
nopaneltrue
PageWithExcerptBRIDGE:SQL
customers:Max Connection Reuse

Multiexcerpt include
MultiExcerptNamemaxConnectionReuse
nopaneltrue
PageWithExcerptBRIDGE:SQL

Multiexcerpt include
MultiExcerptNamemaxConnectionReuse_2
nopaneltrue
PageWithExcerptBRIDGE:SQL
customers: Max Connection Age
 
Multiexcerpt include
MultiExcerptNamemaxConnectionAge
nopaneltrue
PageWithExcerptBRIDGE:SQL
customers: Max Connection Idle Time
 
Multiexcerpt include
MultiExcerptNamemaxConnectionIdleTime
nopaneltrue
PageWithExcerptBRIDGE:SQL
Noteinfo
iconfalse

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.

...

KeyValue
customers: DBUserDatabase user
customers: DBPasswordDatabase password
Noteinfo
iconfalse

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. 

...