Show TOC

Background documentationAppendix: Visual Composer Connectivity Locate this document in the navigation structure

 

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.

Visual Composer Connectors

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