
You have:
Connected to the database you want to extract content from
More information: Creating Database Connections
Opened the Dictionary perspective
Created a Dictionary DC to store the extracted content
Use this procedure to extract content from database tables. You can extract either the full database tables content or particular entries. To specify the content for extraction, you use SQL queries. The selected content is extracted in XML files, which are stored in the Content Files directory of a Dictionary development component (DC) in the SAP NetWeaver Developer Studio.
A content XML file contains the following elements:
|
Element |
Description |
|---|---|
|
selections |
The root element of the content XML file. |
|
table |
Contains the extracted data from a particular table. Used in: selections Contains: entry |
|
entry |
Contains the extracted data from a table entry (row). Used in: table Contains: field |
|
field |
Contains the extracted data from a particular table field (column) for the particular table entry. Used in: entry |
The extracted content is deployable within a Dictionary DC. If you want to do so, you have to build your Dictionary DC and deploy it on the target database. During the DC build, the SAP NetWeaver Developer Studio creates an additional Software Deployment Archive (SDA) to contain the XML files with the extracted content.
Extracting database content is useful when you want to copy or migrate data from one database to another. The respective table (or tables) definition must exist on the target database.
Extracting table entries of the type DATE , TIME and TIMESTAMP is not supported.