topic Re: Connecting to SAS 9.4 M6 from an external application (IRI Workbench) via JDBC in Administration and Deployment

Connecting to SAS 9.4 M6 from an external application (IRI Workbench) via JDBC

Rajkumar20 — Wed, 06 Jan 2021 13:36:49 GMT

As part of new testing, we are trying to connect to SAS 9.4 M6 from an external application (IRI Workbench) via JDBC. To connect with SAS from IRI Workbench, JDBC connection details are required and I'm looking for help in finding that.

Re: Connecting to SAS 9.4 M6 from an external application (IRI Workbench) via JDBC

AnandVyas — Wed, 06 Jan 2021 13:47:14 GMT

Hi @Rajkumar20

If you are trying to invoke SAS (eg: workspace server) using external application you can use IOM.

KB link: https://support.sas.com/kb/26/049.html

JDBC eg: https://support.sas.com/rnd/itech/doc9/dev_guide/dist-obj/javaclnt/javaprog/jdbcconn.html

If you have a specific web application that you want to access you can refer to the documentation guide for APIs that can be used to consume and perform actions.

Re: Connecting to SAS 9.4 M6 from an external application (IRI Workbench) via JDBC

AhmedAl_Attar — Wed, 06 Jan 2021 19:45:57 GMT

You'll need to

Download the correct SAS Drivers for JDBC
Follow the steps described in the SAS® 9.4 Drivers for JDBC: Cookbook

Hope this helps,

Ahmed