Microsoft SQLServer

    1. Install Microsoft SQLServer

    Create the druid user

    • Create a druid user, enter when prompted for the password.
    • Databases - New Database
    • Database Name: druid, Owner: druid
    • To ensure the com.microsoft.sqlserver.jdbc.SQLServerDriver class is loaded you will have to add the appropriate Microsoft JDBC library (sqljdbc*.jar) to the Druid classpath.
    • For instance, if all jar files in your “druid/lib” directory are automatically added to your Druid classpath, then manually download the Microsoft JDBC drivers from ( https://www.microsoft.com/en-ca/download/details.aspx?id=11774) and drop it into my druid/lib directory.
    1. Configure your Druid metadata storage extension:

    Add the following parameters to your Druid configuration, replacing with the location (host name and port) of the database.