Detailed OSIntegration Overview

Read below for detailed usage of the Open Source Software and how we have integrated to build up what you all see as OSIntegration.

To ease reading the technical section has been devided into backend and frontend section.

Backend Application

Talend Open Source ETL platform

Talend Open Studio for Data Integration helps you get your data to the right place, in the right form, at the right time. The leading open source ETL solution for data warehousing and business intelligence.

This Software has been used to get daily data in form of Bhav copy from BSE (Bombay Stock Exchange) and NSE (National Stock Exchange) and load it to our ETL database.

Not only this robust software is used to load the data, we have used it for aggregation, filtering etc to deliver the data in very efficient and performance proven way to end user. The ETL (Extraction Transformation and Load) tool has been also used to set up other batch jobs to maintain the additional data processing.

The data on the website refreshes at around 18:00 hours IST everyday. OSIntegration uses windows scheduler to execute the ETL jobs on all working days.

Database MySQL

MySql is a powerful database. It's very good and free of charge. Many developers in the world selected mysql and php for developing their website.

The MySQL® database has become the world's most popular open source database because of its consistent fast performance, high reliability and ease of use. It's used in more than 6 million installations ranging from large corporations to specialized embedded applications on every continent in the world. (Yes, even Antarctica!)

Not only is MySQL the world's most popular open source database, it's also become the database of choice for a new generation of applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python.) MySQL runs on more than 20 platforms including Linux, Windows, OS/X, HP-UX, AIX, Netware, giving you the kind of flexibility that puts you in control.

Whether you're new to database technology or an experienced developer or DBA, MySQL offers a comprehensive range of certified software, support, training and consulting to make you successful.

Website uses MYSQL database to keep all data necessary for job processing and to keep the data generated as an output of ETL jobs.

MYSQL database also holds information of all the Users registered on the website and website statistics.

As a security feature OSIntegration maintains two different databases. One for entirely ETL processing and Other database to display data on website. Hence few tables from ETL database and thus give us a feature of backup data.

Frontend Application

i-report and JasperReports

iReport is a reporting tool, developed in Java that helps users and developers design reports visually. Through a rich and simple-to-use user interface, iReport provides the most important functions to create complex reports easily, thus saving a lot of time.

iReport uses the JasperReports library inherently to create reports. JasperReports is, in a sense, the core of iReport. JasperReports is the most popular open source reporting library for Java technology, and iReport is a visual report designer for JasperReports. JasperReports has hundreds of features, but it itself doesn't provide any tool to visually design reports. A person without much confidence with XML might not be able take full advantage of the JasperReports library. iReport works for such people as well as for the expert report developers.

iReport features

iReport can connect to any database and acquire data from different data sources. It can export the reports to PDF, XHTML, OpenOffice, MS Word, MS Excel, XML, Text, and many more. To understand what you can do with iReport, let's have an overview of the features.

iReport with OSIntegration

This feature is not directly evident on website as it is used for all together a different functionality of developing and publishing reports to OSIntegration functional heads and administrator and to few privileged user who requires report of all the companies on daily basis.

i-report is an opensource software to build professional reports based on the data in database. JasperReports is a utility software to publish i-report on web and gives functionality to schedule i-report at fixed time to users.

Generally as the data refreshes in our database at around 17:10 hours, the reports are on its way to users by 17:45 hours every working day.

Due to technical and bandwidth issues this feature has not been made public and is handled only at special request.

Joomla 2.5

Joomla (TM) is among the most popular Open Source content management systems that exist today, in the company of Drupal and WordPress. If you just need to build a web site for yourself and are unfamiliar with all this HTML stuff, or you develop web sites for other people, or if you’re at the pointy end of developing web-based applications, then Joomla really should be on your evaluation list. It’s easy to install, use, and extend.

Here it goes what you all see at our website OSIntegration!

OSIntegration uses Joomla 2.5 to build up entire website and we have used various Joomla extensions to build necessary effects and stylings of this website.

For our Technical readers we are listing all the plugins and their purpose below:


With This we thank all 3rd party extension providers. This explains how well and rich open source technology works as all are free to contribute their ideas and passion to a software built on Open Source platform application.

We have used Abyss Webserver to host our website from server at OSIntegration.

Scripting Language

OSIntegration has used html and PHP scripting.

Add comment

Security code