Data Controller for SAS® - Use Cases and Features

What can you actually do with Data Controller? Here's the rundown:

• Data viewer with search, filter, and URL links - without table locks
• Secure data (stop end-user write access to production tables)
• Configure inputs in seconds (vs days or weeks for ETL jobs)
• Preconfigured load routines including SCD2 and Bitemporal
• Avoid exposing sensitive data in unsecured staging areas
• Enable SAS workflows (trigger a SAS job on data change)
• Prevent spreadsheet changes from halting batch flows
• Email alerts when data is changed / about to change
• Audit manual overrides on regulatory reporting data
• Four-eyes (or more) approval for all data changes
• View and amend formats in SAS format catalogs
• Export DDL in SAS, TSQL or PGSQL format
• Explore SAS 9 metadata and data lineage
• Work with special SAS missing numerics
• Upload password-protected Excel files
• Upload directly from CSV or Excel
• Composite / retained key support
• Enforce data quality at source
• Column and Row Level Security
• Advanced validation rules

Our software is used and trusted (in production) by:

• Governments
• Insurers
• Pharma
• Banks

Plus various other industry sectors - references available.

Would you like to kick the tyres? Get in touch for details.