Home

This wiki describes how to perform a database lookup within the Connect Data Mapper

• Introduction
• Microsoft SQL Lookup
  • Prerequisites for Microsoft SQL
  • SQL Statements with JDBC
  • Application in Connect Data Mapper
• Access, Excel and CSV Lookup
  • Prerequisites
    • Microsoft Access Database Engine 2010
    • Create 64-bit Data Source Names (DSN)
  • Building JDBC-ODBC Connection URL
  • Querying a Microsoft Access Database
  • Querying a Microsoft Excel Database
  • Querying a CSV file
  • Retrieving data from a Result Set
  • Closing JDBC Connections