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 2: / Line 2: @@
 <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.
+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.
-This chapter describes how to exchange data between Analytica and other applications by using the standard Copy and Paste commands, using OLE linking, reading and writing data in Excel worksheets, and using the Import and Export commands.
 == Sections ==
-* [[Using the Standard Copy and Paste Commands]]
+* [[Copy and Paste between applications]]
-* [[Using OLE linking]]
+* [[Read and write text files]]
-* [[Reading and Writing Data in Excel worksheets]]
+* [[Parsing and formatting data]]
-* [[Using the Import and Export Commands]]
+* [[Excel spreadsheets read and write]]
+* [[Read data from URL on internet]]
-These methods are explained in full detail on the next few pages.<br />
+* [[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>