InfoCaptor does Big Data with Cloudera Impala and Hive

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

How to pass GET parameter values to Dashboard SQL – Drill down from external app

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

How to improve dashboard refresh performance

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

Add subtract data from two different database sources : Howto

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

Dashboard connection to Postgres SQL, Pervasive, DB2 and 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