SQL Databases

To interface with your back end database, you can visually create SQL statements for your mobile app.

When you tap a button or table row on your mobile device, your app will call the SQL Database Web Service located on your server with the URL that you provide when you register the SQL data source below.

You need to install the ViziApps SQL Database Web Service first, available for free, on your server. To download the free SQL Web Service source project for installation on your server, click on Download SQL Web Service Project. Use Visual Studio to build your web service on your server. This project is not a standard .NET web service with an .asmx file. Instead it is a web page .aspx page with a return response as a JSON . This enables our javascript code in the mobile app to interact with it in jQuery.

This Web Service uses the authentication protocol described in this document: SQL Authentication Protocol

1. Install Visual Studio 2012 on your server.
2. If you are going to use MySql, Install the MYSql ODBC 5.3.2 Driver on your server from https://dev.mysql.com/downloads/connector/odbc/
3. Copy the ViziApps source code project to the folder you want your web service to be called from with IIS on your server. This is the installation folder. Download the code here: http://viziapps.mobi/PageData/ViziAppsSQLWebService.zip
4. Configure IIS for your web service by adding a new website in IIS and point it to the installation folder.
5. Open the ViziApps source project with Visual Studio.
6. Edit the web.config file for the connection string to your database from this server in the app setting: DBConnectionString .
7. Build and Test Run your web service with Visual Studio. You know it works when you get a JSON message.
8. Configure your server for a public URL to the webservice. Add a server certificate to use https in the public URL.
9. Enter the public https URL of your web service on a browser on your desktop. You know it works when you get a JSON message.

The app needs to know what type of database you are using, the schema of your database and the URL to access the web service which sends queries to your database behind your firewall. To provide this information:

1. Enter a unique Data Source ID for your app.
2. Enter the URL of the SQL Web Service running on your server. Click Test to validate your web service.
3. Select your Database Type
4. Generate a .sql file containing your database schema, without data, from the SQL Server Management Studio using the generate scripts command for the database you want to access. Then Upload the .sql file, to ViziApps Studio so ViziApps gets the schema of your database. This will be used to automatically populate fields in creating SQL Commands.
5. Click Save and then Close

The following SQL databases are supported by ViziApps: