Actuate Spreed Sheet - Connect and Configure Database

As i mentioned in the earlier post and open .vts file.

Step 1:

Click "Data Manager" in Data menu

Step 2:

You can use below connectivity to connect respective destination

- ODBC connection
- JDBC Connection
- File/URL Connection
- SAP Connection
- XML Connection
- Actuate data integration service connection

Step 3:

I have used ODBC connection to connect database for my report.

Note: There is a challenge, some time TNSnames.ora file configuration will not work here. better to create new connectivity datasource by using ODBC connection in control panel.
Also note: windows 7 - we need to use odbc bat file to create new datasource

happy coding
Bala