Difference between revisions of "Integration with data and applications"
m (Rewrite intro para and reorder the sections roughly from simplest or most common to more esoteric.) |
(Added page for Parsing and formatting data) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 7: | Line 7: | ||
* [[Copy and Paste between applications]] | * [[Copy and Paste between applications]] | ||
* [[Read and write text files]] | * [[Read and write text files]] | ||
| + | * [[Parsing and formatting data]] | ||
* [[Excel spreadsheets read and write]] | * [[Excel spreadsheets read and write]] | ||
* [[Read data from URL on internet]] | * [[Read data from URL on internet]] | ||
* [[Import and Export data]] | * [[Import and Export data]] | ||
* [[OLE linking]] | * [[OLE linking]] | ||
| − | |||
* [[Database access]] | * [[Database access]] | ||
* [[Database functions]] | * [[Database functions]] | ||
| + | * [[MdxQuery|Accessing a multidimensional or OLAP database with MDX]] | ||
| + | * [[COM Automation Objects]] | ||
* [[RunConsoleProcess - call other applications]] | * [[RunConsoleProcess - call other applications]] | ||
* [[Model file formats]] | * [[Model file formats]] | ||
| − | |||
==See Also== | ==See Also== | ||
<footer>Dynamic Simulation / {{PAGENAME}} / Working with Large Models</footer> | <footer>Dynamic Simulation / {{PAGENAME}} / Working with Large Models</footer> | ||
Latest revision as of 15:30, 8 August 2017
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
See Also
Comments
Enable comment auto-refresher