Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Step 1. Specify Columns for the Search Index

Step 1. Specify Columns for the Search Index

In Enterprise Data Manager, specify columns that you want to include in the search index. Optionally, specify the columns for the record header in the search results.
  1. Click
    Accelerators
    Enterprise Data Manager
    .
    The Enterprise Data Manager interface appears.
  2. Select an application version and a table.
  3. Click
    View
    Constraints
    .
  4. Click the
    Columns
    tab.
    A list of all the columns in the table appears.
  5. Enable the
    Index for Search
    field for each column you want to add to the search index.
  6. Click the
    Constraints
    tab.
  7. Click the add icon to add a constraint.
    A row appears with the name
    NEW CONSTRAINT
    .
  8. Double-click the
    Name
    field and enter a name.
  9. Optionally, to specify a column name as the record heading on the results page, click the
    Type
    field and select
    Search Header
    .
    If you do not specify a column for the record heading, Data Archive uses the column name of the primary key. In the absence of a primary key, Data Archive uses the row ID for the record heading.
  10. Enable the
    Enabled
    field.
  11. Click the add icon in between the Child Table Columns and Parent Table Columns panels of the Constraints tab.
    A row appears in the Child Table Columns section.
  12. Click the
    Type
    field and select
    Column
    .
  13. Click the
    Name
    field and select a column.
  14. Click
    File
    Save
    .

0 COMMENTS

We’d like to hear from you!