category:Integration & Application

esProc Integration & Application: Integration by BIRT

esProc provides standard JDBC to integrate with BIRT and other reporting tools. Here we’ll explain the process of integration of esProc and BIRT in development environment and WEB application environment. 1. Integration in development environment 1.1  Create configuration files Create the two configuration files –...

2015-04-27 143 0 0

esProc Integration & Application: License and Encryption

1. File encryption esProc provides ways of encrypting cellset files to protect them from unauthorized access or use. There are two levels of encryption: Execution privilege:By this privilege, users can set parameters, execute the cellset and see the cell values; they can also view the cellset descriptions and cell tips...

2015-04-24 32 0 0

esProc Integration & Application: User-defined Functions

Besides the system-provided functions, esProc supports invoking user-defined functions to handle some special operations or the encapsulation of certain computations. This article will briefly explain how to invoke user-defined functions with invoke function and how to use parameters and return the results as needed. 1...

2015-02-27 33 0 0

esProc Integration & Application: Integration with JasperReport

esProc provides standard JDBC interface to be easily integrated with reporting tools. This article will explain the integration of esProc and JasperReport respectively in development environment and WEB server-side deployment. 1. Integration in development environment Access esProc JDBC to call the esProc script using ...

2015-01-15 121 0

esProc Integration & Application: Deploying JDBC

Java programs can call esProc via JDBC. It is necessary for programmers to know how to deploy the esProc JDBC and familiarize themselves with the detailed configuration information. 1. Basic steps The following instructions need to be followed to deploy the esProc JDBC: 1) Load necessary jars Load the jars needed by es...

2014-12-29 73 0 0

esProc Integration & Application: Command Line

The command line refers to using commands in the form of strings in DOS-like environment to execute programs. All operating systems support the command lines, like the Linux console and the Windows command line window. The file, esprocx.exe, is needed when the command line is used to execute an esProc cellset file. The...

2014-12-24 55 0 0

esProc Integration & Application: Java Invocation (II)

3. No result or multiple results It is allowed to return no result during calling a cellset file. Take the following cellset file – outputData1.dfx – as an example:   A 1 $(demo) select * from CITIES 2 =A1.select(Arg.pos(left(NAME,1))>0) 3 =file(“Cities.txt”) 4 >A3.export@t...

2014-12-18 34 0 0

esProc Integration & Application: Java Invocation(I)

esProc can be embedded in a Java application. Invoking an esProc cellset program is like  accessing a database via JDBC. During the invocation the cellset program is packaged as a stored procedure, so it is called in the same way as that the latter is called. 1. Basic usage esProc JDBC resembles a database JDBC dr...

2014-12-17 68 0 0