Querying DataFinder mined data using SQL/ODBC

[SDonovan]

The company I work for is getting ready to implement PM reports and dashboards. We would like to know if DataFinder can be queried using SQL or an ODBC link for direct communication between DIAdem/DataFinder and EPM. This would also allow us to access test data for other applications used in our production process.

Is this possible, and if so how? - for now generalities are OK.

Message Edited by SDonovan on 06-01-2010 01:56 PM

[Otmar]

Hello SDonovan,

The only ways to query the NI DataFinder are:

• DIAdem (either through the NAVIGATOR interface or through a SCRIPT)
• LabVIEW DataFinder toolkit 

There is no direct link to the NI DataFinder via SQL or ODBC. It is possible to pass query results from either DIAdem or the LV DF toolkit to third party applications.

Feel free to contact me (call (888) 280-7645 and ask for me) if you have more specific questions. Maybe we can figure this out better if I have a better understanding of your application.

     Otmar

Message Edited by Otmar on 06-01-2010 02:08 PM

Message Edited by Otmar on 06-01-2010 02:08 PM

[SDonovan]

OoKay,

Is there a way to programmatically pass parameters to DIAdem or LV DF to do the samething? We have a webpage that uses PHP (old version) or ASP.NET (new version) to capture a serial number for the part being tested and I want to be able to pull up the test history (mined from the TDM XML) for that one part. We also want to use pass/fail rates to monitor tester health via an EPM Dashboard (Tripwires at 3 in a row for same step, any 5 in an hour, any 10 in 4 hours)

[H_SH]

If you are using ASP.NET .. then Measurement Studio can solve the working on TDMS through web pages.. It supports this file format and have TDM Streaming .NET Class Library  

othewise use ADO in VBS to fetch the data.. You can use ADO objects for all databases for which an OLE DB driver is available.

Hope it helps

HS

[Brad_Turpin]

Hi SDonovan,

Sure, both LabVIEW and DIAdem have ActiveX Servers you can communicate with from outside compilers.  Alternatively you could create a file with a list of commands in it and start either a LabVIEW program or the DIAdem application with a DOS command, with the intention to execute all the commands you'd put in the file.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[SDonovan]

H Sh,

One of our engineers had been told that DataFinder uses a varient of MySQL for internal data storage. We should be able to use ADO from ASP.NET (C#) to get to this data.

But...

We can see the mysqld processes in the task manager but we don't have a password to login to the MySQL database with.

If we do this we would want a user up that has SELECT permission only so that the data is not corrupted, but to do that we need administrative access to the MySQL Server.

Is there a way to add users to the MySQL database or a way of getting the root password?

Thank you for the help.

[Jim West]

There are obvious advantages to creating an SQL interface to the datafinder.

• First, there are millions of people who understand the syntax of SQL.
• The simplification of querying the datafinder versus appending clauses in Diadem VBS or chaining VIs in the toolkit. Format a string -> get a table.
• Even if you only implemented a subset of SQL, the resulting code needed would be much less than currently required.
• SQL has methods to do any type of query that you can imagine. Why reinvent the wheel?

Jim