You are here: Home / MDAccess

MDAccess

Download Buy Get a license

The quickest way to access third-party applications

Developers often need to process data coming from multiple applications – to transform it, to combine multiple sources for reporting, or to generate code. Accessing this data usually requires dealing with proprietary file formats, Microsoft COM API’s, or databases.  Understanding an application data model and finding the appropriate technology to access it can be a large time consuming task that has a major impact on your project development process and cost.

MDAccess provides model accessors to read and write data coming from a certain number of third party applications. MDAccess is built on top of EMF, the de-facto Eclipse standard technology to manipulate model artifacts. It can be used either inside an Eclipse environment or as a standalone Java application.

As a developer, by using MDAccess, you then just have to focus on what you intend to do with the application data, and no longer on how you retrieve it from the application. MDAccess provides standard Java classes and methods to handle application data in memory. Your Java program just need to use these classes to collect model information and to perform operations.

MDAccess for Excel

MDAccess for Excel enables manipulating data coming from Microsoft Excel and to generate new workbooks. Need to generate Excel reports from your application? Use MDAccess for Excel to easily create sheets and to populate cells, including formatting information. Need to inject CSV data into your application? Use MDAccess for Excel to import CSV files with a clean and simple Java API.

Connection

MDAccess for Excel reads and writes data from native Excel files ( *.xls and *.xlsx) and comma separated files (*.csv).

System requirements

System Requirements:

Compatible Software:

  • Microsoft Excel – all versions

NOTE: MDAccess for Excel does not require Microsoft Excel to be installed on the workstation, and thus has no specific requirement on any operating system. MDAccess for Excel operates at file level and does not interact directly with Microsoft Excel.

Limitations:

  • Excel charts are not supported

MDAccess for DOORS

MDAccess for DOORS enables reading IBM Rational DOORS database content (folders, modules, baselines, objects, links and attributes). It also enables creating new modules or updating existing ones.

Connection

MDAccess for DOORS reads on-demand data from the active DOORS application. Data is retrieved only on explicit request, either from navigation in the model editor or by invoking a Java API to collect element properties. This on-demand architecture guarantees a minimal performance footprint and memory consumption. MDAccess for DOORS uses DOORS Automation to read and write data. It requires the DOORS client to be running on the same workstation. Fine grained DXL scripts are generated and executed on the fly, to retrieve only the necessary information.

System requirements

The DOORS Client software must be installed on the user’s workstation. In order to use MDAccess for DOORS, the user must manually open and login to the DOORS Client.System Requirements:

  • Microsoft Windows
  • Java Runtime Environment 1.5 or newer
  • Eclipse EMF 2.4 or newer and Eclipse GEF
  • IBM Rational DOORS 8.1 and higher for reading data. Version 8.2 or higher for writing data.

NOTE: Running two instances of DOORS on a single machine, with two different user identities, may result in unexpected behavior. Connecting to DOORS through Citrix is not supported.
Limitations:

  • OLE objects are not handled by the accessor. In case an Object Text contains an OLE object, the accessor will read the image preview of this OLE object.

MDAccess for System Architect

MDAccess for System Architect enables reading IBM Rational System Architect database content (both definitions and diagram information). It also enables updating an existing encyclopedia.

Connection

MDAccess for System Architect uses System Architect Automation to read and write data. It requires System Architect to be running on the same workstation. This is the recommended and most intuitive connection mode.

MDAccess for System Architect is also able to read and write System Architect XML files. This allows a disconnected approach, which doesn’t require System Architect to be installed on the same desktop where the accessor is executed. XML files can be exported and imported from System Architect context menu.

System requirements

System Architect software must be installed on the user’s workstation. In order to use MDAccess for System Architect, the user must manually open System Architect.

System Requirements:

  • Microsoft Windows
  • Java Runtime Environment 1.5 or newer
  • Eclipse EMF 2.4 or newer and Eclipse GEF
  • IBM Rational System Architect 10.3 and higher.

MDAccess for Simulink

MDAccess for Simulink enables reading and writing MATLAB Simulink files.

Connection

MDAccess for Simulink reads and writes data from native Simulink files ( *.mdl).

System requirements

Compatible Software:

  • MATLAB Simulink R2007a and higher

System Requirements:

NOTE: MDAccess for Simulink does not require MATLAB Simulink to be installed on the workstation, and thus has no specific requirement on any operating system. MDAccess for Simulink operates at file level and does not interact directly with MATLAB Simulink.