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)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from LDAP Data in Amazon QuickSight
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
Infragistics RevealConnect ServerAnalyze LDAP Data in Infragistics Reval
JasperServerJDBCCreate LDAP Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to LDAP in Jaspersoft Studio
JReport DesignerJDBCIntegrate with LDAP in JReport Designer
KlipfolioConnect ServerCreate LDAP-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the LDAP JDBC Driver in KNIME
LINQPadADO.NETWorking with LDAP in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from LDAP
MicroStrategyConnect ServerConnect to Live LDAP Data in MicroStrategy through Connect Server
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
Power BI ServiceConnect ServerVisualize Live LDAP Data in the Power BI Service
Power PivotConnect ServerAccess LDAP Data in Microsoft Power Pivot
Power QueryConnect ServerAccess LDAP Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from LDAP Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query LDAP in QlikView over ODBC
RJDBCAnalyze LDAP in R (JDBC)
RODBCAnalyze LDAP in R (ODBC)
RapidMinerJDBCConnect to LDAP in RapidMiner
RedashConnect ServerQuery, Visualize, and Share live LDAP Data in Redash
SAP Analytics CloudConnect ServerAnalyze LDAP Data in SAP Analytics Cloud
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 CloudConnect ServerBuild LDAP Visualizations in Tableau Cloud
Tableau ServerTableauPublish LDAP-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize LDAP in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize LDAP Data in TIBCO Spotfire
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 Power AutomateConnect ServerBuild LDAP-Connected Automated Tasks with Power Automate (Desktop)
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
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
SQL Server Linked ServerConnect ServerConnect to LDAP Data as a SQL Server Linked 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
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with LDAP
Apache SparkJDBCWork with LDAP in Apache Spark Using SQL
AppSheetConnect ServerCreate LDAP-Connected Business Apps in AppSheet
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
Google Apps ScriptConnect ServerConnect to LDAP Data in Google Apps Script
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
Microsoft Power AppsConnect ServerIntegrate Live LDAP Data into Custom Business Apps Built in Power Apps
NodeJSConnect ServerQuery LDAP Data in Node.js (via Connect Server)
NodeJSODBCQuery LDAP through ODBC in Node.js
PHPConnect ServerAccess LDAP in PHP through Connect Server
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
ReactConnect ServerBuild Dynamic React Apps with LDAP Data
RubyODBCConnect to LDAP in Ruby
RunMyProcessConnect ServerConnect to LDAP Data in RunMyProcess
RunMyProcess DSECJDBCConnect to LDAP in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to LDAP in SAPUI5 MVC Apps
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
UnqorkConnect ServerCreate LDAP-Connected Applications in Unqork
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