[QODBC-Desktop] How to use QODBC with Microstrategy
Posted by Jack - QODBC Support on 19 December 2016 01:17 PM
How to use QODBC with Microstrategy
QODBC enables access to various important data sources in business intelligence tools such as Microstrategy. In this article, We will show how to connect to QuickBooks data, import data with the UI or query, and create a dashboard with several data visualizations.
Click on Database.
Select "Build Query" as the Import option & click "Next."
On the dashboard, click "Add.." to add a connection to QuickBooks.
In the dialog that is displayed, the following information is required:
Note: QODBC or QuickBooks do not require the username and password, but it is mandatory in Microstrategy, and thus it is added here.
Please Note: If you have a 64-bit application, you must use QRemote 64-bit DSN "QuickBooks Data 64-bit QRemote". Please refer: To how to configure QRemote.
Data source added.
Double-click on the Data source name to see the list of available tables.
Click "Edit SQL" to write an SQL query.
Enter the query in the Editor
Select Data Access Mode that you want to select.
On the resulting page, click Select Visualization -> Bar Chart -> Clustered Bar Chart.