Applies to: Kyvos Reporting

This page describes the provider-specific properties and the details you need to input to create connections to the specific databases. Some properties are common to these databases, you will find that information in the common properties section.

ASTERDATA

Property	Description
Host	The IP or name of the machine where the database is installed
Port	The port at which the database server listens
Database	The name of the database to connect to

CASSANDRA

Property	Description
Server	The IP or name of the machine where he database server is running
Port	The port at which the database server is listening
Keyspace	The keyspace is a container for your application data

ELASTICSEARCH

Property	Description
Driver Type	REST – this will help you to input queries in JSON format JDBC – this will help you to input queries in SQL format
PROTOCOL	HTTP HTTPS
Server	The IP or name of the machine where the Elasticsearch server is running
Port	The port at which the Elasticsearch server is listening
Index	An index is a collection of documents that have some similar characteristics

GREENPLUM

Property	Description
Server	The IP or name of the machine where database server is running
Port	The port at which database server is listening
SID	This is a unique name that identifies a specific database from number of databases on a server

HADOOP CLUSTER

Copy all libraries from Hadoop and Hadooplib folders and place them at <Kyvos Reporting_Install>\ReportEngine\lib\HADOOP_COMMON\ version-specific folder. You must modify run.sh file to point to your Hadoop version. Restart the Kyvos Reporting Report Server before creating the connection.

Property	Description
Driver Version	Version of Hadoop Cluster
Job Tracker Server	IP address of Job Tracker Server
Job Tracker Port	Port of Job Tracker Server
HDFS Server	IP address of HDFS named node
HDFS Port	Named node Port
Location	Default path for the connection on this HDFS
Group	User group on HDFS
Temp Path (Optional)	Path to keep the temporary files on HDFS
Extra Arguments (Optional)	Any extra set of arguments that are required while executing map reduce job on this connection

HBASE

Copy all libraries from HBase and Hbaselib folders and place them at <Kyvos Reporting_Install>\ReportEngine\lib\Hbase version-specific folder. Modify run.sh file to point to your Hbase version and restart the Kyvos Reporting Report Server before creating the connection.

Property	Description
Zookeeper Server	IP address of Zookeeper Server
Zookeeper Port	Port of Zookeeper Server

HIVE

You need to download the driver and place it in <Kyvos Reporting_Install>\ReportEngine\lib\HIVE folder.

Select Hive if your data is stored on Hadoop.

Property	Comments
Driver Version	Version of HIVE
Host	The IP or name of the machine where database is installed
Port	The port at which database server listens
Database	The name of the database to connect

IMPALA

You need to download the driver and place it in <Kyvos Reporting_Install>\ReportEngine\lib\IMPALA folder.

Property	Description
Driver Version	Version of IMPALA
Host	The IP or name of the machine where database is installed
Port	The port at which database server listens
Database	The name of the database to connect to

MONGODB

Property	Description
Server	The IP or name of the machine where database server is running
Port	The port at which database server is listening
Keyspace	The keyspace is a container for your application data

PRESTO

Property	Description
Server	The IP or name of the machine where database server is running
Port	The port at which database server is listening
Catalog	The name of the data source to connect to using this connection
Schema	The schema to be used for a specified user for this database connection
SSL	In case of forced encryption at the database server, you can check the SSL option to enable you to connect. Under SSL mode, yo can specify SSL Trust Source Username and Password
Connection String	Specify connection string to connect to database

TERADATA

You need to download driver and place it at <Kyvos Reporting Installation folder>\ReportEngine\lib\TERADATA.

Property	Description
Driver Version	Version of TERADATA
Host	The IP or name of the machine where database is installed
Database	The name of the database to connect to

VERTICA

You need to download driver and place it in <Kyvos Reporting installation folder>\ReportEngine\lib\VERTICA folder.

Property	Description
Host	The IP or name of the machine where database is installed
Port	The port at which database server is listening
Database	The name of the database to connect to using this connection
Schema (optional)	The schema to be used for a specified user for this database connection

HTTP Status 429 – Too Many Requests

Big Data Connection