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 |