API Concepts - Kinetica Docs

Native

Connecting via API

The following shows the means of connecting to Kinetica via the various APIs available.

HTTP Connections

#include "gpudb/GPUdb.hpp"

gpudb::GPUdb::Options options = gpudb::GPUdb::Options();
options.setUsername("<username>");
options.setPassword("<password>");

gpudb::GPUdb kinetica("http://<db.host>:9191", options);

using kinetica;

Kinetica.Options options = new Kinetica.Options();
options.Username = "<username>";
options.Password = "<password>";

Kinetica kinetica = new Kinetica("http://<db.host>:9191", options );

import com.gpudb.GPUdb;

GPUdb.Options options = new GPUdb.Options()
    .setUsername("<username>")
    .setPassword("<password>");

GPUdb kinetica = new GPUdb("http://<db.host>:9191", options);

<script type="text/javascript" src="GPUdb.js"></script>
<script type="text/javascript">
var kinetica = new GPUdb(
    "http://<db.host>:9191",
    {
        username: "<username>",
        password: "<password>"
    }
);
</script>

// To install Kinetica, first run this from the CLI: npm i @kinetica/gpudb
var GPUdb = require("@kinetica/gpudb");
var kinetica = new GPUdb(
    ["http://<db.host>:9191"],
    {
        username: "<username>",
        password: "<password>"
    }
);

import gpudb

options = gpudb.GPUdb.Options()
options.username = "<username>"
options.password = "<password>"

kinetica = gpudb.GPUdb(
    host=["http://<db.host>:9191"],
    options = options
)

# Example call invoking the /show/system/properties endpoint
#   and requesting the database's version number
curl --location --request POST \
     'http://<db.host>:9191/show/system/properties' \
     --user <username>:<password> \
     --data '{"options": {"properties": "version.gpudb_core_version"}}' \
     --header 'cache-control: no-cache' \
     --header 'content-type: application/json'

HTTPS Connections with Certificate Validation

#include "gpudb/GPUdb.hpp"

gpudb::GPUdb::Options options = gpudb::GPUdb::Options();
options.setUsername("<username>");
options.setPassword("<password>");

gpudb::GPUdb kinetica("https://<db.host>:8082/gpudb-0", options);

using kinetica;

Kinetica.Options options = new Kinetica.Options();
options.Username = "<username>";
options.Password = "<password>";

Kinetica kinetica = new Kinetica("https://<db.host>:8082/gpudb-0", options );

import com.gpudb.GPUdb;

GPUdb.Options options = new GPUdb.Options()
    .setUsername("<username>")
    .setPassword("<password>");

// By default, the Java system CA trust store will be used;
//   to specify a different trust store, use these options:
options.setTrustStoreFilePath("</path/to/truststore.jks>");
options.setTrustStorePassword("<trustStorePassword>");

GPUdb kinetica = new GPUdb("https://<db.host>:8082/gpudb-0", options);

<script type="text/javascript" src="GPUdb.js"></script>
<script type="text/javascript">
var kinetica = new GPUdb(
    "https://<db.host>:8082/gpudb-0",
    {
        username: "<username>",
        password: "<password>"
    }
);
</script>

// To install Kinetica, first run this from the CLI: npm i @kinetica/gpudb
var GPUdb = require("@kinetica/gpudb");
var kinetica = new GPUdb(
    ["https://<db.host>:8082/gpudb-0"],
    {
        username: "<username>",
        password: "<password>"
    }
);

import gpudb

options = gpudb.GPUdb.Options()
options.username = "<username>"
options.password = "<password>"

kinetica = gpudb.GPUdb(
    host=["https://<db.host>:8082/gpudb-0"],
    options = options
)

# Example call invoking the /show/system/properties endpoint
#   and requesting the database's version number
curl --location --request POST \
     'https://<db.host>:8082/gpudb-0/show/system/properties' \
     --user <username>:<password> \
     --data '{"options": {"properties": "version.gpudb_core_version"}}' \
     --header 'cache-control: no-cache' \
     --header 'content-type: application/json'

HTTPS Connections without Certificate Validation

Using these setups, no certificate validation of any kind will be performed; not recommended for production deployments.To bypass certificate checks in JDBC, see Secure Connections. To bypass certificate checks in KiSQL, see Parameterized Options.

import com.gpudb.GPUdb;

GPUdb.Options options = new GPUdb.Options()
    .setBypassSslCertCheck(true)
    .setUsername("<username>")
    .setPassword("<password>");

GPUdb kinetica = new GPUdb("https://<db.host>:8082/gpudb-0", options);

import gpudb

options = gpudb.GPUdb.Options()
options.username = "<username>"
options.password = "<password>"
options.skip_ssl_cert_verification = True

kinetica = gpudb.GPUdb(
    host=["https://<db.host>:8082/gpudb-0"],
    options = options
)

# Example call invoking the /show/system/properties endpoint
#   and requesting the database's version number
curl --location --request POST \
     'https://<db.host>:8082/gpudb-0/show/system/properties' \
     --user <username>:<password> \
     --data '{"options": {"properties": "version.gpudb_core_version"}}' \
     --insecure \
     --header 'cache-control: no-cache' \
     --header 'content-type: application/json'

HTTPS Connections with OIDC/OAuth Authentication

#include "gpudb/GPUdb.hpp"

gpudb::GPUdb::Options options = gpudb::GPUdb::Options();
options.setOauthToken("<oauthToken>");

gpudb::GPUdb kinetica("https://<db.host>:8082/gpudb-0", options);

using kinetica;

Kinetica.Options options = new Kinetica.Options();
options.OauthToken = "<oauthToken>";

Kinetica kinetica = new Kinetica("https://<db.host>:8082/gpudb-0", options );

import com.gpudb.GPUdb;

GPUdb.Options options = new GPUdb.Options()
    .setOauthToken("<oauthToken>");

GPUdb kinetica = new GPUdb("https://<db.host>:8082/gpudb-0", options);

<script type="text/javascript" src="GPUdb.js"></script>
<script type="text/javascript">
var kinetica = new GPUdb(
    "https://<db.host>:8082/gpudb-0",
    {
        oauth_token: "<oauthToken>"
    }
);
</script>

// To install Kinetica, first run this from the CLI: npm i @kinetica/gpudb
var GPUdb = require("@kinetica/gpudb");
var kinetica = new GPUdb(
    ["https://<db.host>:8082/gpudb-0"],
    {
        oauth_token: "<oauthToken>"
    }
);

import gpudb

options = gpudb.GPUdb.Options()
options.oauth_token = "<oauthToken>"

kinetica = gpudb.GPUdb(
    host=["https://<db.host>:8082/gpudb-0"],
    options = options
)

# Example call invoking the /show/system/properties endpoint
#   and requesting the database's version number
curl --location --request POST \
     'https://<db.host>:8082/gpudb-0/show/system/properties' \
     --oauth2-bearer "<token>" \
     --data '{"options": {"properties": "version.gpudb_core_version"}}' \
     --header 'cache-control: no-cache' \
     --header 'content-type: application/json'

Compatibility Matrix

The following chart shows the version compatibilities between the various APIs and a target database server. While only the major & minor version numbers (6.2, 7.0, 7.1, 7.2) must match to achieve interoperability, the complete feature set for a given database version can only be utilized via the corresponding API version, depicted below.

Database	C++	C#	Java	Javascript	Node.js	Python
6.2	6.2.*	6.2.*	6.2.*	6.2.*	6.2.*	6.2.*
7.0.X	7.0.X	7.0.X	7.0.X	7.0.X	7.0.X	7.0.X
7.1.X	7.1.X	7.1.X	7.1.X	7.1.X	7.1.X	7.1.X
7.2.X	7.2.X	7.2.X	7.2.X	7.2.X	7.2.X	7.2.X

Dynamic Schemas

When working with APIs, it is helpful to have an understanding of how data is returned by the database. For a detailed breakdown in Java & Python, see Dynamic Schemas.

​Native

​Connecting via API

​HTTP Connections

​HTTPS Connections with Certificate Validation

​HTTPS Connections without Certificate Validation

​HTTPS Connections with OIDC/OAuth Authentication

​Compatibility Matrix

​Dynamic Schemas

Native

Connecting via API

HTTP Connections

HTTPS Connections with Certificate Validation

HTTPS Connections without Certificate Validation

HTTPS Connections with OIDC/OAuth Authentication

Compatibility Matrix

Dynamic Schemas