Integration with data and applications

Analytica User GuideIntegration with data and applications

There are many ways to get data into a model and to save results into another application or file, depending on the type and quantity of data. These range from simple Copy and Paste between applications, to reading and writing text files, Excel spreadsheets, and databases. You can also use OLE linking and COM automation between applications. You can Read data from URL on internet, or call another application from Analytica using RunConsoleProcess. See the sections below for details.

Sections

• Copy and Paste between applications
• Read and write text files
• Parsing and formatting data
• Excel spreadsheets read and write
• Read data from URL on internet
• Import and Export data
• OLE linking
• Database access
• Database functions
• Accessing a multidimensional or OLAP database with MDX
• COM Automation Objects
• RunConsoleProcess - call other applications
• Model file formats
• Using Python from Analytica

See Also

Dynamic SimulationIntegration with data and applicationsWorking with Large Models