Altova XMLSpy 2025 Enterprise Edition

Native connections are direct connections to a database's own network protocols and drivers. Therefore, no additional drivers need to be installed. Native connections provide the most efficient method of interacting with the database and full feature support.

 

You can set up native connections to the following DBs:

 

MariaDB

MySQL

SQLite

PostgreSQL

 

Connection setup

To set up a native connection, follow the steps below:

 

1.Start the database connection wizard.

2.Select the DB you want to connect to.

3.In the dialog that appears, enter the relevant connection details, for example, the host (e.g., 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.

 

© 2018-2024 Altova GmbH