Data analysis in PostgreSQL for Openfire activity audit
Example of using PostgreSQL to analyze Openfire activity, captured via Kafka and Connect Sink
Read moreCategory: Uncategorized
Dockerizing the Modeshape REST and JCR App
Overview Modeshape is a Java Content Repostiory (JCR-283) implementation, which provides an open-source, hierarchical content management system. The goal of this exercise is to make a single Docker image which can be used in all environments. Any environment specific or volatile parameters should not be part of the image, but rather supplied as parameters (or a file) when running the image. This simplifies deployment and assures the run-time environment is identical. While these instructions are specific Modeshape, they can also
Read moreSpagoBI – Exporting and Importing Report Documents
Step-by-step instructions for Exporting a report document from one server and importing into others. Steps In the source SpagoBI Environment, go to Import/Export Then, select the documents you want to export. Name the export (20 character limit?) ex: 2015-12-30-scheduled-cand Then, press the export icon When the “Download” link appears, click it Now, You’ve now got a zip file (in downloads) containing the two reports and meta-data about them. Sign out of POC / DEV This file must have the exact
Read more
SpagoBI 5.2 REST DataSets with JSON Data
Introduction SpagoBI 5.2 introduces a new dataset type : RESTful web service datasets . This allows SpagoBI to report on data from sources other than databases with JDBC drivers. What follows is an end-to-end demonstration of creating and using a REST (JSON) Dataset in SpagoBI 5.2. External documentation Description URL SpagoBI 5.2 NGSI usage of REST Data Sets https://spagobi.readthedocs.io/en/latest/user/NGSI/README/index.html SpagoBI 5.2 Documentation https://spagobi.readthedocs.io/en/latest/index.html SpagoBI 5.2 Release Notes https://wiki.spagobi.org/xwiki/bin/view/spagobi_server/release_notes_5_2 JSON Path https://github.com/jayway/JsonPath Limitations in REST Data Sets The response of the REST service must
Read moreSpagoBI DataSet REST Webservice via Groovy
SpagoBI DataSet REST Webservice via Groovy UPDATE: THIS IS A GREAT IDEA, EXCEPT IT DOESN’T WORK IN THE FINAL STEP. Per SpagoBI Support, Groovy cannot be used in a script-based Dataset to provide rows of data. According to the last support ticket, there is no intent to make that work. Groovy Data Set to make RESTful web service call and return IP Address related information in SpagoBI’s XML format Prerequisites : Upgrade Groovy in SpagoBI and Drop in a copy of the WSLite library
Read more