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
The all-new Visual KPI v5 is here! Click to learn More…
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

Support Alert: iOS 8/9 Issues with Authenticated Sites. Read More

Support Alert: iOS and Android dedicated apps no longer supported (web client only). Read More


Free 30-Day Mobile BI Trial

Free Guide - Mobile BI Guide eBook

 

 

 

 

Support FAQ > Data Sources > How can I connect an Oracle database to Visual KPI?

Search the FAQ for entries containing:

Visual KPI can connect to Oracle using ODBC, OLEDB or OLAP.  A great resource for setting up the connection and security can be found on the Oracle area of the ConnectionStrings website:

http://connectionstrings.com/oracle

Both Oracle and Microsoft provide 32- and 64-bit drivers for connecting to the database.  Visual KPI supports all known drivers from both.  Make sure to match your selected driver "bitness" to the operating system "bitness" because the Oracle drivers do not support "cross-architecture" calls from within IIS application pools.  While Visual KPI has always supported callling 32-bit drivers while running in native 64-bit mode, we depend on the driver author to support this type of down-level support, and with the Oracle drivers we often see "operation resulted in arithmetic overflow" when trying to cross the 32/64 bit boundary.  It is safer, easier and less time consuming to simply match the driver architecture to the server architecture.  Save yourself some headaches and find the right driver first!

Oracle databases must be treated carefully, since connecting to them successfully involves paying close attention to the client and server versions, connection types and security requirements.  

It is essential that you establish and test connectivity using SQL+ or another client running on the Visual KPI Server machine prior to creating the Visual KPI Interface to the database.   If errors are encountered, be sure to search the online Oracle User forums to see if it is a known issue with the release combination you are using.  A good place to start is the Oracle Windows and .NET forum:

https://forums.oracle.com/forums/category.jspa?categoryID=44

Once you have created a working connection outside of Visual KPI, you are ready to create an interface which uses this connection information.  Visual KPI supports both DSN-based interfaces and direct connections using your selected connection string.  Here is an example for a 64-bit OLEDB connection on a 64-bit Windows Server 2008 R2 without a DSN.  Take the defaults in any screen not shown below:

 

Modify the OLEDB Provider string to point to your Data Source name with your security credentials.  When the Query dialog boxes are shown, simply click next to create the interface without modifying the default Query examples for Current Value, Historical Value and Trend Value.  You can modify all of these later after verifying the interface connectivity. See the XXXX FAQ entry for tips on creating correctly parameterized Interface Queries for any data source.

 

Last updated on March 19, 2013 by Transpara

Free 30-Day Trial

Transpara LLC
4715 W. Culpepper Drive‎
Phoenix, AZ 85087
USA
+1-925-218-6983

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

© 2005-2016 Transpara LLC | Privacy Policy | Terms of Use | info@transpara.com | +1-925-218-6983