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 …
Posted in How-to | Tagged dashboards, jdbc, service, single signon, sqlserver, sqlserver 2005, sqlserver 2008, sqlserver express, SSO, tomcat, windows authentication
Someone on Reddit posted a summary of counts of AMA by category. The counts are shown in this thread Let us see how quickly we can visualize this data? Step1 : We copy the data and paste into Excel Inside …
Posted in Charts, dashboards, How-to | Tagged dashboard, dashboards, pie chart, reddit, reddit ama
In this article we will expand on the "Bells and Whistles" section of our Dashboards. There are multiple ways to alert the user when your data crosses a certain threshold. The most used technique is to change the color of …
Posted in How-to, webdashboard-help | Tagged dashboard alerts, dashboard filters, dashboard notification, dashboards, email alerts, Excel Dashboard, exception alerts, executive dashboards, sound alerts, visual alerts
Previously we built this Human Resource dashboard using Excel as the data source. The same can be built by putting the data in Google Spreadsheet and then slightly changing the queries. Checkout the entire HR video series for the tutorial …
Posted in dashboards, Human Resource | Tagged beautiful dashboards, dashboard prompts, dashboards, executive dashboards, HR Dashboard, hr kpi, HR Manager dashboard, Human Resource Dashboard, kpi, pleasant dashboards, professional dashboards
In this tutorial, we will demonstrate some of the new and powerful features of InfoCaptor Enterprise. The new features include Dashboard prompts that let you set global filters on one or multiple widgets. It also demonstrates and teaches how to …
Posted in Excel, How-to, webdashboard-video | Tagged dashboard, dashboard filters, dashboard parameters, dashboard prompts, dashboards, drill down reports, Excel Dashboard, HR Dashboard, Human Resource Dashboard
Data comes from variety of sources. It could be your Excel files, Microsoft Access or real SQL databases like MySQL, Oracle, SQL Server, DB2 etc. These databases are used to store information from your ERP, MRP, CRM or Datawarehouses. The …
Posted in How-to | Tagged big data, dashboard, dashboards, database, web services
Earlier in May 2012 we released our cloud based Dashboard Solution at https://my.infocaptor.com As anticipated, lot of users requested if they could host the same software within their own network. We are extremely excited to announce the availability of self …
Posted in Announcement | Tagged big data, dashboard, dashboards, self hosting dashboards, social analytics
InfoCaptor Enterprise is now available for everybody to build and use dashboards in the cloud. There is no installation or setup required. Just create a login and start using. https://my.infocaptor.com Bottomless visualization options Connection adapters to SQL databases (direct connection, …
Posted in news | Tagged dashboard, dashboards, database, facebook, social analytics, twitter
When using Excel ODBC with PHP please use the following settings All settings are done in the connection_methods.php Windows 7 and Excel 2007 (support for .xls, .xlsx, .xlsm, .xlsb) $db_url="DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};FIL=Excel 12.0;DriverID=1046;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text"; Windows …
Posted in How-to | Tagged dashboards