Data Sources Listed Alphabetically
For more information about SAS Cloud Analytic Services (CAS) and the SAS Compute Server, see SAS Viya Platform Servers in SAS Viya Platform Programming: Getting Started. For a list of common tasks, see Accessing Data.
|
Data Source |
Accessing in CAS |
Accessing in Compute Server |
|---|---|---|
|
Amazon Aurora MySQL | ||
|
Amazon Aurora PostgreSQL | ||
|
Amazon RDS MariaDB | ||
|
Amazon RDS Microsoft SQL Server | ||
|
Amazon RDS MySQL | ||
|
Amazon RDS Oracle | ||
|
Amazon RDS PostgreSQL | ||
|
Amazon Redshift | ||
|
Amazon S3 | ||
|
Amazon Web Services EMR | ||
|
Audio |
– | |
|
CAS | ||
|
Cloud Data Exchange | ||
|
Cloudera | ||
|
CockroachDB |
– | |
|
Databricks | ||
|
DB2 | ||
|
Delimited files (CSV) | ||
|
DNFS |
– | |
|
Document |
– | |
|
DTA | ||
|
DuckDB |
– | |
|
EnterpriseDB PostgreSQL | ||
|
Google BigQuery | ||
|
Google Cloud Storage | ||
|
Google Cloud SQL for MySQL | ||
|
Google Cloud SQL for Microsoft SQL Server | ||
|
Google Cloud SQL for PostgreSQL | ||
|
Google Dataproc | ||
|
Greenplum | ||
|
Hadoop | ||
|
Hortonworks | ||
|
Image |
– | |
|
Impala | ||
|
Informix | ||
|
JDBC | ||
|
JMP | ||
|
JSON |
– | |
|
MariaDB | ||
|
Microsoft Azure Blob Storage files |
– | |
|
Microsoft Azure Data Lake Storage Gen2 files | ||
|
Microsoft Azure Database for MySQL | ||
|
Microsoft Azure Database for PostgreSQL | ||
|
Microsoft Azure HDInsight | ||
|
Microsoft Azure SQL | ||
|
Microsoft Azure Synapse | ||
|
Microsoft Excel | ||
|
Microsoft Fabric Data Warehouse Microsoft Fabric Lakehouse | ||
|
Microsoft SQL Server | ||
|
MongoDB | ||
|
MySQL | ||
|
Netezza | ||
|
ODBC | ||
|
Oracle Autonomous Database | ||
|
Oracle | ||
|
Oracle MySQL | ||
|
ORC | ||
|
Parquet | ||
|
Path-based files |
– | |
|
PC files | ||
|
PI System |
– | |
|
PostgreSQL | ||
|
R/3 (SAP) |
– | |
|
Salesforce | ||
|
SAP ASE |
– | |
|
SAP HANA | ||
|
SAP IQ | ||
|
SAS data sets | ||
|
SAS Federation Server | ||
|
SAS LASR |
– | |
|
SASHDAT |
– | |
|
SingleStore | ||
|
Snowflake | ||
|
Spark | ||
|
SPD Engine files | ||
|
SPD Engine files in HDFS | ||
|
SPSS SAV files | ||
|
Teradata | ||
|
Vertica | ||
|
Video |
– | |
|
Yellowbrick | ||
|
XML |
– |