Connectivity and Integration
Some data connectors require additional third-party software installation to be enabled which typically requires adding JAR files to the Lib folder of the Tomcat installation and then restarting Tomcat.
Common additions include:
q JDBC Drivers
q Advanced Message Processing System (AMPS)
The latest version for AMPS can be downloaded from the 60East Technologies official website: http://www.crankuptheamps.com/amps/
Copy amps_client.jar, amps_client-javadoc.jar and amps_client-sources.jar into the Tomcat Lib folder.
The pre-compiled JAR files are located in the api\client\java\dist\lib\ directory, which contains the JAR files mentioned above.
All of the above-mentioned java dependency files can be found after downloading and installing the AMPS Java Evolution Kit.
If a user has Linux machine available, install the AMPS distribution. Otherwise, download the AMPS Evolution Virtual Machine.
To effectively use the .jar files, unblock these files by right-clicking on the File and selecting Properties. On the General tab, click Unblock.
q Elasticsearch connectors
Dependencies for each supported Elasticsearch version are included in Panopticon Real Time installation:
Select the target Elasticsearch version and unzip the contents of the appropriate dependency zip into the Tomcat lib folder.
Use the following java options to enable JMX monitoring for the JMX plugin:
Enable JMX remote connection: (-Dcom.sun.management.jmxremote)
Disable JMX authentication: (-Dcom.sun.management.jmxremote.authenticate=false)
Set remote port for jmx: (-Dcom.sun.management.jmxremote.port=number)
Providing invalid parameters into JMX connection string may cause a number of exceptions and make the server inaccessible. Make sure you are using the syntax provided above.
q OneMarketData OneTick / OneTick CEP
This connector requires that the following JAR be added:
Which is retrieved from the OneTick bin folder:
Additionally, the following environment variables MUST be configured:
To include the OneTick bin folder.
To reference the OneTick configuration file.
Plus, the Tomcat configuration should include the following Java option:
The OneTick configuration file should have entries for Windows OS time zone mapping and information.
Additionally, the OneTick client folder should be set to have the same permissions as those running the Tomcat process. Please check that the OneTick Java API is operational, before accessing workbooks through the server that utilize OneTick connectivity. This can be easily achieved by running one of the OneTick Java API examples.
· The OneTick JAR must be updated to match the version of the OneTick client installation.
· For version 16.7.0, the OneTick connector is built and tested against version 1.17 of the OneTick Client.
q SAP Sybase ESP
Manually copy the following dependency files from the Sybase ESP installation folder (e.g., C:\Sybase\ESP-5_1\libj):
Make sure the dependency files are copied to the appropriate WEB-INF folder in Apache Tomcat:
· For 64-bit: C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\panopticon\WEB-INF\lib
· For 32-bit: C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\panopticon\WEB-INF\lib
q StreamBase CEP
This connector requires the following JAR to be added:
Which is retrieved from the Streambase Lib folder.
For example: C:\TIBCO\sb-cep\7.5\lib
q Streambase LiveView
This connector requires the following JAR files to be added:
· sbclient.jar, lv-client.jar, lv-client-wwwdeps.jar
Which are retrieved from the Streambase Lib folder.
For example: C:\TIBCO\sb-cep\7.5\lib
Plus, the JAR files from the from the LiveView installation:
· lv-compiler.jar, jyaml-1.3.jar
Which are retrieved from the LiveView Lib folder.
For example: C:\TIBCO\sb-cep\7.5\liveview\lib