Show TOC

Creating a Connection Between Embedded Search and SAP HANA or TREX/BWALocate this document in the navigation structure

Use

To enable the ABAP system to communicate with SAP HANA or TREX/BWA (depending on which variant of Embedded Search you have chosen), you have to create a connection between these components.

Prerequisites

Note that there are different prerequisites depending on which variant of Embedded Search you have selected:

  • Prerequisites for the SAP HANA-based variant:
    • You have installed the SAP HANA database client.
    • You have created a second database connection:
    1. Call transaction DBCO in the ABAP system.
    2. Switch to change mode and choose New Entries.
    3. Create a new database entry:
      Parameter Description
      DB Connection Specify a name for the database connection.
      DBMS For SAP HANA, select the entry HDB.
      User Name

      Specify the database user to be used. This user must be assigned the object authorizations sys.trexviadbsl and sys.trexviadbslwithparameter.

      The database user also needs authorization to execute the following SQL commands on the SAP database schema (SAPSID): SELECT, INDEX, ALTER.

      DB Password Specify the corresponding password.
      Conn. Info

      Specify the connection to the database in the form Server:Port.

      The port is comprised as follows: 3<instance number>15.

      Example name of a connection: myHANA:30215

      Permanent Optional entry; see the F1 help.
      Connection Limit Optional entry; see the F1 help.
      Connection Optimum Optional entry; see the F1 help.
    4. Test the new database connection in transaction SE38. Specify the name of the program ADBC_TEST_CONNECTION and choose Execute (F8). On the next screen, enter the name of the database connection and choose Execute (F8).
  • Prerequisites for the TREX/BWA-based variant:

    You have installed the current version of SAP NetWeaver Search and Classification (TREX) 7.1 or SAP Business Warehouse Accelerator (BWA) 7.20 on a separate system. After the installation, you have created an RFC connection between the ABAP system for SAP NetWeaver and TREX/BWA:

    1. Creating an SAP System User for the TREX Admin Tool (Standalone)

    2. Determining the SAP System Connection Information

    3. Configuring the RFC Connection in the TREX Admin Tool

    If you are using SAP Business Warehouse Accelerator (BWA), an additional configuration step is necessary. For more information, see SAP Note 1647185 Information published on SAP site.

    More information: Connecting TREX with an ABAP Application (RFC Connection)

Process
  1. Log on to the SAP NetWeaver system and launch the Implementation Guide (IMG) by using transaction SPRO. Navigate to the node Start of the navigation path Search and Operational Analytics Next navigation step Common Settings for Operational Analytics and Embedded Search Next navigation step Configure Indexing Next navigation step Define TREX/BWA Destination or SAP HANA Database Connection End of the navigation path.

    When you launch the Customizing activity, the ABAP program ESH_ADM_SET_TREX_DESTINATION starts.

    • If you are running the TREX/BWA-based variant, choose Use TREX and specify the RFC connection to the TREX or BWA server that is to be used.
    • If you are running the SAP HANA-based variant, choose Use SAP HANA and specify the database connection to be used (see Prerequisites section). To display a list of available DB connection names, press F4.
      Note

      The parameters for establishing an HTTP connection to SAP HANA are provided for if you use the file loader.

      More information: Creating an HTTP Connection to the File Loader.

  2. Choose Execute.
  3. Finally, assign the SAP_ESH_LOCAL_ADMIN role to the planned administrators for Embedded Search.

    More information: Authorizations

Note

If you want to index documents that contain hidden text, also see SAP Note 604635 Information published on SAP site.