Thanks for the great ideas. I did not know the SPDE tables and I am studying them. We don't want to change the SAS server configuration so we can't install an SPD Server... The need is to use SAS in the final part of the Data flow. 5 users use SAS guide only to read tables and create flows to feed PBI dashboards. Then they read the tables on oracle and write to MS sql tables (always new). I would like SAS to start from its own tables, and be efficient in its manipulations. Other users use the Campaign Manager instead. Compared to the needs mentioned by @AhmedAl_Attar we need: Concurrent Read / Write operations: Read only and write only on different databases (non concurrent writing) Parallel query execution: Yes Bitmap & B-tree Indexes: Probably yes (are they different from the usual indexes?) Materialized Views: Yes Audit trail and Roll-back functionality: No Table / Column / Row level security: No Data Encryption at Rest / Motion: No @LinusH Kindly give me some more details on the SPDE tables Thanks!
... View more