Learn more
 

Ready to get started?

Learn more:

SAS Data Sets Connectivity Solutions

In this article

Related articles

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)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from SAS Data Sets Data in Amazon QuickSight
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
Infragistics RevealConnect ServerAnalyze SAS Data Sets Data in Infragistics Reval
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
KlipfolioConnect ServerCreate SAS Data Sets-Connected Visualizations in Klipfolio
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
MicroStrategyConnect ServerConnect to Live SAS Data Sets Data in MicroStrategy through Connect Server
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
Power BI ServiceConnect ServerVisualize Live SAS Data Sets Data in the Power BI Service
Power PivotConnect ServerAccess SAS Data Sets Data in Microsoft Power Pivot
Power QueryConnect ServerAccess SAS Data Sets Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from SAS Data Sets Data in Qlik Sense Cloud
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
RedashConnect ServerBuild SAS Data Sets-Connected Dashboards in Redash
SAP Analytics CloudConnect ServerAnalyze SAS Data Sets Data in SAP Analytics Cloud
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
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 CloudConnect ServerBuild SAS Data Sets Visualizations in Tableau Cloud
Tableau ServerTableauPublish SAS Data Sets-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize SAS Data Sets in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize SAS Data Sets Data in TIBCO Spotfire
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)
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
Microsoft Power AutomateConnect ServerBuild SAS Data Sets-Connected Automated Tasks with Power Automate (Desktop)
Oracle Data IntegratorJDBCETL SAS Data Sets in Oracle Data Integrator
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
SQL Server Linked ServerConnect ServerConnect to SAS Data Sets Data as a SQL Server Linked Server
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


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate SAS Data Sets with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for SAS Data Sets (JDBC)
DenodoJDBCCreate A Data Source for SAS Data Sets in Denodo Platform
DremioJDBCConnect to SAS Data Sets as an External Source in Dremio
MySQL Federated TablesODBCConnect to SAS Data Sets as Federated Tables in MySQL
Oracle DatabaseODBCAccess SAS Data Sets as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for SAS Data Sets
Salesforce ConnectConnect ServerEdit and Search SAS Data Sets External Objects in Salesforce Connect
SQL Server Linked ServersODBCConnect to SAS Data Sets as a Linked Server
SQL Server PolyBaseODBCConnect to SAS Data Sets as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live SAS Data Sets Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to SAS Data Sets
.NET QueryBuilderODBCRapidly Develop SAS Data Sets-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with SAS Data Sets
Apache SparkJDBCWork with SAS Data Sets in Apache Spark Using SQL
AppSheetConnect ServerCreate SAS Data Sets-Connected Business Apps in AppSheet
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
Google Apps ScriptConnect ServerConnect to SAS Data Sets Data in Google Apps Script
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
Microsoft Power AppsConnect ServerIntegrate Live SAS Data Sets Data into Custom Business Apps Built in Power Apps
NodeJSConnect ServerQuery SAS Data Sets Data in Node.js (via Connect Server)
NodeJSODBCQuery SAS Data Sets through ODBC in Node.js
PHPConnect ServerAccess SAS Data Sets in PHP through Connect Server
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
ReactConnect ServerBuild Dynamic React Apps with SAS Data Sets Data
RubyODBCConnect to SAS Data Sets in Ruby
RunMyProcessConnect ServerConnect to SAS Data Sets Data in RunMyProcess
RunMyProcess DSECJDBCConnect to SAS Data Sets in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to SAS Data Sets in SAPUI5 MVC Apps
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
UnqorkConnect ServerCreate SAS Data Sets-Connected Applications in Unqork
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


ProductTechnologyArticle Title
Apache SolrJDBCImport SAS Data Sets Data into Apache Solr
DB ArtisanJDBCManage SAS Data Sets in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to SAS Data Sets in DBArtisan
DBeaverJDBCConnect to SAS Data Sets in DBeaver
DbVisualizerJDBCConnect to SAS Data Sets in DBVisualizer
Informatica Enterprise Data CatalogJDBCAdd SAS Data Sets to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery SAS Data Sets Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery SAS Data Sets in MySQL Workbench (ODBC)
QuerySurgeJDBCValidate SAS Data Sets Data with QuerySurge
RazorSQLJDBCConnect to SAS Data Sets in RazorSQL
SQuirreLJDBCConnect to SAS Data Sets in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess SAS Data Sets in Anypoint Using SQL
Nintex Workflow CloudConnect ServerBuild SAS Data Sets-Connected Workflows in Nintex
Power AutomateConnect ServerIntegrate SAS Data Sets Data into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to SAS Data Sets through SSIS
SSIS ImportSSISImport SAS Data Sets Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing SAS Data Sets Records from SQL Server

Back to top