Previewing, Filtering and Reordering Remote Tables Data

You have imported a remote table and want to preview and reorganize the data for your needs.

What you can do to preview or reorganize your data depends on the connection and the adapter.
Connection Type Adapter Record Counts While Previewing Sort Data Filter Data

SAP ABAP

ABAP Adapter

For more information, see SAP ABAP Connections.

Not supported

Not supported

Filtering is supported, but with some restrictions:

  • Filters can be applied with operators if they contain, =, != , empty.

  • Filters must be separated by AND operator with Include, Exclude

Cloud Data Integration

Cloud Data Integration (CDI) Adapter

For more information, see Prepare Connectivity for Cloud Data Integration.

Not supported

Supported

Supported

SAP Success factor, Generic Odata

OData

For more information, see Prepare Connectivity for Generic OData.

Not supported

Supported

Supported

Generic JDBC

CamelJdbcAdapter

For more information, see Prepare Connectivity for Generic JDBC.

Supported

Supported

Supported

SAP HANA

SAP HANA smart data integration

For more information, see Connecting SAP HANA Cloud, SAP HANA Database to Remote Data Sources

Supported

Supported

Supported

For more information on remote tables and adapters, see Monitoring Remote Tables.

For more information on which connection types support data replication (direct or scheduled replication) and real-time replication, see Integrating Data via Connections.