Forum Discussion
Enabling direct query for a data source via an odbc driver
Anonymous,
By using the custom data connector preview feature, you would need to create a date connector project in Visual Studio to define your own connector logic.
Based on this article, the sample that define logic that enable Direct Query for an ODBC based connector will come soon. Please keep an eye on the updates in this article, and your patience is appreciated.
Regards,
Hi Daniel,
No, I haven’t made any progress on the Direct Query Connection to a Progress, but I do know that they created their own connector and they’re selling it now. It’s called the Progress DataDirect Hive ODBC driver. This is for those of us who haven’t figured out how to make our own connector yet.
Here is the information regarding cost at the time of inquiry (November 2018):
Our licensing model is “per server” that our software is installed on. This includes all prod, non prod and DR servers. The list price for a perpetual license is $4699 per server, and all non prod is discounted at 50%. There is also a subscription option available for $1999 per server, per year.
If you are looking to install the driver on a desktop only, the pricing is different. The cost is $199 per desktop/workstation, with a minimum of qty 5.
Due to the cost I didn’t explore this option any further. However, if you try it would be great to hear your review of the product. Or, if you end up creating your own connector instead, I would be interested to know how you did it.
Eric
Hi Eric and everyone,
I see this post is a year old. I wanted to see if there is anyone who has installed Progress's DataDirect product to enable the Direct Query feature for ODBC data sources. I wanted to know the reviews and if it provides feasibility to change the mode to DirectQuery.
I am using Advantage Database Architect owned by Sybase, SAP. Ultimately, being ODBC data source while connecting to the Power BI.
Looking forward to your reply.
Thank you,
Snehal