Adding MSQL database to search area

[GertW]

We are currently looking if we can use DIAdem 10.0 (we're using the evaluation version to test it out) to make reports out of stored data. The data is stored in a MySQL database.

I have tried to add my database to the search area, but didn't succeed. Is it possible to add data from a MySQL database to search area and if so, how do i do this?

Thanks

[Brad_Turpin]

Hi Gert,

Can you define an ODBC Data Source Name (DSN) for your MySQL data base?  Or can you create an ADO connection string for your MySQL data base?  If you can, then you will be able to create a profile which will load the tree structure (Tables, Columns) of your MySQL data base into DIAdem's NAVIGATOR.  At this point you will have the ability to drag entire data base columns into new channels in the Data Portal.  This is nice but rarely useful.

If you want to run queries against your MySQL data base, you will need to run a VBScript that programmatically queries the data base.  I can send you many examples of this, including an end-user dialog that interactively builds and executes queries for you.

So, do you have a DSN or an ADO connection string?
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[GertW]

Thanks for the reply,

I have been able to get data out of my dbase.I used the command:
        Call SQL_Connect("qcdatabase", "","","")
in a VBScript to connect with my database. Now i'm able to get data out of the database using queries and bind that data to a channel using the command
       Call SQL_BindChannel("MyLNB1Vdc","LNB1_Vdc","n")

Examples of how i can work with this are always welcom because this is all new material for me.

[Twigeater]

Hello Gert! Hello Brad!

One important thing to know is that the DataFinder in DIAdem is only able to index/query file based data. The result out of this is that you have to query yourselve via ADO as Brad recommended or use the the SQL plugin wich is unfortunately not verry flexible and find&search features are little bit limited. The ADO aproach is possible if your meta and not the measurment data is in the DB.

Matthias

[Brad_Turpin]

Hi Gert,

If you're able to use the SQL_...() functions in DIAdem, then you have all options open to you.  I am including below my personal grab-bag of SQL applications.  It's an awful lot, but hopefully you can find what you want.  There are also several examples which ship with DIAdem that show the use of these functions.

Brad Turpin
DIAdem Product Support Engineer
National Instruments

[GertW]

Hello Brad,

thanks for all the data. The examples will be usefull


Gert Wittouck
Research & Development Engineer
Unitrongroup NV