Use Custom JDBC drivers

Document created by rich_patterson Employee on Oct 23, 2014Last modified by dave_lesshafft on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
As an example, you are using Microsoft SQL Server 2008 and you would like to use a Custom DB connection..
This is the reference guide link for Database Connection.

 

Please refer to this link for reference information from the Microsoft SQL Server site

 

-- Choose Database Type: Custom
-- Download the drivers from: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
-- Install the correct jar file into <atom install folder>/userlib/database
-- Use the sqljdbc4.jar for Java 6, use sqljdbc.jar for Java 7
-- Choose Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

Example Connection URL:
jdbc:sqlserver://localhost:1433;databaseName=Test

Attachments

    Outcomes