Forum Discussion

Yggdrasill's avatar
Yggdrasill
Responsive Resident
6 years ago

Pervasive SQL

I'm trying to connect to a db. I'm getting the name of the db but no tables.

 

This is what I've done so far

  1. Installed Pervasive ODBC Client Interface drive
     
  2. Setup System DNS in ODBC Data Source Administrator (32-bit) like following (Test works)
  3. In Get Data I chose ODBC and ICESF as DSN
  4. Navigator shows the following

    All the db are empty except for one dummy db.

Now for authenticating I've tried

  1. Windows auth - which works. My windows account is in the admin group on the server
  2. Database - my user/pass works with the same result as above

 

On the server side I've created an Engine DSN like in these Instructions 

  • 64bit OS, with 32-ODBC Engine interface

 

Has anyone here successfully pulled out data from Pervasive SQL v.13 with Power Query in Power BI Desktop ?

 

Please, share

Need Help
Show and Tell

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Yggdrasill,

    Accorin to your description, it seems that you could connect to Pervasive SQL successfully, but you can't get the table from database, right? And it seems that when you use windows credential , it could work, right?

    You need to make sure the user(which use database credential) have permission to these table. In addition, if you write the SQL query in advanced option, will you get table data?

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.