Can I link Access to Cognis Impromptu?

[scott-atkinson]

Guys,

I have just been shown the delights of a Business Intelligence tool called Cognis Impromptu, a report building tool, reports are built up like tables, very similar to using SQL query builder in Excel.

Reports that I have built can be saved with a .IMR extension, so when they are opened the Impromtu tool refreshes them.

My question is threefold;

Can I link Access to these tables, so as to use them in a database?

If I can link them, when Access opens them, will they automatically refresh?

When I open the reports manually, they refresh, but I have to OK a security dialogue box, nothing really critical, just really a check box. If Access will refresh these reports when they are opened, how can I bypass the check dialogue box?

Hope you guys can help, as I feel that I have a potential to do some really good work by using Access in conjunction with Impromptu...

 

[Banana]

The first thing to find out would be whether this tool you have supports ODBC or OLE DB.

 

[scott-atkinson]

The first thing to find out would be whether this tool you have supports ODBC or OLE DB.

The tool supports ODBC.

 

[Banana]

Then you need to get ODBC Driver, which I presume you can download from the software maker's website and install it on your machine. Done that, you can then link table and select "ODBC databases", then select the ODBC driver from the list.

If you want the software to access Access's data, read their manual on setting up a ODBC connection.