category:Heterogeneous Datasource

esProc Heterogeneous Datasources – MongoDB

It is convenient to establish and close a connection to MongoDB in esProc , as well as to call the database to query and count the data, perform distinct and aggregate operations. 1. Preparation for connecting to MongoDB The MongoDB Java driver (like mongo-java-driver-2.12.2.jar), which esProc does’nt provide, should b...

2015-09-18 38 0 0

esProc Heterogeneous Datasources – JSON and HTTP

JSON is a common data-interchange format. JSON data come from external Java programs, local files or the HTTP server. esProc can easily parse the JSON strings and compute them.  The following examples will show in detail how to write an esProc script for doing this.  The first case is the one in which the JSO...

2015-03-18 62 0 0

esProc Heterogeneous Datasource – Hadoop

esProc’s Hadoop datasource includes mainly HDFS files and Hive database. The way of accessing Hive database is similar to that of accessing other databases, so we won’t discuss it here. esProc has the built-in method of accessing HDFS files, which resembles that of accessing files from an ordinary file system. We’ll in...

2015-03-18 76 0 0

esProc Heterogeneous Datasources – Excel

esProc can import the data from and write them into Excel files by making the Excel one of its various datasources. Two simple examples will show how this works. First let’s look at the data importing. The target files are data.xlsx and data.xls (excel97-2000 format) and have the same content. sheet0 is named employee ...

2015-03-06 37 0 0