CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Okta Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Okta without replication.
-
How to Easily Query Facebook Data in OpenOffice Base
Connect to Facebook data in OpenOffice Base using the CData ODBC Driver for Facebook and generate reports with live data insights.
-
Visualize Planio Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Planio.
-
Integrate Suadeo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Suadeo from Informatica Cloud.
-
Automate Planio Data Replication to Azure Synapse
Use CData Sync to customize and automate Planio replication to Azure Synapse.
-
Query Facebook Data in ColdFusion
Write standard ColdFusion data access code to connect to Facebook.
-
Publish Sage Intacct-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage Intacct.
-
How to Connect to Recurly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Recurly. Leverage the pyodbc module for ODBC in Python.
-
Working with Jira Assets Data in LINQPad
Execute LINQ queries to Jira Assets in LINQPad.
-
Query WooCommerce Data as a SQL Server Database in Node.js
Execute SQL Server queries against WooCommerce from Node.js.
-
Use the CData ODBC Driver for Auth0 in Microsoft Power Query
You can use the CData Auth0 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Auth0 into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Copper in MicroStrategy Web
Connect to Copper in MicroStrategy Web using the CData Software ODBC Driver for Copper.
-
Integrating Claude Code CLI with Google Contacts 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.
-
Getting Started with the CData ODBC Driver for Anaplan
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Anaplan.
-
Automated Continuous BenchmarkEmail Replication to Snowflake
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Snowflake.
-
How to connect and process Microsoft Exchange from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Exchange.
-
Trigger Greenplum IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Greenplum with standard wizards in Logic Apps.
-
Getting Started with the CData Power BI Connector for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Apps from Google Contacts Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Contacts Data and build apps from live Google Contacts in Qlik Sense Cloud.
-
Getting Started with the CData Excel Add-In for Box
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Box.
-
Integrate Zoho Projects with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Projects with External Services.
-
Use the CData Software JDBC Driver for Oracle Sales in MicroStrategy Desktop
Connect to Oracle Sales in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle Sales.
-
Automated Continuous Databricks Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Databricks replication to Apache Cassandra.
-
Connect to Sendwithus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Sendwithus and work with Sendwithus in your FileMaker applications.
-
Build Oracle HCM Cloud-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle HCM Cloud and build Oracle HCM Cloud-connected web apps with Axios.
-
DataBind Charts to Factorial Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Factorial 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Reckon
Provide connectivity to Reckon through an SAP BusinessObjects universe.
-
Connect to Cohere from a Connection Pool in WebLogic
Use the CData JDBC Driver for Cohere to connect to Cohere from Web applications running on WebLogic.
-
How to connect PolyBase to Rootly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Rootly.
-
Access HubSpot Data from MySQL in PHP
Connect to HubSpot through the standard MySQL libraries in PHP.
-
Integrate Live Authorize.Net Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Authorize.Net to Blue Prism using the CData ODBC Driver for Authorize.Net to create automated workflows for repetitive business tasks.
-
Connect to Live SAP Concur Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Concur in CData Connect AI and connect to your SAP Concur from PostgreSQL.
-
Use the CData ODBC Driver for Avro in Microsoft Power Query
You can use the CData Avro ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Avro into Microsoft Power Query.
-
Load Act CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Act CRM to a database.
-
Build Visualizations of ADP Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ADP in Birst.
-
Excel Spreadsheet Automation on Drift Data with the QUERY Formula
Pull data from Drift, automate spreadsheets, and more with the QUERY formula.
-
Connect to ADP Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ADP in the Denodo Virtual DataPort Administrator.
-
Write a Simple Go Application to work with PolarTeamPro Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PolarTeamPro.
-
Build Pinterest-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Pinterest to explore live Pinterest Data in Claude Code to assist with building Pinterest-powered applications.
-
Integrating Claude Code CLI with ActiveCampaign 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.
-
Build Dashboards with ZohoInvoice Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoInvoice in DBxtra.
-
How to integrate Aweber with Apache Airflow
Access and process Aweber in Apache Airflow using the CData JDBC Driver.
-
Easily Integrate Dynamics NAV Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Dynamics NAV in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate CampaignMonitor with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CampaignMonitor with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CampaignMonitor.
-
How to use SQLAlchemy ORM to access Jodoo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Jodoo.
-
Connect to Humanity Data in RazorSQL
Connect to Humanity from wizards and query Humanity from the GUI in the RazorSQL database management tool.
-
How to integrate Mode with Apache Airflow
Access and process Mode in Apache Airflow using the CData JDBC Driver.
-
How to Design SAP Business One Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SAP Business One from mobile and tablet Power Apps.
-
Replicate Vault CRM Data to Multiple Databases
Replicate Veeva Vault & Vault CRM to disparate databases with a point-and-click configuration.
-
Build Voice Agents in ElevenLabs with access to Live FTP Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live FTP Servers.
-
A PostgreSQL Interface for Adobe Target Data (MySQL Remoting via JDBC)
Use the Remoting features of the Adobe Target JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP SuccessFactors Data in DBArtisan
Use wizards in DBArtisan to configure SAP SuccessFactors as a data source.
-
Migrating data from Sage Intacct to Snowflake using CData SSIS Components.
Easily push Sage Intacct to Snowflake using the CData SSIS Tasks for Sage Intacct and Snowflake.
-
Build Greenhouse-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Greenhouse Data from Zoho Analytics and import live Greenhouse.
-
Deploy the ADO.NET Provider for Insightly on an SSRS Report Server
Connect to Insightly from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to SendGrid Data in Jaspersoft Studio
Execute SQL to remote SendGrid in Jaspersoft Studio.
-
Use the CData Software JDBC Driver for MessageBird in MicroStrategy Web
Connect to MessageBird in MicroStrategy Web using the CData Software JDBC Driver for MessageBird.
-
Connect to MarkLogic Data from PowerBuilder via ADO.NET
This article demonstrates how to access MarkLogic from Appeon PowerBuilder using the CData ADO.NET Provider for MarkLogic.
-
Connect to Act CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Act CRM from HeidiSQL.
-
Use the CData SSIS Components to Insert New or Update Existing SuiteCRM Records from SQL Server
Easily push SQL Server data to SuiteCRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SuiteCRM or update existing records with data from a SQL Server database.
-
Automated Continuous Google Directory Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Directory replication to MongoDB.
-
Natively Connect to PivotalTracker Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PivotalTracker. Leverage the native support for ODBC in PHP.
-
Connect to and Visualize Live Xero Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Xero Accounting.
-
Create Informatica Mappings From/To an ODBC Data Source for PDFMonkey
Create an ODBC connection to PDFMonkey in Informatica and browse and transfer PDFMonkey.
-
Connect and Visualize Live Google Directory Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Directory into the Databricks platform and create visualization dashboards with real-time Google Directory.
-
How to Connect DBeaver to Pipeline CRM via a JDBC Driver
Manage Pipeline CRM with visual tools in DBeaver like the query browser.
-
Integrating Cursor CLI with Notion 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 Epicor Kinetic Data from a Connection Pool in JBoss
Integrate Epicor Kinetic into Java servlets: Use the Management Console in JBoss to install the Epicor Kinetic JDBC Driver.
-
Connect to Unbounce Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Unbounce to connect to Unbounce and execute queries in PowerBuilder.
-
Import Lakebase Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Lakebase. In this article, you will use the OData format to import Lakebase into Microsoft Power Query.
-
Use Dash to Build to Web Apps on SparkPost Data
Create Python applications that use pandas and Dash to build SparkPost-connected web apps.
-
Query Zoho Projects Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho Projects entities in PHP by modeling them as objects.
-
Process & Analyze Freshdesk Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Freshdesk Data.
-
Analyze Pipedrive Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pipedrive with the CData JDBC Driver for Pipedrive.
-
Connect Calendly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Calendly using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to PostgreSQL Data from PowerBuilder via ADO.NET
This article demonstrates how to access PostgreSQL from Appeon PowerBuilder using the CData ADO.NET Provider for PostgreSQL.
-
Visualize Pipeliner CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Pipeliner CRM.
-
Automate Reply.io Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Reply.io from PowerShell? This article demonstrates how to utilize the Reply.io Cmdlets for tasks like connecting to Reply.io, automating operations, downloading data, and more.
-
Access Live Oracle HCM Cloud Data in Excel 365 Online (Excel for the web)
Connect to Oracle HCM Cloud from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access OnePageCrm Data from MySQL in Amazon QuickSight
Connect to OnePageCrm and build visualizations of OnePageCrm using a MySQL Connection in Amazon QuickSight.
-
ChartMogul Reporting in OBIEE with the ChartMogul JDBC Driver
Deploy the ChartMogul JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Onfleet Data in Jaspersoft Studio
Execute SQL to remote Onfleet in Jaspersoft Studio.
-
Choosing the Best Method to Connect Codat to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Codat from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating LangGraph with DocuSign Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on DocuSign within automated workflows.
-
Migrating data from Jira to Databricks using CData SSIS Components.
Easily push Atlassian Jira to Databricks using the CData SSIS Tasks for Jira and Databricks.
-
Connect to CockroachDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CockroachDB and the SQL Gateway to access CockroachDB from Google Apps Script.
-
Using the CData Software ODBC Driver for Accelo in PyCharm
Connect to Accelo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Accelo.
-
Stream Tally Data into Apache Kafka Topics
Access and stream Tally ERP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate SAS xpt Data in Heroku for Use in Salesforce Connect
Replicate SAS XPORT to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Live SAP Fieldglass Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Fieldglass using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apps with Live Zoho Books Data Using the Low-Code Development Platform of Mendix
Connect Zoho Books with Mendix to build apps using the CData JDBC Driver for Zoho Books.
-
Use ChatGPT to Talk to Your BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your BambooHR for you.
-
How to Create Power BI Visual Reports with Real-Time Google Ad Manager Data
Use CData Power BI Connectors to visualize Google Ad Manager in Power BI.
-
Natively Connect to RSS Feeds in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to RSS Feeds. Leverage the native support for ODBC in PHP.
-
How to Easily Query SAP Ariba Procurement Data in OpenOffice Base
Connect to SAP Ariba Procurement data in OpenOffice Base using the CData ODBC Driver for SAP Ariba Procurement and generate reports with live data insights.
-
Import Real-Time Hubstaff Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Hubstaff in ColdFusion.
-
Connect to Confluence Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Confluence Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Query Live Teamgate Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Teamgate data in natural language using Python.
-
Connect to SurveyMonkey Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SurveyMonkey in the Denodo Virtual DataPort Administrator.
-
Rapidly Develop Snowflake-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Snowflake.