Data Sources

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  SPS File and Databases > Query Database >

Data Sources

In order to query a database, you have to first connect to the required database This section describes how to:

 

Connect to a database, and
Select the required data source and root object from among multiple existing connections.

 

Connecting to a database

When you click the Query Database command in the Database menu for the first time in a session (and when no database connection exists), the Connect to a Data Source dialog (screenshot below) pops up to enable you to connect to a database. To make connections subsequently, click the Quick Connect icon ic_quickconnect in the Database Query window. If connections already exist, you can select the required connection from among these.

 

DBQuery_QuickConnectDlg1

 

How to connect to a database via the Connect to a Data Source dialog is described in the section Connecting to a Data Source.

 

Supported databases

The following databases are supported. While Altova endeavors to support other databases, successful connection and data processing have only been tested with the databases listed below. If your Altova application is a 64-bit version, ensure that you have access to the 64-bit database drivers needed for the specific database you are connecting to.

 

Database

Notes

Firebird 2.5.4, 3.0


IBM DB2 8.x, 9.1, 9.5, 9.7, 10.1, 10.5


IBM Db2 for i 6.1, 7.1, 7.2, 7.3

Logical files are supported and shown as views.

IBM Informix 11.70, 12.10

 

MariaDB 10.2, 10.3


Microsoft Access 2003, 2007, 2010, 2013


Microsoft Azure SQL Database

SQL Server 2016 codebase

Microsoft SQL Server 2005, 2008, 2012, 2014, 2016, 2017,

Microsoft SQL Server on Linux


MySQL 5.0, 5.1, 5.5, 5.6, 5.7, 8.0


Oracle 9i, 10g, 11g, 12c


PostgreSQL 8.0, 8.1, 8.2, 8.3, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.5, 9.6, 10, 11

PostgreSQL connections are supported both as native connections and driver-based connections through interfaces (drivers) such as ODBC or JDBC. Native connections do not require any drivers.

Progress OpenEdge 11.6

 

SQLite 3.x

SQLite connections are supported as native, direct connections to the SQLite database file. No separate drivers are required.

 

In Authentic view, data coming from a SQLite database is not editable. When you attempt to save SQLite data from the Authentic view, a message box will inform you of this known limitation.

Sybase ASE 15, 16


Teradata 16

 


 

Selecting the required data source

All the existing connections and the root objects of each are listed, respectively, in two combo boxes in the toolbar of the Database Query window (screenshot below). After selecting the required data source in the left-hand combo box, you can select the required root object from the right-hand combo box.

 

DBQuerySelectDataSource

 

In the screenshot above, the database with the name StyleVision DB has been selected. Of the available root objects for this database, the root object ALTOVA_USER has been selected. The database and the root object are then displayed in the Browser pane.

 


© 2019 Altova GmbH