Database Connection

The documentation about Database Drivers, see : Database Driver

What is a Database Connection

Use a Database Connection to define a connection to any database. Database Connections are used for accessing external tables to your file-based datasets. A connection provides information to an application to connect to the given database.

To make a Connection from a Java application to a database, a database driver is required. Many databases provide a Java class to access their database using the SQL language. These are JDBC drivers.

Depending on the Driver, a URL will provide the information the driver needs to establish the connection and allow the application to execute SQL-commands on the database.

In Orbit GIS each Database Connection has an individual name. This connection name is registered with the resource you use it for :

joining a database table to a dataset, see : Table Join.
spatial database, see : Coordinate Reference System

When using this resource in EOS, EOS must have the same declaration as defined in Orbit GIS to access the same data. Therefore, you require to create the Database Connection for EOS equal.

Configuration Connection

Add a connection by clicking the plus button and configure an existing one by selecting the connection in the list of available connections.

Connection
Name	The user name of the JDBC Data Source. This is what you will use in Orbit GIS, and it must be unique.
Description	An optional description of the Data Source.
Username	The name of the user to access the database with.
Password	The password for that user.
Driver	The JDBC Driver to be used.
URL	The connection string that will allow the application to connect to the database and execute commands. The format of this URL is driver dependant, and you probably need to consult the driver documentation to get the right syntax.
Test Connection	Complete the connection configuration and click the Test Connection button. The result should be “OK”. If not, check the connection parameters. In most cases, the URL syntax is not properly constructed. If you're not familiar to this issue, consult your IT-manager or java.sun.com.

URL syntax

Database	standard URL syntax
MySQL SQL Server MS Access (32bit - v.6) MS Access (64bit - v.12) Oracle PostgreSQL	jdbc:mysql://<host>/<database connection> jdbc:sqlserver://<host>;<database connection> jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=<complete file path with extension> jdbc:odbc:Driver={Microsoft Access Driver (.mdb, *.accdb)};DBQ=<complete file path with extension> jdbc:oracle:thin:@<host>/orcl jdbc:postgresql://<host>/postgres

Database

standard URL syntax

MySQL
SQL Server
MS Access (32bit - v.6)
MS Access (64bit - v.12)
Oracle
PostgreSQL

jdbc:mysql://<host>/<database connection>
jdbc:sqlserver://<host>;<database connection> 
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=<complete file path with extension>
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=<complete file path with extension>
jdbc:oracle:thin:@<host>/orcl
jdbc:postgresql://<host>/postgres

32 bit or 64 bit Microsoft Access Database Engine have to be installed on your Windows Operating system to use the Microsoft ODBC connection tool.