- Open PowerDesigner and go to menu Repository > Repository Definitions…
- Add a new repository definition
- Click apply and then click on 'Properties'
- It will open a windows with this new definition, and to create a JDBC connection you need to click on 'Select a Data source' icon:
- In this new window choose the option "Connection profile":
- Click on 'Configure'
- Then click on icon 'Add Data Source'
- Add a connection profile name
- Connection tye: JDBC
- Change the DBMS type: to the one that you will use (in this example db2)
- Add a username (the one that you use to connect to DB2 instance)
- Choose the JDBC class and JDBC connection URL. It should look something like this:
- On the JDBC connection URL you need to add the host and the database name: jdbc:db2://<servername>:50000/<dbname>
- Click on test connection.
Additional things to check:
- You need to download the JDBC driver for the database that you will be using.
- Configure the JAVA_HOME environment variable pointing to your java path
- Add to your CLASSPATH environment variable the directory pointing to your .jar file