SAS Data Sets Integration Guides and Tutorials



A list of guides and tutorials for connecting to and working with live SAS Data Sets data.

CData Software's connectivity tools enable users to connect directly to live SAS Data Sets data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live SAS Data Sets data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze SAS Data Sets in Alteryx Designer (ODBC)
Aqua Data StudioJDBCConnect to SAS Data Sets in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze SAS Data Sets Data in Databricks (AWS)
BirstJDBCBuild Visualizations of SAS Data Sets in Birst
BIRTJDBCDesign BIRT Reports on SAS Data Sets
Clear AnalyticsODBCBuild Charts with SAS Data Sets in Clear Analytics
DBxtraODBCBuild Dashboards with SAS Data Sets in DBxtra
DomoODBCCreate Datasets from SAS Data Sets in Domo Workbench
Dundas BIODBCBuild Dashboards with SAS Data Sets in Dundas BI
Excel (on Mac OS)ODBCWork with SAS Data Sets Data in MS Excel on Mac OS X
FineReportJDBCFeed SAS Data Sets into FineReport
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with SAS Data Sets
JasperServerJDBCCreate SAS Data Sets Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to SAS Data Sets in Jaspersoft Studio
JReport DesignerJDBCIntegrate with SAS Data Sets in JReport Designer
KNIMEJDBCEnable the SAS Data Sets JDBC Driver in KNIME
LINQPadADO.NETWorking with SAS Data Sets in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from SAS Data Sets
MicroStrategyJDBCUse the CData JDBC Driver for SAS Data Sets in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for SAS Data Sets in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for SAS Data Sets in MicroStrategy Web
OBIEEJDBCSAS Data Sets Reporting in OBIEE with the SAS Data Sets JDBC Driver
pandasPythonUse pandas to Visualize SAS Data Sets in Python
Pentaho Report DesignerJDBCIntegrate SAS Data Sets in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time SAS Data Sets
QlikViewODBCConnect to and Query SAS Data Sets in QlikView over ODBC
RJDBCAnalyze SAS Data Sets in R (JDBC)
RODBCAnalyze SAS Data Sets in R (ODBC)
RapidMinerJDBCConnect to SAS Data Sets in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for SAS Data Sets
SAP Crystal ReportsJDBCPublish Reports with SAS Data Sets in Crystal Reports (JDBC)
SASODBCUse the CData ODBC Driver for SAS Data Sets in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for SAS Data Sets in SAS JMP
SisenseJDBCVisualize Live SAS Data Sets in Sisense
Spago BIJDBCConnect to SAS Data Sets in SpagoBI
TableauTableauVisualize SAS Data Sets in Tableau Desktop
Tableau ServerTableauPublish SAS Data Sets-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize SAS Data Sets in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on SAS Data Sets from Spotfire Server
VisioODBCLink Visio Shapes to SAS Data Sets

Back to top

ETL & Replication


ProductTechnologyArticle Title
Apache AirflowJDBCBridge SAS Data Sets Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with SAS Data Sets using Apache Camel
Apache NiFiJDBCBridge SAS Data Sets Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with SAS Data Sets Data in Apache NiFi
BIMLSSISUse Biml to Build SSIS Tasks to Replicate SAS Data Sets to SQL Server
CloverDXJDBCConnect to SAS Data Sets in CloverDX (formerly CloverETL)
ETL ValidatorJDBCHow to Work with SAS Data Sets in ETL Validator
FoxProODBCWork with SAS Data Sets in FoxPro
Google Data FusionJDBCBuild SAS Data Sets-Connected ETL Processes in Google Data Fusion
HULFT IntegrateJDBCConnect to SAS Data Sets in HULFT Integrate
Informatica CloudJDBCIntegrate SAS Data Sets in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for SAS Data Sets
Jaspersoft ETLJDBCConnect to SAS Data Sets in Jaspersoft Studio
Microsoft ExcelExcelTransfer Data from Excel to SAS Data Sets
Oracle Data IntegratorJDBCETL SAS Data Sets in Oracle Data Integrator
Pentaho Data IntegrationJDBCIntegrate SAS Data Sets in Pentaho Data Integration
petlPythonExtract, Transform, and Load SAS Data Sets in Python
Replicate to MySQLPowerShellReplicate SAS Data Sets to MySQL with PowerShell
SnapLogicJDBCIntegrate SAS Data Sets with External Services using SnapLogic (JDBC)
TalendJDBCConnect to SAS Data Sets and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to SAS Data Sets in UiPath Studio

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live SAS Data Sets Data in AWS Lambda
.NET ChartsADO.NETDataBind Charts to SAS Data Sets
.NET QueryBuilderODBCRapidly Develop SAS Data Sets-Driven Apps with Active Query Builder
Apache SparkJDBCWork with SAS Data Sets in Apache Spark Using SQL
C++BuilderODBCDataBind Controls to SAS Data Sets Data in C++Builder
ColdFusionJDBCQuery SAS Data Sets in ColdFusion Using JDBC
ColdFusionODBCQuery SAS Data Sets in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on SAS Data Sets
DelphiODBCDataBind Controls to SAS Data Sets Data in Delphi
DevExpressADO.NETDataBind SAS Data Sets to the DevExpress Data Grid
EF - Code FirstADO.NETAccess SAS Data Sets with Entity Framework 6
EF - LINQADO.NETLINQ to SAS Data Sets
EF - MVCADO.NETBuild MVC Applications with Connectivity to SAS Data Sets
Filemaker ProODBCBidirectional Access to SAS Data Sets from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to SAS Data Sets from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with SAS Data Sets on Linux
HibernateJDBCObject-Relational Mapping (ORM) with SAS Data Sets Entities in Java
IntelliJJDBCConnect to SAS Data Sets in IntelliJ
JBossJDBCConnect to SAS Data Sets from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for SAS Data Sets using JDBI
JRubyJDBCConnect to SAS Data Sets in JRuby
Lazarus IDEODBCEasily Integrate SAS Data Sets Data in Lazarus Pascal IDE
MendixJDBCBuild SAS Data Sets-Connected Apps in Mendix (JDBC)
NodeJSODBCQuery SAS Data Sets through ODBC in Node.js
PHPODBCNatively Connect to SAS Data Sets in PHP
PowerBuilderADO.NETConnect to SAS Data Sets from PowerBuilder
PowerShellPowerShellPipe SAS Data Sets to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for SAS Data Sets in PyCharm
PythonODBCConnect to SAS Data Sets in Python on Linux/UNIX
RubyODBCConnect to SAS Data Sets in Ruby
RunMyProcess DSECJDBCConnect to SAS Data Sets in DigitalSuite Studio through RunMyProcess DSEC
ServoyJDBCBuild SAS Data Sets-Connected Apps in Servoy
Spring BootJDBCAccess Live SAS Data Sets Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access SAS Data Sets in Python
TomcatJDBCConfigure the CData JDBC Driver for SAS Data Sets in a Connection Pool in Tomcat
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for SAS Data Sets
WebLogicJDBCConnect to SAS Data Sets from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top

Ready to get started?