SQL Anywhere 17 is a relational database from SAP. The earlier editions were from the parent company Sybase.
SQL Anywhere 17 is a SAP database. The earlier editions were from the parent company Sybase.
Start SQL Central which is like SQL Server Management Studio for SQL Server and connect to SQL Anywhere Demo 17 database with credentials dba/sql.
Launch Power BI and click on Get Data and choose From OLE DB. Click on Build to open Data Link Properties as shown.
SqlAnyOleDB_00
Choose SQL Anywhere OLE DB Provider 17 from the above drop-down.
Click Next. Provide User Name and Password and click allow saving password and browse to find the database demo. as shown
SqlAnyOleDB_01
Click demo and click Test Connection.
This should display a success message as shown.
SqlAnyOleDB_02
Click OK. The From OLE DB window gets filled as shown.
SqlAnyOleDB_03
Again the Access a datasource using OLEDB Provider comes up as shown. Actually this UI needs to be better designed. The credentials were already entered in a previous wizard screen.
SqlAnyOleDB_04
Again use the dba/sql password and click connect.
Looks like the Power BI does not accept the UI designed connection string
SqlAnyOleDB_05
The connection string was created by Power BI after accepting valid entries. Looks like there is a problem.
This is being looked into and come back to this site. The work around will be posted as soon as it is found.
SQL Anywhere 17 is a SAP database. The earlier editions were from the parent company Sybase.
Start SQL Central which is like SQL Server Management Studio for SQL Server and connect to SQL Anywhere Demo 17 database with credentials dba/sql.
Launch Power BI and click on Get Data and choose From OLE DB. Click on Build to open Data Link Properties as shown.
SqlAnyOleDB_00
Choose SQL Anywhere OLE DB Provider 17 from the above drop-down.
Click Next. Provide User Name and Password and click allow saving password and browse to find the database demo. as shown
SqlAnyOleDB_01
Click demo and click Test Connection.
This should display a success message as shown.
SqlAnyOleDB_02
Click OK. The From OLE DB window gets filled as shown.
SqlAnyOleDB_03
Again the Access a datasource using OLEDB Provider comes up as shown. Actually this UI needs to be better designed. The credentials were already entered in a previous wizard screen.
SqlAnyOleDB_04
Again use the dba/sql password and click connect.
Looks like the Power BI does not accept the UI designed connection string
SqlAnyOleDB_05
The connection string was created by Power BI after accepting valid entries. Looks like there is a problem.
This is being looked into and come back to this site. The work around will be posted as soon as it is found.
No comments:
Post a Comment