Driver for Cisco Information Server (CIS)

I might just happen to have a solution for you!

CIS connectivity requires setting up a custom JDBC driver connection.

1. First, locate the jdbc file within your server software installation folder at <installation drive on CIS server>:\CIS <version>\apps\jdbc\lib\ . You want the "csjdbc-<version>.jar" file. Grab the highest versioned one available to you. If you happen not to have a version included at the end of your filename use "csjdbc6.jar". If you don't have that, use "csjdbc.jar".
2. Copy that file into a local folder on your system (I specifically use C:\CIS Drivers\csjdbc-0317.jar)
3. In data grip, open up your data connections (shortcut is ctrl+alt+shift+S) and hit the green plus in the top left. At the very bottom of that list is "Driver", select that.
4. Go ahead and name your driver at the top of this screen.
5. Center of the screen, under Driver files > Additional files: hit the green plus, and point it towards your local jdbc driver (like C:\CIS Drivers\csjdbc-0317.jar)
6. Top of the screen again, under Class, select "cs.jdbc.driver.CompositeDriver" from the dropdown.
7. After this, hit "Apply" and your driver should be set up. You can add this driver as a new connection the same way you would any other environment.

Also, just in case you need it, the JDBC connection string you will need is this:

jdbc:compositesw:dbapi@<servername or IP address>:<port, default is 9401>?domain=<"composite" or active directory domain name>&dataSource=<the name of your database service>

Hopefully this works for you, good luck!

Hi,
You can refer to our online help https://www.jetbrains.com/help/datagrip/connecting-to-a-database.html#vertica_as_unsupported_dbms

Thank you.