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.)
Line 2: Line 2:
 
<breadcrumbs> Analytica User Guide > {{PAGENAME}}</breadcrumbs><br />
 
<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 ==
 
== Sections ==
 +
* [[Copy and Paste between applications]]
 
* [[Read and write text files]]
 
* [[Read and write text files]]
 +
* [[Excel spreadsheets read and write]]
 
* [[Read data from URL on internet]]
 
* [[Read data from URL on internet]]
−
* [[Copy and Paste between applications]]
 
 
* [[Import and Export data]]
 
* [[Import and Export data]]
−
* [[Model file formats]]
 
 
* [[OLE linking]]
 
* [[OLE linking]]
 +
* [[COM Automation Objects]]
 
* [[Database access]]
 
* [[Database access]]
 
* [[Database functions]]
 
* [[Database functions]]
−
* [[Excel spreadsheets read and write]]
 
 
* [[RunConsoleProcess - call other applications]]
 
* [[RunConsoleProcess - call other applications]]
−
* [[COM Automation Objects]]
+
* [[Model file formats]]
−
 
 
  
−
These methods are explained in full detail on the next few pages.
 
  
 
==See Also==
 
==See Also==
 
<footer>Dynamic Simulation / {{PAGENAME}} / Working with Large Models</footer>
 
<footer>Dynamic Simulation / {{PAGENAME}} / Working with Large Models</footer>

Revision as of 17:39, 25 April 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.

Sections


See Also

Dynamic SimulationIntegration with data and applicationsWorking with Large Models
Comments


You are not allowed to post comments.