The following table describes the range of systems in the portal system landscape from which Visual Composer can import data, and the connectors that are required. The Connector (second column) indicates the name of the connector and portal system template (where applicable) used to install the system in the portal.
Connector |
Back End |
Data Service |
Comments |
|
---|---|---|---|---|
Standard SAP |
SAP_Connector |
SAP systems, SAP BI systems |
BAPIs |
|
Web Services Connector |
Web services |
|||
SAP_JDBC |
SQL, Oracle, DB2 |
Stored procedures |
||
BI |
BI XMLA Connector Use portal system template: BI XMLA-Compliant OLAP System |
XML for Analysis providers, including SAP BW systems 3.1C or higher (for systems 3.5 and higher, SAP BI Connector is recommended) |
Cubes with a default OLAP query and custom MDX queries. OLAP queries created with the BI Integration Wizard. |
Supports the use of SAPLOGONTICKET |
BI ODBO Connector Use portal system template: BI ODBO-Compliant OLAP System |
OLE DB for OLAP providers, including SAP BW 3.1C or higher (for systems 3.5 and higher, SAP BI Connector is recommended) |
Cubes with a default OLAP query and custom MDX queries. OLAP queries created with the BI Integration Wizard. |
||
BI JDBC Connector Use portal system template: BI JDBC System |
JDBC providers, such as SQL, Oracle, DB2 |
Tables with a default relational query and custom SQL queries. Relational queries created with the BI Integration Wizard. |
||
BI SAP Query Connector Use portal system template: BI SAP Query System |
SAP systems with base component, version 4.6C or higher |
Tables with a default relational query. Relational queries created with the BI Integration Wizard. |
||
SAP BI Connector Use portal system template: SAP system using dedicated application server |
SAP BI systems (BW) from NetWeaver 2004 SP Stack 14 and greater |
BI queries, query views, and characteristics. No support in the BI Integration Wizard. |
Supports the use of SAPLOGONTICKET |