System Architect provides an OLE DB provider, that provides a virtual flattened set of System Architect tables that the user will instantly recognize as they closely resemble the metamodel in System Architect. With the OLE DB provider, you can use third-party tools such as Crystal Reports or Excel to access the repository information and/or run SQL queries against it.
The steps to use the interface vary depending upon the third-party tool you use to access the System Architect repository via its OLE DB provider. The following steps can be followed to output System Architect repository information to Excel:
Open System Architect and the encyclopedia that contains the information you want to access.
1 Open Microsoft Excel (or other suitable product), and then create a new worksheet.
2 Select Data, Import External Data, Import Data.
3 In the Select Data Source dialog, click New Source.
4 In the Data Connection Wizard, select Other/Advanced in the What kind of data source would you like to connect to? field, and then click Next.
5 In the Data Link Properties dialog, click System Architect Provider for OLE DB, and click Next.
6 In the final dialog of the Connection Wizard, you may name the .odc data source you are creating, or leave the default name, and provide a description. Click Finish.
7 Select the .odc data source and then click OK. You will be prompted with an Import Data dialog, to import the data into the existing Excel worksheet. Click OK to import the data.
