Use the metadata loader to perform any of the following tasks:īackup metadata: The MDL is an important part of your disaster recovery strategy. For example, if you export a table DEPT and it contains a foreign key reference to the table EMP, you can choose to export EMP along with DEPT. You can export the objects referenced by a set of objects by selecting the Export All Dependencies option on the Metadata Export dialog. If you are exporting a subset of objects, make sure you export all referenced objects and import them as well. The module to which the dimension belongs This enables the MDL to maintain the tree relationships for those objects during metadata import.įor example, if you export a single dimension, the export file contains definitions for: If you export a subset of objects, the MDL exports definitions for each object that you have selected and the parent objects to which the subset belongs. You can export an entire project, collections, public objects, locations, or any subset of objects. The file mdlcatalog.xml contains internal information about the MDL XML file. The file sales.mdx contains the repository objects.
Multiledger import data zip#
When you unzip this MDL ZIP file, you obtain two files. For example, you export the repository metadata into a file called sales.mdl. The Metadata Export Utility enables you to specify a file name and a path for the exported MDL file. The catalog file is called mdlcatalog.xml and it contains internal information about the Metadata Loader XML file. It has the same name as the of the ZIP file, but with the extension. This file contains the objects extracted from the repository and formatted in XML. mdl extension and contains the following files:
The Metadata Export Utility extracts metadata objects from a repository and writes the information into a ZIP format file. This section contains the following topics: For more information about metadata change management, see Chapter 32, "Managing Metadata Changes". Use snapshots for metadata backup and version management. Snapshots enable you to capture definitions of metadata objects using Warehouse Builder scripts.
Multiledger import data plus#
You can also perform metadata change management by taking snapshots of your metadata using Warehouse Builder Design Center or OMB Plus scripting. The MDL enables you to copy or move metadata objects between repositories, even if those repositories reside on platforms with different operating systems. You can enter annotations for your MDL export file to keep track of the information contained in the file. You can then move exported files into a third-party version control tool such as Oracle Repository, ClearCase, or SourceSafe. You can import and export metadata for any type of object on the Project Explorer, Global Explorer, and Connection Explorer using the Metadata Loader (MDL) utility. Warehouse Builder provides several features that enable you to copy and move metadata for the purposes of backup, history management and version management.
Overview of Import and Export Using Metadata Loader
0 kommentar(er)
