Difference between revisions of "Integration with data and applications"
(Added page for Parsing and formatting data)
 
(7 intermediate revisions by 3 users not shown)
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]]
 +
* [[Parsing and formatting data]]
 +
* [[Excel spreadsheets read and write]]
 
* [[Read data from URL on internet]]
 
* [[Read data from URL on internet]]
−
* [[Using the Standard Copy and Paste Commands]]
+
* [[Import and Export data]]
 +
* [[OLE linking]]
 
* [[Database access]]
 
* [[Database access]]
 
* [[Database functions]]
 
* [[Database functions]]
−
* [[Read from and write to Excel spreadsheets]]
+
* [[MdxQuery|Accessing a multidimensional or OLAP database with MDX]]
−
* [[Import and Export data]]
+
* [[COM Automation Objects]]
 +
* [[RunConsoleProcess - call other applications]]
 
* [[Model file formats]]
 
* [[Model file formats]]
−
* [[OLE linking]]
 
−
* [[RunConsoleProcess - call other applications]]
 
−
* [[COM Automation Objects]]
 
−
 
−
 
−
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>

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.

Sections

See Also

Dynamic SimulationIntegration with data and applicationsWorking with Large Models
Comments


You are not allowed to post comments.