Back to MS SQL Integrations
Bridge Adapter · Version 1.0.2

Database Mssql

GitHub

kinetic-bridgehub-adapter-database-mssql

An extension of the Generic JDBC Bridge that has been customized to simplify the deployment and implement MSSQL specific features

Microsoft SQL Bridgehub Adapter

A Kinetic Bridgehub adapter for the Microsoft SQL server

MS SQL Bridgehub Adapter Information


Configuration Values

Name Description
Username The username that will be used to access the Kinetic Core information
Password The password that is associated with the username
Server The domain or IP address
Port The port number
Database Name Name of the database to connect to

Example Configuration

Name Value
Username SA
Password Password1
Server 127.0.0.1
Port 1433
Database Name TestDB

Supported Structure

The structure will match a table in the configured database. ex: Inventory

Fields

Fields will be converted to column names in the query to the sql database. If no fields are provided the "*" will be inserted into the query.

Query

The query will be converted to the condition for the where clause. A query is required for the search and retrieve methods.

General Bridgehub Information


What is a Bridgehub adapter?

A Bridgehub adapter is an extension to be used with the Kinetic Bridgehub project. Each adapter allows Kinetic Bridgehub to retrieve data from the data source specified by the adapter.


Bridgehub adapter basics

Properties

Bridgehub properties are a set of parameters specific to each Bridgehub adapter. These parameters are normally configuration values for properties like username, password, server location, etc.

Initialize

A one time initialization method for the Bridgehub adapter that is required to successfully complete before any of the implementation methods (count,retrieve,search) can be executed. This allows an adapter author to pre-load operations to improve the speed of the implementation methods, validate the adapter properties, and set variables that can be used by other methods.

Count

An implementation method that returns the amount of records for a given Structure and Query.

Retrieve

An implementation method that returns a single record containing the specified Fields for a given Structure and Query. If there is more than one record that matches the Structure/Query combination, an error is thrown.

Search

An implementation method that returns multiple records containing the specified Fields for a given Structure and Query. A search request can also optionally specify metadata (order,pagination,query parameters) to further refine the search results.

Using Parameters

To allow for the use of query parameters when calling the implementation methods, make sure that the adapter substitutes the query parameters before making its call. The following is an example of this being done using the Kinetic Core Adapter:

KineticCoreQualificationParser parser = new KineticCoreQualificationParser(); String substitutedQuery = parser.parse(request.getQuery(),request.getParameters());

Want more detail?

If you want more detail about how a Bridgehub adapter is structured and the various classes available to it, look at the Kinetic Bridgehub Adapter javadoc.


How is the adapter tested?

Kinetic Bridgehub adapters are tested using JUnit tests. To import a set of standard JUnit tests that all bridge adapters need to be able to pass, extend the JUnit class for an adapter with the BridgeAdapterTestBase class. To go along with the BridgeAdapterTestBase, a bridge-config.yml file needs to be included with the test resources at /src/test/resource/bridge-config.yml. An empty file with instructions on how to fill it out should be included in the repository by default.


How is the adapter built?

Kinetic Bridgehub adapters are built as Maven projects. To build the project from the command line, run the command mvn package from inside the adapter directory.

NOTE: Before building the adapter you will need to make sure that the kinetic-bridgehub-adapter JAR has been added to the Maven project. Currently the kinetic-bridgehub-adapter is only available as a 3rd party JAR file (included in this repository), so it will need to be manually installed before the project will successfully build. Information on installing 3rd party JARs to Maven can be found here.


Adding the adapter to Bridgehub

Discovery file

Kinetic Bridgehub find and loads new adapters by looking for and loading up a file containing the main class of the Bridgehub Adapter. The name of the file is com.kineticdata.bridgehub.adapter.BridgeAdapter and it is located at /src/resources/META-INF/adapters/com.kineticdata.bridgehub.adapter.BridgeAdapter. The only thing that file should contain is the location of the main java adapter class. The following example shows the contents of the file for the Kinetic Core Adapter:

com.kineticdata.bridgehub.adapter.kineticcore.KineticCoreAdapter

Adding the JAR to Kinetic Bridgehub

Once it has been built, the adapter JAR goes into the WEB-INF\lib of the Kinetic Bridgehub installation. After restarting the server containing Kinetic Bridgehub, the newly installed adapter should now show up in the adapter list.

GitHub

On This Page

Looking for a workflow engine? Learn more about the Kinetic Data Enterprise Workflow Platform. Check it out
Return to Top