Difference between revisions of "Integration with data and applications"
m |
(Added page for Parsing and formatting data) |
||
| (One intermediate revision by the same user 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]] | * [[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]] | ||
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