CData Software - Knowledge Base
Recent Articles
-
Replicate Multiple VWO Accounts via the CData Sync CLI
Replicate multiple VWO accounts to one or many databases.
-
How to Build an ETL App for Microsoft Exchange Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Exchange in Python with petl.
-
Access Live Codat Data in Coginiti Pro
Connect to and query live Codat from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Pushbullet Data in Jaspersoft Studio
Execute SQL to remote Pushbullet in Jaspersoft Studio.
-
Import Real-Time Microsoft Planner Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Planner in ColdFusion.
-
Build Avaza-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Avaza and build web apps with connectivity to live Avaza.
-
Integrate Dynamics NAV Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Dynamics NAV in the Pentaho Data Integration tool.
-
How to Build an ETL App for Outreach.io Data in Python with CData Connect AI
Build ETL pipelines that read and write live Outreach.io in Python with petl and the CData Connect AI Python SDK.
-
Connect to Google Tasks in SpagoBI
Create reports featuring live Google Tasks in SpagoBI Studio. Host Google Tasks reports on SpagoBI Server.
-
How to Work with LightSpeedRetail Data in AWS Glue Jobs Using JDBC
Connect to LightSpeedRetail from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData ODBC Driver for CircleCI
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CircleCI.
-
How to publish and share Google Ad Manager Data dashboards with Tableau Server
The CData ODBC driver for Google Ad Manager enables you integrate Google Ad Manager into Tableau dashboards.
-
How to Build an ETL App for Salesforce Pardot Data in Python with CData Connect AI
Build ETL pipelines that read and write live Salesforce Pardot in Python with petl and the CData Connect AI Python SDK.
-
Build a PostgreSQL Interface for Pingdom Data using the CData JDBC Driver
Use the Remoting features of the Pingdom JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Bullhorn CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Bullhorn CRM in Airbyte.
-
Work with Live LinkedIn Ads Data in Power Query
Use CData Connect AI to connect to LinkedIn Ads and work with live LinkedIn Ads in Microsoft Power Query.
-
Access Live ServiceDesk Plus Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ServiceDesk Plus in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Salesforce Pardot Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Salesforce Pardot from Filemaker Pro on Mac.
-
Connect to WordPress Data in Jaspersoft Studio
Execute SQL to remote WordPress in Jaspersoft Studio.
-
DataBind Charts to Google Sheets Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Sheets from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated Continuous Zendesk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zendesk replication to Apache Kafka.
-
Replicate ServiceNow Data from PowerShell
Write a quick PowerShell script to query ServiceNow. Use connectivity to the live data to replicate ServiceNow to SQL Server.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via JDBC
This article demonstrates how to access Dynamics 365 Business Central from PowerBuilder using the Dynamics 365 Business Central JDBC Driver.
-
Access HCL Domino Data from MySQL in PHP
Connect to HCL Domino through the standard MySQL libraries in PHP.
-
Analyze Presto Data in Cognos Analytics
Use CData Connect AI to connect to Presto Data from Cognos Analytics and analyze live Presto.
-
Create Wistia Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Wistia data access from reports, embedded analytics, and more.
-
Use Biml to Build SSIS Tasks to Replicate ConvertKit Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ConvertKit to SQL Server.
-
Prepare, Blend, and Analyze Oracle Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Database for self-service data analytics.
-
Connect to HubSpot Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HubSpot as an External Source in Dremio.
-
Automated Continuous Raisers Edge NXT Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to delimited files (CSV/TSV).
-
Connect to MailerLite Data in DBArtisan
Use wizards in DBArtisan to configure MailerLite as a data source.
-
Build Semantic Layer Views for Excel Online Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Excel Online.
-
Create SAP Concur-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Concur Data from Nintex Workflow Cloud and build custom workflows using live SAP Concur.
-
Build Apps with Live SAP HANA in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP HANA into the Adalo platform and build custom mobile and web applications with real-time SAP HANA.
-
Visualize ADP Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ADP into TIBCO Spotfire.
-
How to Work with ElevenLabs Data in AWS Glue Jobs Using JDBC
Connect to ElevenLabs from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to SAS Data Sets Data from a Connection Pool in Jetty
The SAS Data Sets JDBC Driver supports connection pooling: This article shows how to connect faster to SAS Data Sets from Web apps in Jetty.
-
Query LaunchDarkly Data in DataGrip
Create a Data Source for LaunchDarkly in DataGrip and use SQL to query live LaunchDarkly.
-
How to Access Live Lakebase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Lakebase enables you to integrate Lakebase into workflows built using Microsoft Power Automate Desktop.
-
Feed Apollo Data into FineReport
How to set Apollo as a JDBC data source in FineReport.
-
Integrating Codex CLI with Pipeliner CRM via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Process & Analyze Datadog Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Datadog Data.
-
How to load Azure Data Catalog data into Elasticsearch via Logstash
Introducing a simple method to load Azure Data Catalog data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with Gong Data in JReport Designer
Create charts and reports based on Gong in JReport Designer.
-
A PostgreSQL Interface for Todoist Data using the CData ODBC Driver
Use the SQL Gateway and Todoist ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Power BI Connector for Exa
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect the Power BI Service to SAS Data Sets: Complete Guide
Connect to the CData Software Power BI Connector for SAS Data Sets from PowerBI.com to provide real-time SAS Data Sets across the organization.
-
Active Directory Reporting in OBIEE with the Active Directory JDBC Driver
Deploy the Active Directory JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Working with Azure Synapse Data in LINQPad
Execute LINQ queries to Azure Synapse in LINQPad.
-
Getting Started with the CData SSIS Components for Salesloft
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesloft.
-
Import and Visualize Suadeo Data in Power View
Create data visualizations based on Suadeo in Excel.
-
Integrate Goose with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live CSV/TSV Files from within the local AI agent.
-
Connect to XML Data from a Connection Pool in Jetty
The XML JDBC Driver supports connection pooling: This article shows how to connect faster to XML Files from Web apps in Jetty.
-
How to connect to SAP Business One Data from Spring Boot
Connect to SAP Business One in a Spring Boot Application using the CData JDBC Driver for SAP Business One
-
Build a Singer.io Tap for Miro With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Miro data using
-
Build Pipelines with Live Vault CRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Vault CRM from Google Cloud Data Fusion, enabling the integration of live Veeva Vault & Vault CRM into the building and management of effective data pipelines.
-
Automated Omnisend Data Replication to Teradata
Use CData Sync to Customize and automate Omnisend replication to Teradata.
-
Use Claude to Talk to Your GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your GraphQL for you.
-
Automated Continuous Pipedrive Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pipedrive replication to Azure SQL Database.
-
Integrate Mailjet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mailjet from Informatica Cloud.
-
Build Charts with ZohoInvoice Data in Clear Analytics
Create dynamic charts and perform analytics based on ZohoInvoice in Clear Analytics.
-
Build a Singer.io Tap for Intercom With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Intercom data using
-
Integrate with Live ADP Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ADP from the MuleSoft Anypoint Platform to integrate live ADP into custom reports and dashboards.
-
Create Phoenix-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Phoenix Data from OutSystems and build custom enterprise apps using live Apache Phoenix.
-
Automated Continuous ADP Replication to MongoDB
Use CData Sync for automated, continuous, customizable ADP replication to MongoDB.
-
Build Amazon DynamoDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amazon DynamoDB and build web apps with connectivity to live Amazon DynamoDB.
-
Use the CData Software JDBC Driver for SharePoint in MicroStrategy Desktop
Connect to Microsoft SharePoint in MicroStrategy Desktop using the CData Software JDBC Driver for SharePoint.
-
Connect SAP Ariba Source Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Ariba Source using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Claude to Talk to Your Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Zoho Creator for you.
-
Getting Started with the CData Power BI Connector for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Authorize.Net-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Authorize.Net Data from OutSystems and build custom enterprise apps using live Authorize.Net.
-
Working with Lakebase Data in LINQPad
Execute LINQ queries to Lakebase in LINQPad.
-
Add Humanity Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Humanity with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Klaviyo Data Replication to Azure Synapse
Use CData Sync to customize and automate Klaviyo replication to Azure Synapse.
-
Visualize PolarTeamPro Data in TIBCO Spotfire through ADO.NET
Integrate PolarTeamPro into dashboards in TIBCO Spotfire.
-
How to Easily Query Microsoft OneDrive Data in OpenOffice Base
Connect to Microsoft OneDrive data in OpenOffice Base using the CData ODBC Driver for Microsoft OneDrive and generate reports with live data insights.
-
How to Connect to & Open Odoo Data in Microsoft Excel
This article uses the CData ODBC driver for Odoo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect and Visualize Live Snapchat Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Snapchat Ads into the Databricks platform and create visualization dashboards with real-time Snapchat Ads.
-
Import GitHub Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access GitHub. In this article, you will use the OData format to import GitHub into Microsoft Power Query.
-
Integrate PostgreSQL Data in the Pentaho Report Designer
Publish reports based on PostgreSQL in the Pentaho BI tool.
-
Query Microsoft Entra ID Data in DataGrip
Create a Data Source for Microsoft Entra ID in DataGrip and use SQL to query live Microsoft Entra ID.
-
Visualize Live Oracle HCM Cloud Data in the Power BI Service
Use CData Connect AI to connect to live Oracle HCM Cloud and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate SAP Data in the Pentaho Report Designer
Publish reports based on SAP ERP/NetWeaver in the Pentaho BI tool.
-
How to create an RPA flow for CloudConvert Data in UiPath Studio
Use the CloudConvert ODBC Driver to create workflows that access real-time CloudConvert without any coding.
-
Prepare, Blend, and Analyze Microsoft Dataverse Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Dataverse (CDS) for self-service data analytics.
-
Connect Jira to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Jira with IBM WebSphere for seamless data integration and connectivity.
-
Back Up Tavily to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Tavily data.
-
Build Data Flows from Sage 300 to SQL Server using SSIS
Easily back up Sage 300 to SQL Server using the SSIS components for Sage 300.
-
Automated Continuous Raisers Edge NXT Replication to MySQL
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to MySQL.
-
Integrate with Sage Intacct Data in JReport Designer
Create charts and reports based on Sage Intacct in JReport Designer.
-
Getting Started with the CData ADO.NET Provider for SparkPost
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live Impala Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Impala from your Excel spreadsheets.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce Marketing Cloud for you.
-
Consume Amazon S3 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Amazon S3 feeds that reflect any changes in SAP Lumira.
-
How to Access Live Dynamics 365 Data in Visual Studio Code via Cline
Run CData MCP Server for Dynamics 365 on Windows Subsytem for Linux (WSL) and connect to live Microsoft Dynamics 365 from the Cline extension in Visual Studio Code.
-
Replicate Multiple Couchbase Accounts
Replicate multiple Couchbase accounts to one or many databases.
-
How to work with OneNote Data in Apache Spark using SQL
Access and process OneNote Data in Apache Spark using the CData Software JDBC Driver.
-
Build Charts with Copper Data in Clear Analytics
Create dynamic charts and perform analytics based on Copper in Clear Analytics.
-
Bidirectional Access to Monday.com Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Monday.com in Filemaker Pro for Mac or Windows.
-
Automated Continuous Coinbase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Coinbase replication to Amazon S3.