Analytica User FAQs/Application Integration

How can I import data from Excel into Analytica?

Use either Copy/Paste (to copy the data once), or OLE linking for a hot link that will propagate any changes from Excel to Analytica. Set up a 2-D table in Analytica having the same number of cells as your Excel source, then Copy/Paste or Copy/Paste link.

From Analytica Enterprise, you can use the Functions To Read Excel Worksheets. These allow you to read particular cells or ranges of cells in particular worksheets using special functions. The webinar Functions for Reading Directly from an Excel File covers this topic.

It is also possible to read from spreadsheets using ODBC and SQL queries with the DbQuery function. The webinar Querying an ODBC relational database goes over this briefly.

How do I access data in an external Database?

Use DbQuery and related functions in Chapter 21 of the Analytica User Guide. You'll need Analytica Enterprise.

To query data from an OLAP server, such as Analysis Services, you'll need Analytica 4.0 Enterprise and will use the MdxQuery function.

How can I call an external application from my model

• Use OLE linking for external applications that support it, such as Microsoft Office.

• Use the built-in function RunConsoleProcess from your model. It provides a general facility to call an external application, pass it data directly or via a file. You can let the external process run in parallel or have Analytica wait for it to return and get results via a file.

• ADE provides an API for COM and .NET. Analytica does not currently provide a direct COM, .NET or Java object interface.