Please enable JavaScript to view this site.

Altova MobileTogether Designer

» No topics above this level «

Databases

Scroll Home Prev Top Next More

You can use databases (DBs) as data sources of MobileTogether designs. This allows data from DBs to be displayed in MobileTogether solutions. It also allows end users to edit data in DBs from their mobile devices. You can use multiple editable DB data sources. Data in these DB sources can then be retrieved, edited, and saved using a variety of mechanisms, including XQuery expressions.

MTDDBCDataSrcMain01

 

This section

This section is organized as follows:

 

DBs as Data Sources

Connecting to a DB

Selecting DB Objects as Data Sources

Editing DB Data

Saving Data to the DB

The DB Execute Action

Displaying DB Data

Database Query

 

See the database tutorial, Database-And-Charts, for a detailed description of a MobileTogether design which uses multiple data sources that can be edited in the MobileTogether Client solution. Also see the video demos of database use.

 

 

Database support

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


 

For connecting to a SQLite DB, use MobileTogether Designer's Connection Wizard.

 

Note

On Linux and macOS servers, the only database connections supported are JDBC.

 

© 2019 Altova GmbH