Please enable JavaScript to view this site.

Altova MobileTogether Designer

The DB Query View (screenshot below) enables you to directly query any major database from within the MobileTogether Designer GUI. The database could be a data source referenced in the active document or an external database. Note that each DB Query pane is associated with the currently active design. The DB Query pane of a design can have connections to multiple databases open at a time. There can also be multiple designs open at a time in MobileTogether Designer. Queries and actions defined in the DB Query View are independent of other MobileTogether Designer tabs, and are not saved as part of the design file.

 

Click to expand/collapse

 

 


 

 

The Database Query mechanism

The Database Query mechanism is as follows. (It is described in detail in the sub-sections of this section.)

 

1.A connection to the database is established via the Database Query | Connect to a Data Source window.

2.The connected database or parts of it are displayed in the Browser pane, which can be configured to suit viewing requirements.

3.A query written in a syntax appropriate to the database to be queried is entered in the Query pane, and the query is executed.

4.The results of the query can be viewed through various filters.

 

 


 

 

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, 2016, 2019

At the time of writing (early September 2019), there is no Microsoft Access Runtime available for Access 2019. You can connect to Access 2019 database from Altova products only if Microsoft Access 2016 Runtime is installed and only if the database does not use the "Large Number" data type.

Microsoft Azure SQL Database

SQL Server 2016 codebase

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

Microsoft SQL Server on Linux


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


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


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.

Sybase ASE 15, 16


Teradata 16


 

© 2019 Altova GmbH