Skip to main content
Kinetic Community

MSSQL Adapter

The MSSQL Adapter is used to retrieve data from a Microsoft SQL database.

Requirements

  • MS SQL Server, Database, Access, and defined SQL Query for retrieving event data
  • The following java libraries must be included in the Kinetic Calendar web application classpath:
    • kinetic-calendar-sql-adapter.jar
    • sqljdbc4.jar

Adapter Configuration

  • Adapter Class - This value must be added to the adapters.json configuration file:
    • com.kineticdata.calendar.adapters.sql.mssqlserver.MSSQLServerAdapter

Connection Configuration

  • Properties​
    • Use Integrated Security - Yes or No. See details below on how to use this feature.
    • Username - Username for the SQL server
    • Password - Password associated with the username for the SQL Server
    • Server\Instance - Server name and SQL server instance name (if any) seperated by a backslash.
    • Port - TCP port number the MS SQL server is listening on.
    • Database Name - The name of the database for which the SQL queries will execute against.

Integrated Security

In order to use the integrated security option (authenticating with the Microsoft SQL Server as the user running your J2EE application server) you must follow the steps below after unzipping the adapter install file:

 

  • Make sure you're running Kinetic Calendar on a Windows server. Integrated Security will not work on any other operating system.
     
  • Determine if the JVM your java applicaiton server is running on is either 32-bit or 64-bit.
     
  • Copy either the 32-bit (sqljdbc_x86/sqljdbc_auth.dll) or 64-bit (sqljdbc_x64/sqljdbc_auth.dll) version of the sqljdbc_auth.dll file that matches the architecture your JVM is using to a directory specified in your java.library.path variable.
     
  • Make sure your java application server is running as the Windows user account that you want to use for authenticating against the Microsoft SQL Server.
     
  • Restart your java application server.
     
  • Login to the bridge administrator console and change the 'Integrated Security' option from "No" to "Yes" (the Username and Password fields will be ignored now), set the Server, Port, and Database Name properties for your environment and save the changes.