Configure the Database Connection ¶Īfter the driver is installed, specify these inputs during configuration of the Database connection:ĭriver: Select the Microsoft Access driver. accdb extension, you may need to obtain a later version of the ODBC driver such as the Microsoft Access 2010 Redistributable (Win XP/Vista/ R2/2008/2012). However, if your database is Access 2007 or later with the. The Microsoft Access ODBC driver is typically installed as part of Windows. Note that the Jitterbit team has not tested Linux ODBC drivers for Microsoft Access. Microsoft Office must be installed on the same system that the Private Agent is running on, and that system must be a Windows operating system. You must be running a Private Agent in order to connect to Microsoft Access. Multiple search conditions within a WHERE clause.Specifying a search condition using the WHERE clause.WHERE (WORKDEPT, EDLEVEL, JOB) = ('E11', 12, 'CLERK')įor additional examples, refer to the IBM Knowledge Center articles for the specific version: These instructions are for installing the JTOpen (AS400) JDBC driver. Note that if you want to use additional features, such as being able to provide a manual query, these are available using the JDBC driver only. You can connect to DB2 on iSeries using either a JDBC or ODBC driver. For general information and instructions on installing additional drivers on Private Agents, refer to Install Additional ODBC or JDBC Drivers. In addition, you can install other database drivers on Private Agents as needed. For Private Agents, installed drivers are detected from the operating system where each Private Agent is installed. For Cloud Agents, managed by Jitterbit, a set of commonly used JDBC drivers is already provided. Note that this page is not comprehensive Jitterbit Harmony supports most ODBC- and JDBC-compliant databases.ĭatabase drivers are automatically detected from the Harmony Agent. This page provides information on installation and configuration of certain database drivers. Add Your Driver to the Private Agent Config Fileĭatabase-specific Information ¶ Introduction ¶.Install the Oracle Client on the Harmony Private Agent. Database-Specific Information Database-Specific Information Table of Contents.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |