Connections

Here you need to add all connections you require for your entire application. When you add a new query you will need to select the required connection from the list.

We support Microsoft SQL Server and Oracle through Native connections and you can also connect to any Database that supports ODBC (like MySQL, DB2 and PosgreSQL).When using MSSQL you can also run stored procedures


Properties

  1. Name

    A name you can use to identify the connection in a list
  2. Server Name/Dsn Name

    A SQL or Oracle server name This is typically a <network machine name>/<SQL instance name> combination.

    For ODBC use the Dsn name you specified when setting up the ODBC Datasource. You'll need a User DSN to connect via the Designer, and a Service DSN on the server to connect through the Generated App. Make sure you add a "System DSN" here, as a "User DSN" does not work. If you are working on a 64-bit environment, set up a 64-bit ODBC Data Source.

  3. SQL Server/Oracle/ODBC Authentication

    SQL Server, Oracle and all ODBC databases can be set up to be accessible by way of a username and password combination for the database server.
  4. Use Windows Authentication (SQL Server only)

    SQL Server can be set up to be accessible by using Windows credentials.
  5. Select or enter a database name (SQL and ODBC)

    The database you wish to access when using the connection. If the database server is accessible from the designer machine, then you can use the drop-down to find the database.