Forum Discussion

cosminfuiorea's avatar
cosminfuiorea
New Member
9 years ago

Sybase IQ JDBC Driver

Hi,   I have noticed there is no JDBC Driver enlisted on the supported connection types.   I want to connect to a Sybase IQ Database and want to know if this is possible via a JDBC Driver.   Th...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi cosminfuiorea,

Do you want to connect to Sybase IQ database from Power BI Desktop? If that is the case, based on my research, you can install SAP SQL Anywhere driver on your computer, make sure that the driver you install matches your Power BI Desktop installation (32-bit or 64-bit).  Then connect to Sybase IQ database using the entry shown in the following screenshot.


Another method is to create a ODBC data source for your Sybase IQ database following the instructions in the article , then connect to the ODBC data source via ODBC entry in Power BI Desktop.




Thanks,
Lydia Zhang

  • cosminfuiorea's avatar
    cosminfuiorea
    New Member
    9 years ago

    Hi Lydia, Thank you for the quick reply, it is very clear now. Another thing if I may. I am planning to build a dashboard using On Premises Gateway and DirectQuery to my SQL Server Database. This Dashboard will reside in an SSRS environment. Will all the people that access it need a Power BI Pro account in order to view the data? Thank you for your help! Cosmin

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      cosminfuiorea wrote:

      Hi Lydia, Thank you for the quick reply, it is very clear now. Another thing if I may. I am planning to build a dashboard using On Premises Gateway and DirectQuery to my SQL Server Database. This Dashboard will reside in an SSRS environment. Will all the people that access it need a Power BI Pro account in order to view the data? Thank you for your help! Cosmin



      Hi cosminfuiorea,

      Could you please open a new thread about the new issue? And since the old issue is resloved, please help to accept helpful reply as solution. That way, other community members could benefit from the solution.

      Thanks,
      Lydia Zhang