-
On the left side options column expand Data Sources, expand Bulk Sources, and click on Query.
-
On the Query Data Sources page click Create Bulk Query button.
-
On the New Query Data Source page click the ODBC Query Data Source button.
-
The page to configure the ODBC Data Source opens.
- Enter a Name for the query.
- Connection – select the connection to be used from the drop down list.
- Click Validate. If the validation is successful, the Edit Query button becomes active.
-
Click Edit Query – opens the Query Builder to create a new query or edit an existing query.
- After the query has been created click on Save Query to return to the ODBC Query Data Source window.
- IMPORTANT: In Order to save the data query source at this point, the user must click on Validate and have the validation return a successful message. Once the successful message is returned, the Edit Query, Save, and Preview buttons will become active.
- Click Save to save the query source.