[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 enable access to a wide variety of 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 with a query, and create a dashboard with several data visualizations.
Click on Database.
Select "Build Query" as 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: The username and password are not required by QODBC or QuickBooks but it is mandatory in Microstrategy and thus it is added here.
Please Note: If you have a 64-bit application, then you need to use QRemote 64-bit DSN "QuickBooks Data 64-bit QRemote". Please refer: How to configure QRemote
Data source added.
Double click on Data source name to see the list of available table.
Click "Edit SQL" for writing SQL query.
Enter the query in the Editor
Select Data Access Mode which you want to select.
On the resulting page, click Select Visualization -> Bar Chart -> Clustered Bar Chart.