Managing Data Properties
Configure and manage database properties, schemas, relationships, and data types for your TDK workflows.
What You’ll Find Here
This subsection covers:
-
Schema Creation - Creating and managing database schemas
-
Virtual Foreign Keys - Defining relationships TDK can’t auto-detect
-
Cyclical References - Handling circular foreign key relationships
-
Value Mapping - Changing data types and transforming values
-
Triggers - Managing database triggers during transformations
-
Custom SQL Scripting - Pre and post-execution SQL scripts
Where to Start
-
Define Relationships: Virtual Foreign Keys
-
Manage Schemas: Schema Creation
-
Transform Data Types: Value Mapping