ODBC Connector 24.2

# Extract Data from Multiple Tables

In a relational database, information about a single subject can be divided between multiple tables. This allows data to be stored more efficiently.

Consider the following tables. You might need to extract data from the Orders and Customers tables:

Table: Orders
OrderID
Date
CustomerID
Status
Table: Customers
CustomerID
Title
FirstName
LastName
Address1
Address2
Town
Postcode

To extract data from multiple tables, you can use the `SubTables` parameter.

To extract data from multiple tables, complete the following tasks:

- Configure the Connector
- Modify the Main Template File
- Create the Sub Table Template File
- Start the Connector

NOTE: These procedures assume that you have completed the steps in Extract Data from a Single Table.

Copyright 2024 Open Text
Version 24.2 | Last updated March 2024

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL ODBC Connector 24.2

Topic Title: Extract Data from Multiple Tables