Troubleshooting - How to use QODBC Online with FileMaker

Problem Description:

I downloaded the trial version of your driver this morning and am really excited about the prospects. I’ve installed it and am able to get the fields and tables to appear in QODBC Test Tool, but I am not able to connect using FileMaker Pro. 

Solutions:

Please follow the below-mentioned steps for FileMaker connectivity using QODBC Online

1) Open FileMaker Pro & click on the Browse button.

2) Please select the ODBC data source.

 

3) Please select the ODBC data source "QuickBooks Online Data" & click on the "Continue" button.

For FileMaker 64-Bit, please select "QuickBooks Online Data 64-Bit QRemote"

4) Please enter the username & password for the ODBC data source. If you have not defined any username & password, then click on the "OK" button.  

 

5) Select tables & columns that you want to use, then please click on "Insert into SQL Query" & "Execute" button.

6) Save results & you can see results.

Tags: QuickBooks Online, QBO, FileMaker, QODBC Online