Blog | Language | Customer Login | +1-925-218-6983
What is Visual KPI? | FREE 30-Day Trial | +1-925-218-6983 Subscribe via RSS Feed


Real-Time Dashboards & Alerts

Smartphones | Tablets | Web Browsers | PC & Mac | More

Visual KPI reads multiple data sources in real-time (big data, historians, databases, manual data, web services and more) and adds context with KPIs, groups/hierarchy, alerts, and geolocation. It gets your critical data in the hands of more users without extensive training and it can be deployed in days, not months. Want to see how we do it?

Mobile Operations Monitoring - Tour
Real-time KPIs on Browser, iPhone, iPad, Android, Windows Phone, tablet
Check out a 2-minute video and see the latest…
What is it?

Visual KPI is mobile dashboard software for any device. It reads existing data sources and delivers KPIs, scorecards, analytics and alerts in real-time.

Who uses it?

Decision makers. Operations. Remote workers. Data Junkies. Anyone who values knowing what's happening right now, regardless of their device.

Why use it?

Mobility is no longer optional. Visual KPI presents problems and opportunities before it's too late. Oh, and there's no six-month project that "might" pay off.

American Electric Power BP Wind Energy con edison operations Exelon Energy Genentech FMI - Freeport McMoRan Corning Pemex Tesoro


OSIsoft PI World Sponsor 

Support FAQ > Data Sources > What are the requirements for connecting to a SQL data source (Oracle, SQL, Postgres, etc.)?

Search the FAQ for entries containing:

I. All SQL-class interfaces (ODBC, OLEDB, MDX) share a common set of connection requirements:  

a. Remote machine NetBEUI name, IP address, or FQDN (preferred) where the target database resides. 
b. A login name for “read access” of the target database
c. Password for the login name
d. Either a working connection string or DSN which use the above information to establish a connection:
i. Connection string examples (more at 
1. Driver={SQL Server};Server=DBMachineName;Database=TargetDBName;Trusted_Connection=yes;
2. Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=M:ExcelFiles\Data.xlsx;
3. DSN=MyData;UID=Smith;PWD=Wesson;


II. The login name which Visual KPI uses to read data can be:
a. The default, low-privilege local account on the Visual KPI web server called “Network Service” (preferred).  This is preferred because with this method there is no need to create or manage a service account.
i. If the target database is on the local machine, this login is called “NT AUTHORITY\NETWORK SERVICE”
ii. If the target database is on a remote machine, this login is called “Domain\WeberverName$; where “DOMAIN” is to be replaced with the actual AD domain name.  “Webserver” is to be replaced with the NetBEUI name of the web server on which Visual KPI is installed.  Note the “$" symbol appended to the end of the login.
b. A named user on the remote database, managed by the database
c. A named Domain account on the remote database, managed by Windows but already defined on the remote database


III. Any login scenario requires only Read access rights on the target database
IV. Interface creation and testing: 
a.  A client tool must be installed and tested on the Visual KPI web server for the target database (e.g. SQL Server Management Studio; Toad for Oracle, HeidiSQL for MySQL, Etc.)
b. A tested client means a successful connection to the target database and successful execution of one or more queries of the target database (specifically the tables and/or views that you would like to read data from with Visual KPI).


Last updated on May 16, 2016 by Transpara

Free 30-Day Trial

Transpara LLC
4715 W. Culpepper Drive‎
Phoenix, AZ 85087

© 2005-2018 Transpara LLC. All rights reserved.
Privacy Policy | Terms of Use | Copyrights

© 2005-2018 Transpara LLC | Privacy Policy | Terms of Use | | +1-925-218-6983