Ready to get started?

Active Directory Integration Guides and Tutorials



A list of guides and tutorials for connecting to and working with live Active Directory data.

CData Software's connectivity tools enable users to connect directly to live Active Directory 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 Active Directory 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 Active Directory in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live Active Directory Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Active Directory Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Active Directory data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to Active Directory in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Active Directory Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Active Directory Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Active Directory in Birst
BIRTJDBCDesign BIRT Reports on Active Directory
Clear AnalyticsODBCBuild Charts with Active Directory in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Active Directory Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Active Directory in DBxtra
DomoODBCCreate Datasets from Active Directory in Domo Workbench
Dundas BIODBCBuild Dashboards with Active Directory in Dundas BI
Excel (on Mac OS)ODBCWork with Active Directory Data in MS Excel on Mac OS X
FineReportJDBCFeed Active Directory into FineReport
Google SheetsConnect CloudAccess Live Active Directory Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Active Directory
Infragistics RevealConnect CloudAnalyze Active Directory Data in Infragistics Reval
JasperServerJDBCCreate Active Directory Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Active Directory in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Active Directory in JReport Designer
KlipfolioConnect CloudCreate Active Directory-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Active Directory JDBC Driver in KNIME
LINQPadADO.NETWorking with Active Directory in LINQPad
LookerConnect CloudAnalyze Active Directory Data in Looker
Looker StudioConnect CloudCreate Reports from Active Directory Data in Looker Studio
MetabaseConnect CloudCreate Interactive Active Directory-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Active Directory Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Active Directory Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Active Directory
MicroStrategyConnect CloudConnect to Live Active Directory Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Active Directory in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Active Directory in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Active Directory in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Active Directory-Connected Visualizations in Mode
OBIEEJDBCActive Directory Reporting in OBIEE with the Active Directory JDBC Driver
pandasPythonUse pandas to Visualize Active Directory in Python
Pentaho Report DesignerJDBCIntegrate Active Directory in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Active Directory
Power BI ServiceConnect CloudVisualize Live Active Directory Data in the Power BI Service
Power PivotConnect CloudAccess Active Directory Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Active Directory Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Active Directory Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query Active Directory in QlikView over ODBC
RJDBCAnalyze Active Directory in R (JDBC)
RODBCAnalyze Active Directory in R (ODBC)
RapidMinerJDBCConnect to Active Directory in RapidMiner
RedashConnect ServerBuild Active Directory-Connected Dashboards in Redash
SAP Analytics CloudConnect CloudAnalyze Active Directory Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Active Directory
SAP Crystal ReportsJDBCPublish Reports with Active Directory in Crystal Reports
SASODBCUse the CData ODBC Driver for Active Directory in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Active Directory in SAS JMP
SAS ViyaConnect CloudAnalyze Live Active Directory Data in SAS Viya
SisenseJDBCVisualize Live Active Directory in Sisense
Spago BIJDBCConnect to Active Directory in SpagoBI
TableauTableauVisualize Active Directory in Tableau Desktop
Tableau CloudConnect CloudBuild Active Directory Visualizations in Tableau Cloud
Tableau ServerTableauPublish Active Directory-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Active Directory in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Active Directory Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Active Directory from Spotfire Server
VisioODBCLink Visio Shapes to Active Directory
Zoho AnalyticsConnect CloudCreate Active Directory-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to Active Directory Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous Active Directory Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Active Directory Replication to Amazon S3
Apache AirflowJDBCBridge Active Directory Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Active Directory using Apache Camel
Apache CassandraCData SyncAutomated Continuous Active Directory Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous Active Directory Replication to Apache Kafka
Apache NiFiJDBCBridge Active Directory Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Active Directory Data in Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with Active Directory Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Active Directory Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous Active Directory Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Active Directory Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Active Directory to SQL Server
CloverDXJDBCConnect to Active Directory in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous Active Directory Replication to Couchbase
CSVCData SyncAutomated Continuous Active Directory Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous Active Directory Replication to Databricks
FoxProODBCWork with Active Directory in FoxPro
Google AlloyDBCData SyncAutomated Continuous Active Directory Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Active Directory Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Active Directory Replication to Google Cloud SQL
Google Data FusionJDBCBuild Active Directory-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate Active Directory for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Active Directory in HULFT Integrate
IBM DB2CData SyncAutomated Continuous Active Directory Replication to IBM DB2
Informatica CloudJDBCIntegrate Active Directory in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Active Directory
Jaspersoft ETLJDBCConnect to Active Directory in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Active Directory Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Active Directory Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to Active Directory
Microsoft Power AutomateConnect CloudBuild Active Directory-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous Active Directory Replication to MongoDB
MySQLCData SyncAutomated Continuous Active Directory Replication to MySQL
Oracle Data IntegratorJDBCETL Active Directory in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Active Directory Replication to Oracle
petlPythonExtract, Transform, and Load Active Directory in Python
PostgreSQLCData SyncAutomated Continuous Active Directory Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate Active Directory to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous Active Directory Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Active Directory Replication to SingleStore
SnapLogicJDBCIntegrate Active Directory with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous Active Directory Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Active Directory Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to Active Directory Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous Active Directory Replication to SQLite
TalendJDBCConnect to Active Directory and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Active Directory in UiPath Studio
VerticaCData SyncAutomated Continuous Active Directory Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Active Directory
.NET QueryBuilderODBCRapidly Develop Active Directory-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Active Directory
Apache SparkJDBCWork with Active Directory in Apache Spark Using SQL
AppSheetConnect CloudCreate Active Directory-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild Active Directory-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to Active Directory Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on Active Directory Data in Choreo
ColdFusionJDBCQuery Active Directory in ColdFusion Using JDBC
ColdFusionODBCQuery Active Directory in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Active Directory
DelphiODBCDataBind Controls to Active Directory Data in Delphi
DevExpressADO.NETDataBind Active Directory to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Active Directory with Entity Framework 6
EF - LINQADO.NETLINQ to Active Directory
EF - MVCADO.NETBuild MVC Applications with Connectivity to Active Directory
Filemaker ProODBCBidirectional Access to Active Directory from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to Active Directory from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with Active Directory on Linux
Google Apps ScriptConnect CloudConnect to Active Directory Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Active Directory Entities in Java
IntelliJJDBCConnect to Active Directory in IntelliJ
JBossJDBCConnect to Active Directory from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Active Directory using JDBI
JRubyJDBCConnect to Active Directory in JRuby
MendixConnect CloudBuild Active Directory-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live Active Directory Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Active Directory Data in Node.js (via Connect Cloud)
NodeJSODBCQuery Active Directory through ODBC in Node.js
OutSystemsConnect CloudCreate Active Directory-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess Active Directory in PHP through Connect Server
PHPODBCNatively Connect to Active Directory in PHP
PowerBuilderADO.NETConnect to Active Directory from PowerBuilder
PowerShellPowerShellPipe Active Directory to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for Active Directory in PyCharm
PythonODBCConnect to Active Directory in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with Active Directory Data
RubyODBCConnect to Active Directory in Ruby
RunMyProcessConnect CloudConnect to Active Directory Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Active Directory in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Active Directory in SAPUI5 MVC Apps
ServoyJDBCBuild Active Directory-Connected Apps in Servoy
Spring BootJDBCAccess Live Active Directory Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Active Directory in Python
TomcatJDBCConfigure the CData JDBC Driver for Active Directory in a Connection Pool in Tomcat
UnqorkConnect CloudCreate Active Directory-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for Active Directory
WebLogicJDBCConnect to Active Directory from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top