nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

23702_en-US

liliconcom

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. 11582_Screenshot 2016-05-17 22.34.52.png

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.

11584_Screenshot 2016-05-17 23.01.03.png

11583_Screenshot 2016-05-17 22.14.16.png

3rd Party Integration

Exploratory Data Analysis

Utilities

Re: OLE Database Tools Addin

@Santanu,

I use instances of the PI ODBC Driver (one DSN for each PI Archive Server and one for each PI AF Server) to connect to PI SQL DAS which then connects to to the PI OLE DB Provider (for the PI Data Archives) or to PI OLEDB Enterprise (for the PI AF Servers). Then, PI values are called using JSL similar to the example below. An Add-In is used to to generate this code, check it out here: Aveva/OSISoft PI Tools

Re: OLE Database Tools Addin

Hello

How do we connect OSIsoft PI DB to JMP using PIOLEDB?

Re: OLE Database Tools Addin

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

Re: OLE Database Tools Addin

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

Re: OLE Database Tools Addin

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

Comments

Quick Links