Show TOC

admin show_connection_profilesLocate this document in the navigation structure

Lists the profile name, version, and comments for each profile defined in SAP Replication Server.

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.