Skip to main content
Kinetic Community

Generic SQL Adapter

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

Requirements

  • 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 along with the JDBC Driver java library for the database(s) you want to connect to:
    • kinetic-calendar-sql-adapter.jar

Adapter Configuration

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

Connection Configuration

  • Adapter Class
    • com.kineticdata.calendar.adapters.sql.SqlAdapter
  • Properties
    • Username - Username for the SQL server
    • Password - Password associated with the username for the SQL Server
    • Adapter Class - JDBC Driver Class. See this website for popular JDBC Driver classes.
    • JDBC Connection URL - ​This is a specifically formatted URL that is different depending on which database you're connecting to. Documentation on building these connection strings are available for MS SQL, OracleMySQL, and Postgres. Others are also available online.

    MySQL Example Configuration

    mysql_jdbc_connection_example.JPG