As an administrator if you would like to create connections using SAP BI Links, you would like to have a ready list of parameters that are available to you for defining the connection correctly.
| Parameter Description | in SAP BI URL | Basic | SSO | SUP | SMP | Possible Values |
| Name of connection | connection_name | Y | | | | |
| Type of connection | ConnectionType | Y | | | | BOESUPConnection, BOESMPConnection,
BOEConnection etc. |
| CMS Name or Cluster | cms | Y | | | | |
| Mobile Server or SUP/SMP Server URL | server_url | Y | | | | |
| AuthenticationType | authType | Y | | | | secEnterprise, secLDAP, secSAPR3, secWINAD |
| Is it a SSO connection? | isSSO | | Y | | | YES,NO (in SAP BI Link) |
| Type of SSO Configured? | SSOType | | Y | | | X509Certificate, SSO2COOKIE, SITEMINDER_BASIC,
TRUSTED_AUTH_Basic, TRUSTED_AUTH_FORM, SSO_Form, SSO2COOKIE_QueryString |
| If X509 Certificates used, then how are they configured? | isCertificateRequired | | Y | | | CertificateMandatory, CertificateOptional |
| URL that will provide SSO2COOKIE | sso2CookieQueryURL | | Y | | | |
| Form that will generate SSO2COOKIE | ssoFormURL | | Y | | | |
| SSO Cookie Name if different than standard | ssoCookieName | | Y | | | |
| SAP R3 system in case of SSO | sapsys | | Y | | | ABC^200, XYZ^100 etc. |
| SUP Farm ID | SUP_Farm_ID | | | Y | | |
| SUP/SMP Security Configuration Name | Sec_Config | | | Y | Y | |
| SUP Port | SUP_Port | | | Y | | |
| SUP/SMP Application ID | Application_ID | | | Y | Y | |
| SMP Proxy Connection Name | proxyConnection | | | | Y | |
BOE connection
| Add a connection | sapbi://addconnection?ConnectionType=BOEConnection&name=ConnectionName&server_url=ServerName/IP:Port&cms=101.01.01.01:Port&authType=AuthenticationType&default=yes/no |
| Delete a connection | sapbi://DeleteConnection? ConnectionType=BOEConnection&name=Tom&server_url=10.53.10.10:8080&cms=10.53.10.10&authType=secEnterprise&default=no |
| Modify a connection | sapbi://ModifyConnection?ConnectionType=BOEConnection&ConnectionName_Prev=Conn1&ConnectionName_New=Conn2&Server_Url_Prev=10.53.10.10:8080&Server_Url_New=10.10.10.10 :1010&CMS_Prev=10.53.10.10&CMS_New=10.10.10.10&AuthType_Prev=secEnterprise&AuthType_New=secLDAP&default=yes&UserName_Prev=Administrator |
SUP connection
| Add a connection | sapbi://addconnection?ConnectionType=SUPConnection&Application_ID=MobiApp&Sec_Config=MobiSec&server_url=10.53.129.243&SUP _Port=5001&SUP_Farm_ID=0 |
| Delete a connection | sapbi://DeleteConnection?ConnectionType=SUPConnection |
| Modify a connection | sapbi://ModifyConnection?ConnectionType=SUPConnection&Application_ID=MobiApp1&Sec_Config=MobiSec1&server_url=10.10.10.10&SUP_Port=5001&SUP_Farm_ID=0 |
Note: While modifying a connection normally you have to repeat each parameter twice - one with "Prev" and another with "New" suffix. However, in case of SUP connection that is not required. This is because you can have only one SUP connection.
