How-to

InfoCaptor now officially works and certified with Cloudera’s Hadoop distribution and specifically with Hive and Impala. Earlier InfoCaptor supported only JDBC protocol but now along with CDH integration, it has introduced ODBC protocol to take advantage of efficient drivers from Cloudera (Cloudera – Simba drivers) and provide more platform connectivity options. The integration has been … Read more

Let us examine a case of how a simple chart with few colors can give instant insight into the underlying data. Here is the plain old table of data from City of Chicago Let us see how we can analyze it in different ways. This simple line chart shows the growth of Library WiFi usage … Read more

In this quick tutorial we will see how to apply custom color /colour combinations based on the value or the label names of a bar chart. The same concept can be used for other chart say Pie chart etc Below you will find two cases of custom color coding. 1. How to color code bar … Read more

It is possible to pass URL parameters to any SQL widget within the Dashboard. This is useful for drilling from one dashboard widget to a different dashboard. This is also useful when you are drilling from a portal or third party application into InfoCaptor Dashboard. NOTE: when you drill from external application, the dashboard needs … Read more

Logos and images are nice to display on dashboards. They create special branding of your dashboard pages. InfoCaptor dashboard pages are just like any other web html page where you can add any types of image content. There are two ways to add image or logos on your dashboard. Add image using direct URL Drage … Read more

Let say you have the following three widgets on the dashboard Typically each widget can use its own individual SQL query to populate the widgets. Users widget: select count(*) from xuser Projects widget: select count(*) from xcategory Dashboards widget: select count(*) from xobject Now in the above example the SQL is pretty simple and it … Read more

With the latest release of InfoCaptor Enterprise Dashboards, you can now easily build visualizations using vector maps. Without the maps, you would usually view the countries or states within the country either on a bar chart or line chart. But now you can plot them on the geographic map with simple drag and drop. A … Read more

1. Add any box container or the icon that will display the date 2. Next right click and select ‘Data source’ In the connection drop down, select ‘Personal Cloud’ and in the SQL enter the following SQL select ‘dummy’ as Today 3. In the javascript window add this following code //get today’s … Read more

How to perform calculations across different data sources/databases Imagine, you have a CRM database that contains all your customer and sales information and you have a different database that stores your GL and ERP data. Now add some complexity to it, your CRM database is say SQL Server or Microsoft Access or just Plain old … Read more

In the new release of InfoCaptor Enterprise, we added some very useful features. 1. Ability to connect to Postgres SQL 2. Ability to connect to Pervasive database 3. Test Database connections before adding them to the system. Infocaptor works will all types of JDBC and ODBC connections. So if you need to connect to DB2 … Read more