Destinations

Xtract Universal.iQ allows you to extract data from SAP systems and load it to different target environments (destinations).

About Destinations

Destinations are target environments where the results of service runs are written. By default, Xtract Universal.iQ services return SAP data in JSON format in the service response body. This is the HTTP-JSON destination. HTTP-JSON is the default destination and cannot be deleted.

Any other destinations must be set up in Xtract Universal.iQ before you can use them.

Which destinations are available to you depends on your license. You can find a list of available destinations in the License menu.

Supported Destinations

Xtract Universal.iQ supports the following destinations:

Amazon S3

Apache Iceberg

Apache Kafka

HTTP Web Service

Microsoft Azure Storage

Microsoft Fabric (OneLake)

Microsoft Fabric Open Mirroring

Microsoft Power BI

Microsoft SQL Server

PostgreSQL

Edit Destinations

To modify an existing destination:

1. Open the Connections menu.
2. Select a destination.
3. Click [ Edit]. The connection settings open.
4. Make the necessary changes.
5. Click [Save].

The destination is updated. Services that use the destination are affected by the update.

Delete Destinations

To delete a destination that is not in use anymore:

1. Open the Connections menu.
2. Select one or more destinations.
3. Click [...More > Delete]. A confirmation window opens.
4. Click [OK] to delete the destination.

The destination is removed from the Connections menu. Services that still use the destination stop working.

Restrict Access to Destinations

You can set up access restrictions to a destination to ensure that the connection can only be modified by trained users. For more information, see Connection Level Access.