Altova StyleVision 2024 Professional Edition

Native connections are direct connections to the DB that do not need drivers to be installed. Also, if you intend to deploy files for execution on a Linux or macOS server, you do not need to instally drivers on the target server either.

 

You can set up native connections for the following DBs:

 

MariaDB

MySQL

SQLite

PostgrreSQL

 

If you prefer to establish a connection by means of a driver, see the following topics:

 

Setting up a JDBC Connection

SQLite Connection

Connecting to PostgreSQL (ODBC)

 

Connection setup

To set up a native connection, follow the steps below. You will need the following information: host name, port, database name, username, and password.

 

1.Start the database connection wizard.

2.Select the DB you want to connect to (MariaDB, MySQL, PostgreSQL, or SQLite).

3.In the dialog that appears, enter the host ( for example, localhost), optionally the port (typically 5432), SSL Mode in the case of MySQL, the database name, username, and password in the corresponding boxes.

4.Click Connect.

 

SQLite conections

For detailed information about SQLite connections, see the topic SQLite Connection.

 

Notes for PostrgreSQL

If the PostgreSQL database server is on a different machine, note the following:

 

The PostgreSQL database server must be configured to accept connections from clients. Specifically, the pg_hba.conf file must be configured to allow non-local connections. Secondly, the postgresql.conf file must be configured to listen on specified IP address(es) and port. For more information, check the PostgreSQL documentation (https://www.postgresql.org/docs/9.5/static/client-authentication-problems.html).

The server machine must be configured to accept connections on the designated port (typically, 5432) through the firewall. For example, on a database server running on Windows, a rule may need to be created to allow connections on port 5432 through the firewall, from Control Panel > Windows Firewall > Advanced Settings > Inbound Rules.

 

© 2017-2023 Altova GmbH