Connecting to the H2 Database
At the end of the installation process erwin DT will create, if requested, an internal database for application settings, managed by an H2 Windows service.
H2 DBMS will then host the erwin DT database. The local database can be administrated via a web interface at the URL http://localhost:8082/
The default JDBC URL for the H2 database when installed locally is jdbc:h2:tcp://localhost/C:/ProgramData/erwin/Data Transformation/data/H2/CC
If needed, the erwin DT H2 database can be installed on a different server than the one hosting the erwin DT application. This remote database server must be in a network node, which can be accessed through TCP/Jdbc protocols from the application server. To run DT with an H2 database installed on a separate server, execute the following instructions.
DATABASE SERVER – CREATE AND RUN THE DATABASE AS A SERVICE
1. Identify the database server; it can be the same server erwin CW Exchange is installed on, if existing, or a completely separate one. From now the guide will refer to its network address as:
2. Extract the content of the archive
and copy the folder H2 into a folder with absolute path:
This folder must be accessible by the database Windows Service (which will be created in the following step) and the Local System account, that will execute the service. This is can be ensured maintaining the same path is used for local installation, but it is not mandatory. In that case, <remoteFolderPath> is
and contains the H2 folder.
3. Edit file <remoteFolderPath>/H2/service/H2wrapper.conf to check the parameters:
update this path to an existing JDK 1.8 installation path
the port 9092 can be changed if already in use, and is referred from now on as <TCPport>.
4. Execute batch files, with “Run as Administrator” command:
and check that the Windows Service “erwinDataTransformationH2DB” is created and started.
APPLICATION SERVER – INSTALL AND CONFIGURE DT TO CONNECT TO THE REMOTE DB
1.Install erwin DT, following the instructions described in the previous chapters.
2.Configure erwin DT for the use of the remote database:
Populate Server IP field with the IP of the database server <DBServerIP>
Populate Port field with the <TCPport> which the DB server is published on
Populate Folder Path field with the <remoteFolderPath> hosting the H2 database folder
Appendix B - Installing Utilities for Diagram Migration
erwin Data Transformation can be used to migrate diagrams between CM models.
To enable this feature, the following executables must be located into the erwin EA desktop (former Casewise Corporate Modeler) bin folder, by default.
C:\Program Files (x86)\Casewise\CM10\bin:
If not, contact erwin Servicedesk to request files and copy them to the mentioned folder. Please make sure the read/write/execute permissions are granted to the Windows user running erwin DT services.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center