Do you struggle against legacy data ingestion processes?

Are your analysts saving spreadsheets with a particular filename, on a particular network drive, on a particular day, with a specific structure?

Perhaps your process necessitates an ancient format (.xls, Excel '95) or particular encoding.

Sucks, right?

It sucks also for the Platform Manager, who gets the email at 5am when the batch breaks due to something not-quite-right in said input file.

Or the Data Engineer, spending all day knocking out generic excel import routines. Or the sponsor, paying for a broken process, that should take seconds.

With Data Controller for SAS®, all these issues... disappear.

Thanks to our OEM licence of SheetJS, analysts can self-serve data uploads via the browser - no (insecure) network drive needed, nor thick client install.

And the data really can be anywhere in the workbook - in any shape, spread across any number of disparate sheets, ranges and cells. A range of import options handles everything from clean tabular sheets to sprawling financial reports.

Once automatic validations and DQ checks pass, and approval received, the target table is updated and any onward jobs are triggered. Needless to say, there is a full audit trail right back to the original excel file.

Not only that - you can load ANY database, SAS dataset, format, or CAS table. New data targets are configured by the admin - zero code, nothing to deploy or drag through to production.

There is also a community edition, free for unlimited users (restricted by rows).

If you'd like to excel by spending less time on Excel - let's chat.