LDAP Integration Guides and Tutorials



A list of guides and tutorials for connecting to and working with live LDAP objects.

CData Software's connectivity tools enable users to connect directly to live LDAP objects 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 LDAP objects.

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

Back to top

ETL & Replication


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

Back to top

Data Virtualization



Back to top

Software Development


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

Back to top

Data Management



Back to top

Workflow Automation



Back to top

Ready to get started?

Learn more:

LDAP Connectivity Solutions