Subscribe Bookmark RSS Feed
stan_koprowski

Community Manager

Joined:

Aug 8, 2012

OLE Database Tools Addin

This addin will connect to an OLEDB and convert it to a SQLite database so that it can be used with Query Builder.  The addin uses a combination of JMP Scripting Language and a Python script to do most of the work.

The addin executes a Python script (thanks for the help on writing the Python script from bryan.boone) that in turn creates a snapshot of the OLEDB and saves it out as a SQLite DB.  The SQLite DB can then be directly accessed from QB as shown.  External programs such as Python can be executed by using the JMP scripting language or JSL.  JSL has a function called Run Program.

Options for submitting a custom query or limiting the number of rows are available from the menu.

The addin was used to access Proficy Historian and Microsoft Access OLE databases.  See my blog post for additional details for connecting to a Proficy Historian database.

Comments
BrianGSC

Hi Stan.

You write: 'See my for additional details for connecting to a Proficy Historian database.'

Do you have some aditional setup documentation?

Do I need to install a SQLite DB?

Should I configure it in a special way?

Should I setup the ODBC connection?

And how do I add other collectors to the selection box (you use VML21424D)?

Regards Brian

Hi Brian,

Have a look at my blog. This will have the additional details that you asked about. 

Also, there is help documentation included with the add-in.

best,

Stan

BrianGSC

Thanks.

I use the linked server solution.

It works.

Can you add the link to your 'my blog' in the article above, please.

Regards Brian