topic Re: Connection with CA PPM database in New SAS User

Connection with CA PPM database

dtravassos — Wed, 15 May 2019 22:09:56 GMT

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

Re: Connection with CA PPM database

Ksharp — Thu, 16 May 2019 12:40:40 GMT

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

Re: Connection with CA PPM database

dtravassos — Fri, 17 May 2019 19:50:14 GMT

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.

Re: Connection with CA PPM database

Ksharp — Sat, 18 May 2019 11:22:26 GMT

ERROR: The JDBC engine cannot be found.

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

Re: Connection with CA PPM database

dtravassos — Mon, 20 May 2019 16:20:19 GMT

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.