tags:

views:

294

answers:

1
Q: 

How to query data from an AspenTech IP21 Historian?

Old subject, combined with new tools: What would be the best/appropriate way to query data for a web application from an AspenTech IP21 (InfoPlus.21) data historian?

In the past, I've used some pretty awful queries via the Aspen SqlPlus ODBC driver, but that doesn't seem like the right approach, as it doesn't seem to install on Win 7 at all.

Anyone here have experience with that?

A: 

Hi Jim, I was wondering if you had any luck. I am currently trying to query data from an Aspen SqlPlus server from excel using vba and although i can get the data it takes forever to run a simple query.

Noah  2010-01-30 19:51:09
Nothing I've ever seen that queries via the ODBC connector to IP21 has ever been fast! I think that's the price of making a historian look like a relational database to outside code.Since 2002, I've used various queries via the old Microsoft ODBC driver for .Net, later the System.Data.ODBC provider. All of the queries have been built up in code and sent that way. Since I had to do joins on the Timestamp field, it was just painfully slow.I was mainly throwing the question out there as I'd come across some old code, and wanted to know if anyone had a better approach to the solution.
reallyJim  2010-02-01 02:43:34

related questions

C++ SQLBindParameter
What Oracle driver should I install in my MS SQL server to be able to use DTS to copy data from the Oracle server to the MS SQL server?
Tool: ETL from an ODBC to SQL 05?
What is the simplest, most maintainable way to create a SQL Server ODBC Data Source?
How do I create a Jet ODBC link to a SQL Server view with periods in the field names?
Microsoft.ApplicationBlocks.Data.ODBCHelper ?
What are the access restrictions on accessing a DSN
.NET ODBC Connection Pooling
ODBC Connection Pool
what is the difference between OLE DB and ODBC data sources?
Reading a COBOL DAT file
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
How to programmatically configure an ODBC Datasource using C#
Best way to debug an ODBC driver on Windows
What is a Privileged instruction?
Control which columns become primary keys with Microsoft Access ODBC link to Oracle
How do you deal with NULL values in columns of type boolean in MS Access?
Using Rails 2.x with MS SQL Server 2005
C# ODBC Dialog
How do I get ms-access to connect to ms-sql as a different user?
How can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
Using MySQL on Visual Studio 2008
Using MS Access & ODBC to connect to a remote PostgreSQL
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Connect PHP to an AS/400