Difference between revisions of "Integration with data and applications"

Latest revision as of 15:30, 8 August 2017

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.

@@ Line 1: / Line 1: @@
 [[Category: Analytica User Guide]]
 <breadcrumbs> Analytica User Guide > {{PAGENAME}}</breadcrumbs><br />
-OLE linking makes it possible to link data to and from external applications. With OLE linking, changes to inputs or results are automatically and instantaneously propagated between applications.<br />
-This chapter describes how to exchange data between Analytica and other applications using the following methods:
+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 [[Read and write text files|text files]], [[Excel spreadsheets read and write|Excel spreadsheets]], and  [[Database access|databases]]. You can also use [[OLE linking]] and [[COM Automation Objects|COM automation]] between applications. You can [[Read data from URL on internet]], or call another application from Analytica using  [[RunConsoleProcess - call other applications|RunConsoleProcess]]. See the sections below for details.
-# [[Using Copy and Paste]]
-# [[Using OLE linking]]
+== Sections ==
-# [[Reading and Writing Data in Excel worksheets]]
+* [[Copy and Paste between applications]]
-# [[Using Import and Export]]
+* [[Read and write text files]]
-<br />
+* [[Parsing and formatting data]]
-These methods are explained in full detail on the next few pages.<br />
+* [[Excel spreadsheets read and write]]
-<footer>Previous / {{PAGENAME}} / Next</footer>
+* [[Read data from URL on internet]]
+* [[Import and Export data]]
+* [[OLE linking]]
+* [[Database access]]
+* [[Database functions]]
+* [[MdxQuery|Accessing a multidimensional or OLAP database with MDX]]
+* [[COM Automation Objects]]
+* [[RunConsoleProcess - call other applications]]
+* [[Model file formats]]
+==See Also==
+<footer>Dynamic Simulation / {{PAGENAME}} / Working with Large Models</footer>