Chapter 1 Introduction

 

esProc connects to databases via ODBC or JDBC. But it also provides Search External Library functionality in case a database to be connected doesn’t support JDBC and ODBC connectivity.

 

A variety of external libraries - AlicloudCli, ElasticsearchCli, HiveCli, SparkCli, HbaseCli, RedisCli, DatastaxCli, Report5Cli, ExcelCli, HdfsFileCli, OlapCli, WebserviceCli, FtpCli, SapCli, MongodbCli, KafkaCli, InformixCli, ZipCli and YimmingCli - are embedded in the esProc installation package to give access to data stored in Alicloud, elasticsearch, Hive databases, Spark systems, HBase databases, Redis databases, Cassandra databases, Informix databases, report files, Excel files, HDFS file systems, multidimensional databases, web services, FTP file systems, SAP systems, Kafka platform, MongoDB databases, Zip files and YiMing AI Model service. There are two steps for using these external libraries.

1. Deploying external libraries. For this refer to Chapter 2 Deployment;

2. Connecting to external libraries. For this refer to Chapter 3 Connection.