SAS Studio
Seamless collaboration. Low-code brilliance. Open source integration.
-
Access any data – on-premises or in the cloud
Connect to leading cloud data platforms, such as AWS Redshift and S3, Google BigQuery and Cloud Storage, Azure Data Lake storage. SAS Studio also connects to relational and nonrelational databases – Oracle, Snowflake, Teradata, SingleStore, MongoDB and others – and various file formats, such as Excel, Text, Parquet and ORC.
-
Choose your path: No code, low code or, yes, code
Create end-to-end data pipelines using a wide collection of powerful steps in a drag-and-drop interface. Develop your Python and SAS code assets within SAS Studio or any other IDE. Then seamlessly embed them into SAS Studio flows to ensure centralized, secure access to data sources, single pane of glass for your data flows and a governed auditable execution environment.
-
Choose your style: Integrate data in ELT or ETL manner
Create data integration processes in an ELT or ETL approach. Get the best performance from powerful in-database transformations to join, transform and merge data, and implement slowly changing dimensions. You can also enable ETL processing on an application server. Or use a combination of both.
-
Create your own visual transformations for unique needs
A visual drag-and-drop designer lets you create your own powerful custom transformations, share them across data teams and use custom steps in data flow or standalone. Explore a variety of community-built transformations in the public SAS Studio Custom Steps GitHub repository.
-
Streamline, boost and govern data team collaboration
Efficiently manage and orchestrate your project assets by using advanced Git integration for resolving code and logic changes, enabling versioning and change history tracking across multiple data engineers. Serve data easily with open documented APIs.
-
Integrate with open source technologies wisely
Schedule, orchestrate and monitor your data pipelines with Apache Airflow with SAS Provider for Airflow or any other tools. Bring your Python code in governed enterprise workflows. Wrap up siloed open source utilities into visual steps with a custom steps framework.
