CData Software - Knowledge Base
Recent Articles
-
Using ThreadID in CData Driver Logs to Debug Multi-Threaded Operations
Learn how ThreadID appears in CData Driver logs and how to use it for analyzing multi-threaded operations.
-
How to Connect DBeaver to Kintone via a JDBC Driver
Manage Kintone with visual tools in DBeaver like the query browser.
-
Automated Continuous Parquet Replication to Oracle
Use CData Sync for automated, continuous, customizable Parquet replication to Oracle.
-
Use Dash to Build to Web Apps on CSV Data
Create Python applications that use pandas and Dash to build CSV-connected web apps.
-
A PostgreSQL Interface for LDAP Objects (MySQL Remoting via JDBC)
Use the Remoting features of the LDAP JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Facebook
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Facebook.
-
Natively Connect to Outlook Data in PHP
The CData ODBC driver for Outlook enables you to create PHP applications with connectivity to Outlook. Leverage the native support for ODBC in PHP.
-
Feed WordPress Data into FineReport
How to set WordPress as a JDBC data source in FineReport.
-
Use JayDeBeApi to access SAP Business One Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Business One.
-
Moving Data from Anaplan to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Anaplan data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connecting GenSpark with GraphQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to GraphQL without any replication or custom integration required.
-
Automated Continuous TaxJar Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable TaxJar replication to Google Cloud SQL.
-
Automated Continuous Bitbucket Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Bitbucket replication to Amazon Redshift.
-
Use the CData SSIS Components to Insert New or Update Existing Vault CRM Records from SQL Server
Easily push SQL Server data to Vault CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Vault CRM or update existing records with data from a SQL Server database.
-
DataBind NetSuite Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for NetSuite with the DevExpress Windows Forms and Web controls to provide NetSuite CRM & ERP to a chart.
-
Build Square-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Square Data from Zoho Analytics and import live Square.
-
Replicate Mode Data from PowerShell
Write a quick PowerShell script to query Mode. Use connectivity to the live data to replicate Mode to SQL Server.
-
Query MarkLogic Data as a MySQL Database in Node.js
Execute MySQL queries against MarkLogic from Node.js.
-
Integrating SQL Analysis Services Data in Talend Cloud Data Management Platform
Connect SQL Analysis Services Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SQL Analysis Services.
-
How to publish and share Asana Data dashboards with Tableau Server
The CData ODBC driver for Asana enables you integrate Asana into Tableau dashboards.
-
Access Live Rootly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Rootly in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build to Web Apps on Microsoft Planner Data
Create Python applications that use pandas and Dash to build Microsoft Planner-connected web apps.
-
Create Procore-Connected Applications in Appsmith
Connect to Procore Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Procore.
-
Query Amazon DynamoDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon DynamoDB from Node.js.
-
Build a Singer.io Tap for Helpscout With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Helpscout data using
-
Build Sybase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sybase and build visualizations in Tableau Cloud.
-
Use the CData ODBC Driver for Mouseflow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mouseflow to connect to Mouseflow from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mouseflow in Excel.
-
Integrate Anaplan Data in Pentaho Data Integration
Build ETL pipelines based on Anaplan in the Pentaho Data Integration tool.
-
How to use SQLAlchemy ORM to access Active Directory Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Active Directory.
-
Object-Relational Mapping (ORM) with JDBC-ODBC Bridge Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to JDBC-ODBC Bridge into a Java-based ORM framework, Hibernate.
-
Connect Blackbaud FE NXT Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Blackbaud FE NXT using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Gorgias Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Gorgias to connect to Gorgias and execute queries in PowerBuilder.
-
Automated Continuous API Replication to Vertica
Use CData Sync for automated, continuous, customizable API replication to Vertica.
-
Automated Continuous GitHub Replication to MongoDB
Use CData Sync for automated, continuous, customizable GitHub replication to MongoDB.
-
Connect to BenchmarkEmail Data in Aqua Data Studio
Access BenchmarkEmail from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Harvest Data in RazorSQL
Connect to Harvest from wizards and query Harvest from the GUI in the RazorSQL database management tool.
-
Visualize Live BambooHR Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live BambooHR into custom reports in Power BI.
-
Integrating Cursor CLI with Pipeliner CRM Data 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.
-
Connect to Bullhorn CRM Data in RazorSQL
Connect to Bullhorn CRM from wizards and query Bullhorn CRM from the GUI in the RazorSQL database management tool.
-
Query Salesloft Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesloft.
-
Add Scrapfly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Scrapfly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import Real-Time Active Directory Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Active Directory in ColdFusion.
-
Connect to Real-Time ConvertKit Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ConvertKit in Power Apps.
-
Build Sybase-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sybase and build Sybase-connected web apps with Axios.
-
Natively Connect to Amazon Marketplace Data in PHP
The CData ODBC driver for Amazon Marketplace enables you to create PHP applications with connectivity to Amazon Marketplace. Leverage the native support for ODBC in PHP.
-
Build Oracle HCM Cloud-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Oracle HCM Cloud to explore live Oracle HCM Cloud Data in Gemini Code Assist to assist with building Oracle HCM Cloud-powered applications.
-
Visualize Float 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 Float into TIBCO Spotfire.
-
Automate SAP SuccessFactors Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP SuccessFactors replication to Azure Synapse.
-
Connect to Mailjet Data in Ruby
Connect to Mailjet in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to create NetSuite federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for NetSuite CRM & ERP in MySQL .
-
Build Superchat-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Superchat and build web apps with connectivity to live Superchat.
-
How to Work with Google Drive Data in AWS Glue Jobs Using JDBC
Connect to Google Drive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Access Yelp Data Using Entity Framework
This article shows how to access Yelp using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build FHIR-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live FHIR.
-
How to publish and share Strava Data dashboards with Tableau Server
The CData ODBC driver for Strava enables you integrate Strava into Tableau dashboards.
-
Analyze YouTube Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for YouTube Analytics from Power Pivot. You will use the Table Import Wizard to load YouTube Analytics. You can visually build the import query or use any SQL supported by the driver.
-
Replicate Billsby Data from PowerShell
Write a quick PowerShell script to query Billsby. Use connectivity to the live data to replicate Billsby to SQL Server.
-
Creating Freshservice-Connected Applications in Unqork
You can use CData Connect AI to feed Freshservice to Unqork and build custom business apps.
-
Create eBay-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to eBay Data from Klipfolio and build custom visualizations using live eBay.
-
Connect to LinkedIn Ads from Asprova with CData Software ODBC Driver for LinkedIn Ads
This article shows how to connect faster to LinkedIn Ads data from Asprova.
-
Build a PostgreSQL Interface for Elasticsearch Data using the CData JDBC Driver
Use the Remoting features of the Elasticsearch JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Instantly Data in Power BI Report Server
Use the CData ODBC Driver for Instantly to visualize Instantly in Power BI Desktop and then publish them to Power BI Report Server.
-
Natively Connect to Odoo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Odoo ERP. Leverage the native support for ODBC in PHP.
-
Connect to Microsoft Entra ID Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Entra ID in DBeaver.
-
Connect Amazon S3 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon S3 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Grok to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Microsoft Ads for you.
-
How to Query Live SendGrid Data in Claude Desktop
Connect to and query live SendGrid Data in Claude Desktop using CData MCP Server.
-
Choosing the Best Method to Connect Access to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Access from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Amazon DynamoDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating LangGraph with Google Contacts Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Contacts within automated workflows.
-
Access Live Microsoft Dataverse Data in AWS Lambda
Connect to live Microsoft Dataverse (CDS) in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Excel Add-In for Telegram
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Telegram.
-
Getting Started with the CData JDBC Driver for MongoDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MongoDB.
-
How to connect to RabbitMQ Data from IntelliJ
Integrate connectivity to RabbitMQ with wizards in IntelliJ.
-
Create Datasets from Workable in Domo Workbench and Build Visualizations of Workable Data in Domo
Use the CData Software ODBC Driver for Workable to create datasets from Workable in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Google Tasks Data in Ruby
Connect to Google Tasks in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating eBay Data in Talend Cloud Data Management Platform
Connect eBay Data with Talend Cloud Data Management Platform using the CData JDBC Driver for eBay.
-
Use the CData SSIS Components to Insert New or Update Existing SAP SuccessFactors Records from SQL Server
Easily push SQL Server data to SAP SuccessFactors using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP SuccessFactors or update existing records with data from a SQL Server database.
-
Creating Salesforce CRM Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce CRM Analytics to Unqork and build custom business apps.
-
A PostgreSQL Interface for AlloyDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the AlloyDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Aircall-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Aircall.
-
Connect to PayPal Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live PayPal from Filemaker Pro on Mac.
-
How to create an RPA flow for SharePoint Data in UiPath Studio
Use the SharePoint ODBC Driver to create workflows that access real-time Microsoft SharePoint without any coding.
-
PDFMonkey Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PDFMonkey facts in real time.
-
Getting Started with the CData ADO.NET Provider for XML
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for XML.
-
Integrating LangChain with Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Analytics within automated workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for RabbitMQ
Create an ODBC connection to RabbitMQ in Informatica and browse and transfer RabbitMQ.
-
Build Unbounce-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Unbounce.
-
Prepare, Blend, and Analyze Helpscout Data in Alteryx Designer (ODBC)
Build workflows to access live Helpscout for self-service data analytics.
-
Automated Continuous Dynamics 365 Business Central Replication to SQLite
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to SQLite.
-
Automate LeadDesk Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LeadDesk from PowerShell? This article demonstrates how to utilize the LeadDesk Cmdlets for tasks like connecting to LeadDesk, automating operations, downloading data, and more.
-
Getting Started with the CData Excel Add-In for Tally
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tally.
-
How to Connect DBeaver to Unbounce via a JDBC Driver
Manage Unbounce with visual tools in DBeaver like the query browser.
-
Build Semantic Layer Views for Oracle Sales Data in APOS Live Data Gateway
Use the CData Connector for Oracle Sales in APOS Live Data Gateway to build Semantic Layer Views for Oracle Sales.
-
How to Query Demio Data in MySQL Workbench
Execute MySQL queries against live Demio from MySQL Workbench.
-
Create Informatica Mappings From/To an ODBC Data Source for Gmail
Create an ODBC connection to Gmail in Informatica and browse and transfer Gmail.
-
Connect to SAP Concur Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Concur and the SQL Gateway to access SAP Concur from Google Apps Script.
-
Ontraport Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Ontraport facts in real time.
-
Build Semantic Layer Views for Twilio Data in APOS Live Data Gateway
Use the CData Connector for Twilio in APOS Live Data Gateway to build Semantic Layer Views for Twilio.
-
Import Real-Time Outlook Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Outlook in ColdFusion.