Big Data Connection
- sunny.gupta
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 |
PROTOCOL | HTTP |
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 |
Related content
Copyright Kyvos, Inc. All rights reserved.