InfoAsset Exchange is an add-on product to InfoAsset Manager to allow automated exchange of data between an InfoAsset on-premise database and other third party databases and file formats. The aim is to allow InfoAsset Manager to integrate well with other IT systems within an organisation.
The functionality provided by InfoAsset Exchange is the same as that provided by existing import and export functionality within the normal InfoAsset Manager application. The key difference is that InfoAsset Exchange will allow the data transfer without using the graphical user interface (GUI) of InfoAsset Manager.
The InfoAsset Manager functionality supported by InfoAsset Exchange is as follows:
- Import via Open Data Import Centre
- Export via Open Data Export Centre
- Import/Update from CSV Files
- Export to CSV Files
The table below details the data formats supported and the options available for each:
|
External Data Format |
Import |
Export |
Export Update |
Import Update |
Oracle Client Required |
ArcGIS 9.3.1 or later Required |
SQL Server Client Required |
|---|---|---|---|---|---|---|---|
|
Oracle Database |
|
|
|
|
|
|
|
|
Oracle Spatial Database |
|
|
|
|
|
|
|
| SQL Server Database |
|
|
|
|
|
||
|
Personal Geodatabase |
|
|
|
|
|
|
|
|
File Geodatabase |
|
|
|
|
|
||
|
SDE Geodatabase |
|
|
|
|
|
|
|
|
JET Database |
|
|
|
|
|
|
|
|
Raw Shape Files |
|
|
|
|
|
|
|
|
MapInfo TAB Files |
|
|
|
|
|||
|
MapInfo MIF Files |
|
||||||
|
XML Files |
|
|
|
|
|
|
|
|
CSV Files |
|
|
|
|
|
|
*Oracle Database requires an Oracle Client, recommended 9.2 or higher
**Oracle Spatial requires an Oracle Client, 9.2 or higher and connection to an Oracle Server with Spatial installed
Using InfoAsset Exchange
InfoAsset Exchange is accessed via an Application Programming Interface (API). The API is a set of classes and functions that can be used in a Ruby Script to control actions and data in InfoAsset Manager. The classes and functions map closely to the way that the normal software works but they can be run by a single command to perform multiple operations without the need for the InfoAsset Manager GUI.
Ruby is a general purpose scripting language, which is freely available and well documented. See http://www2.ruby-lang.org/en/ for detailed information.
(It is not necessary to install Ruby as all the required files and settings are available with an installation of the main InfoAsset Manager application.)
Note: The version of Ruby supported in this version of InfoAsset Manager is ruby 2.4.0.
Running Exchange Scripts
InfoAsset Exchange can be run from the command line, or a batch file. The filename of a Ruby script is passed as an argument and the script will be run and have access to the Scripting API's classes and functions.
iexchange.exe <script name> /<incarnation> <optional additional parameters>
Where:
- iexchange.exe is run from the InfoAsset Manager installation directory
- incarnation is always IN for InfoAsset Manager
e.g.
"C:\Program Files\Innovyze Workgroup Client 9.5\iexchange.exe" c:\myrubyscripts\innetwork.rb /IN
OR
"C:\Program Files\Innovyze Workgroup Client 9.5\iexchange.exe" c:\myrubyscripts\innetwork.rb /IN oracle_username oracle_password
See the Exchange Script Examples section for details of script format.