Database Connector

Note: Before working with the Database Connector, you should be familiar with general Process Development.

The Database Connector is designed to select, insert, update and delete records in a database. The Database Connector will store all the relevant connection details for your database. However, it does not contain the actual SQL statements; those are in the Database Profile.

Dell Boomi AtomSphere uses JDBC to connect to the database. You will need a JDBC driver for each type of database you wish to connect to. The Database Connector comes pre-loaded with a JDBC driver for SQL Server, so no additional steps are needed for this database. But if you wish to connect to a different type of database, you will need to obtain a JDBC driver for that database and configure it in AtomSphere. Your database vendor will likely be able to provide you with this driver. Additionally, there are third-party companies that sell commercial JDBC drivers. If you are unable to find a JDBC driver for your database, as a last resort you may consider using a JDBC-ODBC bridge (see Forum post for configuration).

Database Connector Configuration

Configuring a Connector to communicate with your database requires the setup of two different components:

This design allows for reusability of the components, which contain connection settings such as user name, password etc. Once your connection and operation are built, you will need to set up your Connector within the process model. When your Connector is configured properly within your process, AtomSphere will be able to map to and from virtually any system using the Database Connector to select, insert, update and/or delete data from your database.

Supported Databases (Versions)

The Database Connector supports any database that has a JDBC driver. Some common examples include:

Apache Derby
IBM DB2
Microsoft ODBC
Microsoft SQL Server (7, 2000, 2005)
MySQL (4.x, 5.x)
Oracle (8i, 9i, 10g, 11g)
Sybase
Any other JDBC- or ODBC-compliant database

Prerequisites

The Atom must be deployed locally to the database server itself or to another machine within your network that can access it.
You must have database connection information including server host/IP address and port, and user name and password. The user name and password configured on the database must have sufficient permissions to access the objects required by the integration scenario. For more information, refer to the documentation that came with your database.
The database and tables must already exist. The Database Connector does not create tables or other objects.
A JDBC driver must be installed and configured. The Database Connector contains drivers for Microsoft SQL Server and Oracle. If you need to connect to another type of database you must: obtain the appropriate JDBC driver; if you are using a local Atom copy it to <Atom_installation_directory>\lib; if you are using a Molecule or Atom Cloud copy it to <Atom_installation_directory>\userlib; then restart the Atom.