Connectors and References

What is a Connector?

A connector defines the connection to your data source (e.g., SAP).
It also contains table definitions and relationships (foreign keys/references) that can be reused in all subsequent layers.

Managing References

• In SAP systems, foreign key relationships are usually not directly available.
• AC allows you to create and manage references manually between tables.
• These references define how source tables are joined when building transformations.

Tip: You can store all references inside the connector, so they’re automatically inherited (propagated) into staging, historization, and DWH layers.

Automatic Reference Detection

When field names are consistent (as in SAP), AC can automatically create relationships using a built-in job script (CreateRefN24).
This script scans tables for common field names (like MANDT, BUKRS, BELNR, GJAHR) and builds the correct connections automatically.