Connection with CA PPM database

[dtravassos]

Hello,

I am the first person to use SAS in my area and i'm struggling to establish a connection with our server.

It seems like we have two servers

1) A local power BI server

2) Cloud based database 

Has anyone had experience connecting SAS with power BI server and cloud based database?

Thank you very much

Danielle 

[Ksharp]

If you could get database's ODBC driver,maybe you could connect it with SAS.

For Windows OS :

Start->control panel->manage tools->data source-> setup a DSN 

[dtravassos]

Hi,

Thank you for your reply.

The third party uses JDBC. I'm to install the SAS JDBC drivers for win 10 but i'm getting the error "this application does not support your platform. I try the only two drivers available for windows.

I'm able to connect via Squirrel SQL and the connection works fine.

When I try to declare the libname, I get this error:

36 libname bean jdbc driverclass="com.jaspersoft.jdbc.driver.JasperDriver"
37 URL="jdbc:jaspersoft@https://cppmrpt4003.ondemand.ca.com/reportservice;datasource=/ca_ppm/data_sources/CA_PPM_BEAN;
37 ! pagesize=500" user=reportdev|cppm4001
38 password=XXXXXXXXXXX classpath="c:\lib";
ERROR: The JDBC engine cannot be found.
ERROR: Error in the LIBNAME statement.

[Ksharp]

ERROR: The JDBC engine cannot be found.

You can't use JDBC , try ODBC if you have it .

[dtravassos]

Hi Unfortunately, the third part database uses JDBC.

I use Squirrel SQL to access it and works well. I cant believe, SAS cant access a database, though.