Skip to main content

Database Considerations

MySQL, PostgreSQL, and SQLite

To configure a connection to any of these databases, the ODBC driver for the database must be installed on the machine where XLReporter is installed. On 64-bit Windows operating systems, both the 32-bit and 64-bit ODBC drivers must be installed.

image1.png

When configuring the connector, Name contains a list of currently configured Data Source Names (DSNs) built for the selected database. The New button allows you to create a new DSN to the database.

Note that if All Users is selected, you will need administrative privileges to create a new DSN.