CONNX Data Integration Suite 14.8.0 | Operations Guide | Working with the Online CONNX Suite | Managing CDDs with the Online CONNX Data Dictionary Manager | Working with Databases in a CDD | Importing from a PostgreSQL Database
 
Importing from a PostgreSQL Database
*To import PostgreSQL:
1. Go to the main online CONNX Data Dictionary Manager page.
You can select CONNX Data Dictionary from the home page or the tile menu on the top right.
2. Browse to the CDD you want to import in and open it.
3. Click the Import button.
4. In the Import Type window, select CONNXStore from the dropdown menu and click OK.
5. In the Connection Information step, fill in the connection information in the respective fields and click Next:
a. The server address in the Server field.
b. The database name in the Database Name field.
c. The username for the server in the Username field.
d. The password for the server in the Password field.
e. The TCP/IP port in the TCP/IP Port field.
f. Choose an authentication mode from the dropdown menu. The available authentication methods are:
disable
SSL is disabled and the connection is not encrypted.
allow
SSL is used if the server requires it.
prefer
SSL is used if the server supports it.
require
SSL is required.
verify-ca
SSL must be used and the server certificate must be verified.
verify-full
SSL must be used. The server certificate must be verified and the server hostname must match the hostname attribute on the certificate.
g. If you are using a custom certificate, turn the option on and enter it in the new field. The certificate must be in the root of the CONNX installation directory or the directory set by the CERTPATH configuration setting in the CONNX key.
6. In the Import Properties step, choose whether to include system tables and get statistics.
Turn the Include System Tables option on if you want to import table definitions into the CDD.
Turn the Get Statistics option on if you want to identify the size of the tables. Click Next when you are done.
7. In the Table Selection step, mark the tables you want to import in the Available Table(s) pane and press the arrow pointing to the right to move them to the Selected Table(s) pane.
You can use the search field in the Available Table(s) pane to filter the list of tables.
You can mark all tables in a pane by clicking the checkmark next to the Available Table(s) or Selected Table(s) entry.
You can move tables back from the Selected Table(s) pane by marking the tables and clicking the arrow pointing to the left.
8. Click Done to finish the import procedure.