Firebird JDBC example and SQL to build dashboard

Here are the detailed steps to get connected with Firebird using JDBC and build dashboard with InfoCaptor. Assumptions Make sure Firebird is installed Make sure Firebird server is running Setup SYSDBA user and password (the default password is masterkey) 1. Download Firebird JDBC driver. For this tutorial we have used the 64bit drivers for windows … Read more

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

SQL Server : Windows authentication with Tomcat

By default SQL server 2008 is not enabled for remote connection First you need to enable SQL server for remote connection to avoid the “SQL server connection refused: connect” error. Assuming your SQLserver is enabled for windows authentication and remote connection we can proceed as below. 1. Install Tomcat as service under the desired login … Read more