Intellicus Enterprise Reporting and Business Insights 19.1

Big Data

0 views June 28, 2020 0

This page describes the provider specific properties and the details you need to input to create connections to the specific databases. There are some properties that are common to these databases, you can find those information, here.

ASTERDATA

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

CASSANDRA

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

ELASTICSEARCH

Property Values Comments
Server Type Yourself The IP or name of the machine where Elasticsearch server is running
Port Type Yourself The port at which Elasticsearch server is listening
Index Type Yourself An index is a collection of documents that have some similar characteristics

GREENPLUM

Property Values Comments
Server Type Yourself The IP or name of the machine where database server is running
Port Type Yourself The port at which database server is listening
SID Type Yourself 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 <Intellicus_Install>ReportEnginelibHADOOP_COMMONversion-specific folder. You should modify run.sh file to point to your Hadoop version. Restart the Intellicus Report Server before creating the connection.

Property Values Comments
Driver Version Select from the list Version of Hadoop Cluster
Job Tracker Server Type Yourself IP address of Job Tracker Server
Job Tracker Port Type Yourself Port of Job Tracker Server
HDFS Server Type Yourself IP address of HDFS named node
HDFS Port Type Yourself Named node Port
Location Type Yourself Default path for the connection on this HDFS
Group Type Yourself User group on HDFS

 

Temp Path

(Optional)

Type Yourself Path to keep the temporary files on HDFS
Extra Arguments

(Optional)

Type Yourself 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 <Intellicus_Install>ReportEnginelibHbaseversion-specific folder. Modify run.sh file to point to your Hbase version and restart the Intellicus Report Server before creating the connection.

Property Values Comments
Zookeeper Server Type Yourself IP address of Zookeeper Server
Zookeeper Port Type Yourself Port of Zookeeper Server

HIVE

You need to download the driver and place it in <Intellicus_Install>ReportEnginelibHIVE folder.

Select Hive if your data is stored on hadoop.

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

IMPALA

You need to download the driver and place it in <Intellicus_Install>ReportEnginelibIMPALA folder.

Property Values Comments
Driver Version Select from the list Version of IMPALA
Host Type Yourself The IP or name of the machine where database is installed
Port Type Yourself The port at which database server listens
Database Type Yourself The name of the database to connect to

MONGODB

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

PRESTO

Property Values Comments
Server Type Yourself The IP or name of the machine where database server is running
Port Type Yourself The port at which database server is listening
Catalog Type Yourself The name of the data source to connect to using this connection
Schema Type Yourself The schema to be used for a specified user for this database connection
SSL Check/Uncheck 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 Type Yourself Specify connection string to connect to database

TERADATA

You need to download driver and place it at ReportEnginelibTERADATA.

Property Values Comments
Driver Version Select from the list Version of TERADATA
Host Type Yourself The IP or name of the machine where database is installed
Database Type Yourself The name of the database to connect to

VERTICA

You need to download driver and place it in ReportEnginelibVERTICA folder.

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