admin show_connection_profiles

Syntax

admin show_connection_profiles[, “match_string”]

Parameters

• match_string – Filters the connection profiles displayed. Only those connection profiles whose names contain the string provided are displayed.

Examples

• Example 1 – Lists the names of all connection profiles currently defined in Replication Server:

  admin show_connection_profiles
  go

  Profile Name                 Version  Comments
  ------------                    -------- ---------------------------
  rs_ase_to_db2                standard Standard ASE to DB2 replication
                                        connection profile.
  rs_ase_to_udb                standard Standard ASE to UDB replication
                                        connection profile.
  rs_ase_to_oracle             standard Standard ASE to Oracle replication
                                        connection profile.
  rs_ase_to_msss               standard Standard ASE to Microsoft SQLServer
                                        replication connection profile.
  rs_ase_to_ase                standard Standard ASE to ASE replication
                                        connection profile.
  rs_ase_to_iq                 standard Standard ASE to Sybase IQ
                                        replication connection profile.
  rs_ase_to_hanadb             ech      ASE to HanaDB replication connection 
                                        using Express Connector for HanaDB.
  rs_db2_to_msss               standard Standard DB2 to Microsoft SQLServer
                                        replication connection profile.
  rs_db2_to_oracle             standard Standard DB2 to Oracle replication
                                        connection profile.
  rs_db2_to_udb                standard Standard DB2 to UDB replication
                                        connection profile.
  rs_db2_to_ase                standard Standard DB2 to ASE replication
                                        connection profile.
  rs_oracle_to_db2             standard Standard Oracle to DB2 replication
                                        connection profile.
  rs_oracle_to_udb             standard Standard Oracle to UDB replication
                                         connection profile.
  rs_oracle_to_msss             standard Standard Oracle to Microsoft
                                        SQLServer replication connection
                                        profile.
  rs_oracle_to_ase             standard Standard Oracle to ASE replication
                                        connection profile.
  rs_oracle_to_iq              standard Standard Oracle to IQ replication 
                                        connection profile.
  rs_oracle_to_hanadb            ech      Oracle to HanaDB replication connection 
                                        using Express Connector for HanaDB.
  rs_msss_to_db2                 standard Standard Microsoft SQLServer to DB2
                                        replication connection profile.
  rs_msss_to_oracle             standard Standard Microsoft SQLServer to
                                        Oracle replication connection profile. 
  rs_msss_to_udb                standard Standard Microsoft SQL Server to
                                        UDB replication connection profile.
  rs_msss_to_ase               standard Standard MicrosoftSQL Server to ASE
                                        replication connection profile.
  rs_msss_to_hanadb            ech      Microsoft SQLServer to HanaDB replication 
                                        connection using Express Connector for HanaDB.
  rs_udb_to_db2                standard Standard udb to db2 replication
                                        connection profile.
  rs_udb_to_msss              standard Standard UDB to Microsoft SQLServer
                                        replication connection profile.
  rs_udb_to_oracle            standard Standard UDB to Oracle replication
                                        connection profile.
  rs_udb_to_ase               standard Standard UDB to ASE replication
                                        connection profile.
  rs_udb_to_hanadb             ech      UDB to HanaDB replication connection 
                                        using Express Connector for HanaDB.
  rs_db2_to_db2                standard Standard DB2 to DB2 replication
                                        connection profile.
  rs_oracle_to_oracle          standard Standard Oracle to Oracle
                                        replication connection profile.
  rs_udb_to_udb                standard Standard UDB to UDB replication
                                        connection profile. 
  rs_msss_to_msss               standard Standard Microsoft SQLServer to
                                        Microsoft SQLServer replication
                                        connection profile.
  rs_ase_to_oracle             eco      ASE to Oracle replication connection 
                                        profile using Express Connect for Oracle.
  rs_db2_to_oracle             eco      DB2 to Oracle replication connection 
                                        profile using Express Connect for Oracle.
  rs_msss_to_oracle            eco      Microsoft SQLServer to Oracle replication 
                                        connection profile using Express Connect for Oracle
  rs_oracle_to_oracle          eco      Oracle to Oracle replication connection 
                                        profile using Express Connect for Oracle.
  rs_udb_to_oracle             eco      UDB to Oracle replication connection profile 
                                        using Express Connect for Oracle.
  rs_rs_to_oracle_ra           standard Standard RS to RA direct load 
                                        connection profile.
  rs_rs_to_udb_ra              standard Connection profile for replication from 
                                        IBM DB2 LUW (UDB) using Replication Agent 
                                        for direct load materialization.
  rs_rs_to_msss_ra             standard Connection profile for replication from 
                                        Microsoft SQL Server using Replication Agent 
                                        for direct load materialization. 
  
  (39 rows affected)

• Example 2 – Lists the names of all connection profiles currently defined in SAP Replication Server that have the string “oracle” in the connection profile name:

  admin show_connection_profiles, “oracle”
  go

  Profile Name                 Version  Comments
  ----------------             -------- ---------------------------
  rs_oracle_to_db2             standard Standard Oracle to DB2 replication 
                                        connection profile.
  rs_oracle_to_udb             standard Standard Oracle to UDB replication 
                                        connection profile.
  rs_oracle_to_msss              standard Standard Oracle to Microsoft SQLServer 
                                        replication connection profile.
  rs_oracle_to_ase             standard Standard Oracle to ASE replication 
                                        connection profile.
  rs_oracle_to_iq              standard Standard Oracle to IQ
                                        replication connection profile.
  rs_oracle_to_hanadb            ech      Oracle to HanaDB replication connection 
                                        using Express Connector for HanaDB.
  rs_ase_to_oracle             eco      ASE to Oracle replication connection 
                                        profile using Express Connect for Oracle.
  rs_db2_to_oracle             eco      DB2 to Oracle replication connection profile 
                                        using Express Connect for Oracle.
  rs_msss_to_oracle              eco      Microsoft SQLServer to Oracle replication 
                                        connection profile using Express Connect 
                                        for Oracle.
  rs_oracle_to_oracle           eco      Oracle to Oracle replication connection 
                                        profile using Express Connect for Oracle.
  rs_udb_to_oracle             eco      UDB to Oracle replication connection profile 
                                        using Express Connect for Oracle.
  rs_rs_to_oracle_ra           standard Standard RS to RA direct load 
                                        connection profile. 
  

Usage

When creating connections with the using profile option, use admin show_connection_profiles to determine the name and version of the available profiles.