Latest News

the latest news from our team

Using Impromptu with ODBC

Getting Started

    1. Create a New Catalog, enter a file name and select Databases:

ODBC_j01

    1. Select Add:

ODBC_j02

    1. Enter a name for the database, select ODBC Gateway, find and select the ODBC data source you created earlier,deselect User ID, and click OK:

cognos3

    1. The Database Name should now be correct. Click OK:

ODBC_j04

    1. Select and add a table, then click OK:

ODBC_j06

    1.  Select Cancel from the Joins dialog box:

ODBC_j07

    1. Select New on the Toolbar to start the Report Wizard and click Next:

ODBC_j08

    1.  Double click the table name, select and add the fields, click Finish:

ODBC_j09

    1.  Data from the dataset will appear:

ODBC_j10

Leave a Reply

Your email address will not be published. Required fields are marked *