CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Connect AI Python SDK for MailChimp
Install the CData Connect AI Python SDK to read and write live MailChimp data with standard DB-API 2.0 Python code.
-
Migrating data from Jumpseller to Snowflake using CData SSIS Components.
Easily push Jumpseller data to Snowflake using the CData SSIS Tasks for Jumpseller and Snowflake.
-
How to integrate Metabase with Blackbaud FE NXT Data
Use CData Connect AI to connect to live Blackbaud FE NXT data and create an interactive dashboard in Metabase from Blackbaud FE NXT data.
-
Build Charts with SendInBlue Data in Clear Analytics
Create dynamic charts and perform analytics based on SendInBlue data in Clear Analytics.
-
Automate Azure Data Catalog Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Data Catalog data replication to Couchbase.
-
Connect to EmailOctopus from Asprova with CData Software ODBC Driver for EmailOctopus
This article shows how to connect faster to EmailOctopus data from Asprova.
-
Connect to CockroachDB Data from AWS Glue
Use CData Connect AI to gain access to live CockroachDB data from your AWS Glue jobs.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce Marketing
Create Salesforce Marketing data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Google Drive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Drive to connect to Google Drive data from Web applications running on WebLogic.
-
Query Google Drive Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Drive entities in PHP by modeling them as objects.
-
How to Build an ETL App for ClickUp Data in Python with CData
Create ETL applications and real-time data pipelines for ClickUp data in Python with petl.
-
Replicate MongoDB Data in Heroku for Use in Salesforce Connect
Replicate MongoDB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Boomi Agentstudio with Google Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Ads data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Operational Reporting on YouTube Analytics Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote YouTube Analytics data.
-
Link CampaignMonitor with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate CampaignMonitor data in Filemaker Pro for Mac or Windows.
-
Connect to Pingdom Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pingdom data using standard SQL.
-
Establish a Live Connection with HDFS Data using Tableau Bridge
The CData ODBC Driver for HDFS enables you to integrate live HDFS data into Tableau Cloud dashboards using the Tableau Bridge.
-
Prepare, Blend, and Analyze CockroachDB Data in Alteryx Designer (Connect AI)
Build workflows to access live CockroachDB data for self-service data analytics.
-
Access Live Databricks Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Databricks data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software ODBC Driver for Adobe Experience Manager in MicroStrategy Desktop
Connect to Adobe Experience Manager data in MicroStrategy Desktop using the CData Software ODBC Driver for Adobe Experience Manager.
-
How to connect to Twitter Ads Data from Spring Boot
Connect to Twitter Ads in a Spring Boot Application using the CData JDBC Driver for Twitter Ads
-
Integrate Trae with Live Adobe Target Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Adobe Target data from within the AI-powered IDE.
-
How to use SQLAlchemy ORM to access Mailjet Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mailjet data.
-
Use Biml to Build SSIS Tasks to Replicate Google Drive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Drive data to SQL Server.
-
Automate Jodoo Data Replication to SAP HANA
Use CData Sync to customize and automate Jodoo data replication to SAP HANA.
-
Build Data Flows from SQL Server to PostgreSQL through SSIS
Easily push SQL Server data to PostgreSQL using the CData SSIS Tasks for PostgreSQL.
-
Publish Reports with GitHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitHub data.
-
Visualize Pinterest Data in Tableau
The CData ODBC driver for Pinterest enables you integrate Pinterest data into Tableau dashboards.
-
Create MongoDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MongoDB Data from Klipfolio and build custom visualizations using live MongoDB data.
-
Automate Cvent Data Replication to Azure Data Lake
Use CData Sync to customize and automate Cvent data replication to Azure Data Lake.
-
Integrate with Egnyte Data in JReport Designer
Create charts and reports based on Egnyte data in JReport Designer.
-
Create SSAS Tabular Models from Freshservice Data
How to build a SQL Server Analysis Service Tabular Model from Freshservice data using CData drivers.
-
DataBind Charts to Google Drive Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Drive data 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.
-
Easily Integrate Reckon Accounts Hosted Data in Lazarus Pascal IDE
Learn how to easily integrate live Reckon Accounts Hosted data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to publish and share IBM Informix Data dashboards with Tableau Server
The CData ODBC driver for IBM Informix enables you integrate IBM Informix data into Tableau dashboards.
-
Integrate OpenCode with Live Okta Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Okta data from within your AI coding agent.
-
Automated Parallel Data Replication to Teradata
Use CData Sync to Customize and automate Parallel data replication to Teradata.
-
ScrapingBee Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ScrapingBee facts in real time.
-
Build a Singer.io Tap for Printful With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Printful data using the CData Python Connector.
-
Create a Data Access Object for Clari Data using JDBI
A brief overview of creating a SQL Object API for Clari data in JDBI.
-
Query Live Hive Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Hive data directly from the development environment.
-
Design BIRT Reports on HBase Data
Provide current HBase data to your embedded analytics.
-
Automate PolarTeamPro Data Replication to Couchbase
Use CData Sync to Customize and automate PolarTeamPro data replication to Couchbase.
-
Use ChatGPT to Talk to Your CouchDB 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 CouchDB data for you.
-
Getting Started with the CData SSIS Components for SAS xpt
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAS xpt.
-
Connect to Zoho Books Data in RazorSQL
Connect to Zoho Books from wizards and query Zoho Books data from the GUI in the RazorSQL database management tool.
-
How to Connect to Live LDAP Objects from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your LDAP objects for you.
-
Query Auth0 Data in DataGrip
Create a Data Source for Auth0 in DataGrip and use SQL to query live Auth0 data.
-
Build MVC Applications with Connectivity to MarkLogic Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MarkLogic from an ASP.NET MVC application.
-
Connect to Sybase IQ from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sybase IQ to connect to Sybase IQ data from Web applications running on WebLogic.
-
Migrating data from SAP BusinessObjects BI to Databricks using CData SSIS Components.
Easily push SAP BusinessObjects BI data to Databricks using the CData SSIS Tasks for SAP BusinessObjects BI and Databricks.
-
Build AI/ML Models with Live Quaderno Data using Dataiku
Connect Quaderno Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Confluence Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Confluence data using standard SQL.
-
Access Confluence Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Confluence data from your Oracle system.
-
Connect to EmailOctopus Data from a Connection Pool in Jetty
The EmailOctopus JDBC Driver supports connection pooling: This article shows how to connect faster to EmailOctopus data from Web apps in Jetty.
-
Connect to Paymo Data in CloverDX (formerly CloverETL)
Transfer Paymo data using the visual workflow in the CloverDX data integration tool.
-
Bind Live SAP Netweaver Gateway Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Netweaver Gateway data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connecting Moonlit Workflow with HDFS Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your HDFS data in real time.
-
Automated Continuous Sage Cloud Accounting Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to SingleStore.
-
Create Apollo-Connected Applications in Appsmith
Connect to Apollo Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Apollo data.
-
How to Work with ShipEngine Data in ETL Validator JDBC
Connect to ShipEngine from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Harvest Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Harvest replication to Amazon S3.
-
Access Live Eventbrite Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Eventbrite data into the statistical analysis tools available in SAS JMP. This article shows how to use Eventbrite data in the Graph Builder and Query Builder.
-
Build GraphQL-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for GraphQL Data and create custom apps in Mendix.
-
Build a Simple VCL Application for Oracle Data
How to build a simple VCL Application to view Oracle data in RAD Studio using the CData ODBC Driver for Oracle.
-
Automated Google Sheets Data Replication to Teradata
Use CData Sync to Customize and automate Google Sheets data replication to Teradata.
-
Use Biml to Build SSIS Tasks to Replicate Parquet Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Parquet data to SQL Server.
-
Connect to Salesloft Data in Jaspersoft Studio
Execute SQL to remote Salesloft data in Jaspersoft Studio.
-
Creating Monday.com-Connected Applications in Unqork
You can use CData Connect AI to feed Monday.com data to Unqork and build custom business apps.
-
How to Query SAP Hybris C4C Data in MySQL Workbench
Execute MySQL queries against live SAP Hybris C4C data from MySQL Workbench.
-
Access Live Microsoft Dataverse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Dataverse data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Hacker News Replication to SQL Server
Use CData Sync for automated, continuous, customizable Hacker News replication to SQL Server.
-
Access Telegram Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Telegram data from your Oracle system.
-
Getting Started with the CData Python Connector for QuickBooks Online
Learn to install and license the CData Python Connector and configure a connection to live QuickBooks Online data.
-
Connect to Pinecone Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pinecone and the SQL Gateway to access Pinecone data from Google Apps Script.
-
Query SendGrid Data in ColdFusion
Write standard ColdFusion data access code to connect to SendGrid data.
-
Getting Started with the CData ODBC Driver for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Inventory.
-
Getting Started with the CData ADO.NET Provider for LeadDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect Mailgun Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Mailgun data in real time using natural language.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SharePoint Excel Services
Provide connectivity to SharePoint Excel Services data through an SAP BusinessObjects universe.
-
How to Connect to Live Coda Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Coda data for you.
-
Connect to Oracle Financials Cloud Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Financials Cloud as an External Source in Dremio.
-
View Reports on Real-Time Azure Analysis Services Data in Power BI Report Server
Use the CData ODBC Driver for Azure Analysis Services to visualize Azure Analysis Services data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect and Visualize Live Greenhouse Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Greenhouse data into the Databricks platform and create visualization dashboards with real-time Greenhouse data.
-
Access Live FHIR Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live FHIR data through MCP integration.
-
Bridge Confluence Connectivity with Apache NiFi
Access and process Confluence data in Apache NiFi using the CData JDBC Driver.
-
ETL ActiveCampaign in Oracle Data Integrator
This article shows how to transfer ActiveCampaign data into a data warehouse using Oracle Data Integrator.
-
How to connect PolyBase to Dropbox
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dropbox data.
-
Integrate Devin with Live SparkPost Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SparkPost data.
-
Create Dynamic ConstantContact Grids Using the Infragistics XamDataGrid
Learn how you can connect ConstantContact to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Office 365 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 Office 365 data into TIBCO Spotfire.
-
Create Reports from Yelp Data in Looker Studio
Use CData Connect AI to gain access to live Yelp data and create custom reports in Looker Studio.
-
Connecting Agentforce with SAS Data Sets Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAS Data Sets data for you.
-
Model, Search, and Visualize Live Azure Data Lake Storage Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Data Lake Storage data for modeling, searching, and visualizing.
-
Build AI Agents with Google Sheets Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Google Sheets data through CData Connect AI.
-
Integrating Codex with Act 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.
-
Replicate Everhour Data to Multiple Databases
Replicate Everhour data to disparate databases with a point-and-click configuration.
-
Use the CData ODBC Driver for HelloSign from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HelloSign to connect to HelloSign data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HelloSign data in Excel.
-
Access Live Optimizely Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Optimizely data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Google Calendar Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to PostgreSQL.