%META:TOPICPARENT{name="SingleTierLiteJDBCPreInstallDocs"}%
= Using OpenLink JDBC Drivers with <nop>JetBrains <nop>DataGrip =

%TOC%

== OS X ==

# Launch <b><a href="https://www.jetbrains.com/datagrip/"><nop>DataGrip.app</a></b>.
# Open the <b>Manage Data Sources</b> dialog with <b>File</b> -> <b>Data Sources</b>.
# Click the <b>+</b> at upper left, and select <b>Driver</b> from the menu.
# [[https://www.jetbrains.com/datagrip/help/data-sources-and-drivers-dialog.html#driver|Register each driver]] you want to use --
#* OpenLink Enterprise Edition Generic Client
%BR%%BR%<a href="%ATTACHURLPATH%/JBDG-EEGC.png"><img src="%ATTACHURLPATH%/JBDG-EEGC.png" style="wikiautogen; max-width: 600px" /></a>%BR%%BR%
#* OpenLink Lite Edition JDBC-to-ODBC Bridge
%BR%%BR%<a href="%ATTACHURLPATH%/JBDG-LEJOB.png"><img src="%ATTACHURLPATH%/JBDG-LEJOB.png" style="wikiautogen; max-width: 600px"/>%BR%%BR%
#* OpenLink Virtuoso
%BR%%BR%<a href="%ATTACHURLPATH%/JBDG-Virt.png"><img src="%ATTACHURLPATH%/JBDG-Virt.png" style="wikiautogen; max-width: 600px"/>%BR%%BR%
#* OpenLink Virtuoso (SSL)
%BR%%BR%<a href="%ATTACHURLPATH%/JBDG-VirtSSL.png"><img src="%ATTACHURLPATH%/JBDG-VirtSSL.png" style="wikiautogen; max-width: 600px"/>%BR%%BR%
# Click <b>Apply</b> to save your changes, or <b>OK</b> to save your changes while exiting the dialog.
# Again click the <b>+</b> at upper left, and select the driver you want to use from the menu.
# Prepare a JDBC URL as appropriate to the driver in use --
#* [[JDBC1ConnectionURLFormat|OpenLink Lite Edition JDBC-to-ODBC Bridge]]
#* [[JDBC3ConnectionURLFormat|OpenLink Enterprise Edition Generic Client]]
#*[[http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html|OpenLink Virtuoso]] with or without SSL
# Name your data source as you like, and fill in the details.  For example --
%BR%%BR%<a href="%ATTACHURLPATH%/JBDG-LEJOB-config.png"><img src="%ATTACHURLPATH%/JBDG-LEJOB-config.png" style="wikiautogen; max-width: 600px"/>%BR%%BR%
# Click the <b>Test Connection</b> button, which should show success, as --
%BR%%BR%<a href="%ATTACHURLPATH%/JBDG-LEJOB-test.png"><img src="%ATTACHURLPATH%/JBDG-LEJOB-test.png" style="wikiautogen; max-width: 600px"/>%BR%%BR%
# Click <b>OK</b> to save and connect to your data source.
# Open the <b>Database</b> window with <b>View</b> -> <b>Tool Windows</b> -> <bDatabase</b>>.
# Drill down through the connected catalog, create and execute a query.  For instance --
%BR%%BR%<a href="%ATTACHURLPATH%/JBDG-LEJOB-query.png"><img src="%ATTACHURLPATH%/JBDG-LEJOB-query.png" style="wikiautogen; max-width: 600px"/>%BR%%BR%
# Refer to the [[https://www.jetbrains.com/datagrip/|DataGrip documentation]] for further activity.


== Windows ==

(notes to come)