Connecting Qlik GeoAnalytics Plus to a local database

This page describes how you connect to a local database with GeoAnalytics Plus.

  1. If it not already done, find the ODBC driver jar needed to connect to your database.
  2. Put the jar in the folder similar to (depending on windows installation):

    C:\Program Files\Common Files\Qlik\Custom Data\QvIdevioConnector\lib\driver

    (prior to GeoAnalytics 1.5.3, put it in the lib folder)

  3. In Qlik open the GeoAnalytics ‘Select Data’.

    Connect to database dialog

  4. Select Dataset Type ‘Connect to Database’.
  5. The URL should contain the connection string for the database. It start with jdbc: and then contain the type of database and name of database. For examples of common formats see Connection string examples for common databases..
  6. If the database need any username or password you can put them in the respective field.
  7. The connector can either get all data in a specific table or get the result data from a select statement. Only one need to be chosen.
  8. The ‘Key field’ should contain the name of the column that contain the primary id of the table or the result. If left blank a key column is generated.
  9. The name of the geometry column should be given in ‘Geometry Field’ together with the type of geometry in ‘Geometry Type’. If there are no geometries in the result, set the ‘Geometry Type’ to None.

Common JDBC Drivers

You can find drivers for your database here:

Connection string examples for common databases.

  • IBM DB2

    jdbc:db2://<HOST>:<PORT>/<DB>

  • JDBC-ODBC Bridge (Note only available if you have java 1.7 installed)

    jdbc:odbc:<DB>

  • Microsoft SQL Server

    jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>

  • Oracle Thin

    jdbc:oracle:thin:@<HOST>:<PORT>:<SID>

  • PointBase Embedded Server

    jdbc:pointbase://embedded[:<PORT>]/<DB>

  • Cloudscape

    jdbc:cloudscape:<DB>

  • Cloudscape RMI

    jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB>

  • Firebird (JCA/JDBC Driver)

    jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB>

  • IDS Server

    jdbc:ids://<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>'

  • Informix Dynamic Server

    jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME>

  • InstantDB (v3.13 and earlier)

    jdbc:idb:<DB>

  • InstantDB (v3.14 and later)

    jdbc:idb:<DB>

  • Interbase (InterClient Driver)

    jdbc:interbase://<HOST>/<DB>

  • Hypersonic SQL (v1.2 and earlier)

    jdbc:HypersonicSQL:<DB>

  • Hypersonic SQL (v1.3 and later)

    jdbc:HypersonicSQL:<DB>

  • Microsoft SQL Server (JTurbo Driver)

    jdbc:JTurbo://<HOST>:<PORT>/<DB>

  • Microsoft SQL Server (Sprinta Driver)

    jdbc:inetdae:<HOST>:<PORT>?database=<DB>

  • Microsoft SQL Server 2000 (Microsoft Driver)

    jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]

  • MySQL (MM.MySQL Driver)

    jdbc:mysql://<HOST>:<PORT>/<DB>

  • Oracle OCI 8i

    jdbc:oracle:oci8:@<SID>

  • Oracle OCI 9i

    jdbc:oracle:oci:@<SID>

  • PostgreSQL (v6.5 and earlier)

    jdbc:postgresql://<HOST>:<PORT>/<DB>

  • PostgreSQL (v7.0 and later)

    jdbc:postgresql://<HOST>:<PORT>/<DB>

  • Sybase (jConnect 4.2 and earlier)

    jdbc:sybase:Tds:<HOST>:<PORT>

  • Sybase (jConnect 5.2)

    jdbc:sybase:Tds:<HOST>:<PORT>

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?