CData Software - Knowledge Base
Recent Articles
-
Build Zoho CRM-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Zoho CRM to explore live Zoho CRM Data in Cursor to assist with building Zoho CRM-powered applications.
-
How to Access Live Certinia Data in Visual Studio Code via Cline
Run CData MCP Server for Certinia on Windows Subsytem for Linux (WSL) and connect to live Certinia from the Cline extension in Visual Studio Code.
-
Access Facebook Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Facebook from HeidiSQL.
-
Consume Teradata OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Teradata feeds that reflect any changes in SAP Lumira.
-
A PostgreSQL Interface for Discord Data using the CData ODBC Driver
Use the SQL Gateway and Discord ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Workflows with Live CouchDB Data in Workato
Use CData Connect AI to connect to live Apache CouchDB and build automated workflows in Workato.
-
Connect to Live GitLab Data in PostGresSQL Interface through CData Connect AI
Create a live connection to GitLab in CData Connect AI and connect to your GitLab from PostgreSQL.
-
Integrate Deel with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Deel with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Deel.
-
Use ChatGPT to Talk to Your Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.
-
Model, Search, and Visualize Live Instagram Data in ThoughtSpot
Use CData Connect AI to connect to live Instagram for modeling, searching, and visualizing.
-
Connect to Couchbase Data from a Connection Pool in JBoss
Integrate Couchbase into Java servlets: Use the Management Console in JBoss to install the Couchbase JDBC Driver.
-
Integrate with FreshBooks Data in JReport Designer
Create charts and reports based on FreshBooks in JReport Designer.
-
Visualize Live Teamwork Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Teamwork using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Google Cloud Storage Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Cloud Storage in the Denodo Virtual DataPort Administrator.
-
Migrating data from ServiceDesk Plus to Snowflake using CData SSIS Components.
Easily push ServiceDesk Plus to Snowflake using the CData SSIS Tasks for ServiceDesk Plus and Snowflake.
-
Automated Continuous EnterpriseDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Amazon Redshift.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Eventbrite
Provide connectivity to Eventbrite through an SAP BusinessObjects universe.
-
How to connect SharePoint with Microsoft Entra ID Data through external lists
Provide Microsoft Entra ID to SharePoint users as an external list.
-
DataBind Charts to Figshare Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Figshare 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 Pingdom Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pingdom replication to delimited files (CSV/TSV).
-
Build Data Flows from Dotmailer to SQL Server using SSIS
Easily back up Dotmailer to SQL Server using the SSIS components for Dotmailer.
-
Getting Started with the CData JDBC Driver for Front
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Front.
-
How to Access Microsoft Planner Data Using Entity Framework
This article shows how to access Microsoft Planner using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live SharePoint Data in AWS Lambda
Connect to live Microsoft SharePoint in AWS Lambda using the CData JDBC Driver.
-
Integrating Gumloop with EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on EnterpriseDB within automated workflows.
-
How to integrate Amazon Marketplace with Apache Airflow
Access and process Amazon Marketplace in Apache Airflow using the CData JDBC Driver.
-
Build Google Ad Manager-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Ad Manager to explore live Google Ad Manager Data in Gemini Code Assist to assist with building Google Ad Manager-powered applications.
-
Connect CloudConvert Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CloudConvert using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Wistia Data to Multiple Databases via the CData Sync CLI
Replicate Wistia to disparate databases with a single configuration.
-
Connect to Phoenix Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Phoenix Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to ShipEngine Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ShipEngine and work with ShipEngine in your FileMaker application.
-
Create Informatica Mappings From/To an ODBC Data Source for Facebook Ads
Create an ODBC connection to Facebook Ads in Informatica and browse and transfer Facebook Ads.
-
Automated Continuous CouchDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CouchDB replication to Google Cloud SQL.
-
Getting Started with the CData ODBC Driver for Auth0
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Auth0.
-
Connect to Autopilot Data in CloverDX (formerly CloverETL)
Transfer Autopilot using the visual workflow in the CloverDX data integration tool.
-
Import Real-Time RabbitMQ Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use RabbitMQ in ColdFusion.
-
Integrate OData Services in Pentaho Data Integration
Build ETL pipelines based on OData in the Pentaho Data Integration tool.
-
Replicate Certinia Data to Multiple Databases via the CData Sync CLI
Replicate Certinia to disparate databases with a single configuration.
-
Automate FTP Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live FTP Servers and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData ODBC Driver for Webex in Microsoft Power Query
You can use the CData Webex ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Webex into Microsoft Power Query.
-
Integrate Goose with Live GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live GraphQL from within the local AI agent.
-
Query Splunk Data in DataGrip
Create a Data Source for Splunk in DataGrip and use SQL to query live Splunk.
-
Build AI/ML Models with Live Adobe Experience Manager Data using Dataiku
Connect Adobe Experience Manager Data with Dataiku using the CData JDBC Driver for Adobe Experience Manager.
-
Use the CData ODBC Driver for SendInBlue from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SendInBlue to connect to SendInBlue from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SendInBlue in Excel.
-
How to Connect DBeaver to SAP HANA via a JDBC Driver
Manage SAP HANA with visual tools in DBeaver like the query browser.
-
Connect to ActiveCampaign Data in Ruby
Connect to ActiveCampaign in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Import SAP Ariba Procurement Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Ariba Procurement Data from Azure Data Factory and import live SAP Ariba Procurement.
-
Automated Continuous JotForm Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable JotForm replication to Amazon Redshift.
-
Automated Continuous TaxJar Replication to AlloyDB
Use CData Sync for automated, continuous, customizable TaxJar replication to AlloyDB.
-
How to Build an ETL App for Exact Online Data in Python with CData Connect AI
Build ETL pipelines that read and write live Exact Online in Python with petl and the CData Connect AI Python SDK.
-
Import QuickBooks Online Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access QuickBooks Online. In this article, you will use the OData format to import QuickBooks Online into Microsoft Power Query.
-
Integrate Goose with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Apache Phoenix from within the local AI agent.
-
Connect to HelloSign Data in CloverDX (formerly CloverETL)
Transfer HelloSign using the visual workflow in the CloverDX data integration tool.
-
Automate Eventbrite Data Replication to Azure Synapse
Use CData Sync to customize and automate Eventbrite replication to Azure Synapse.
-
Consume Microsoft Teams OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Teams as OData feeds from PowerBuilder using the API Server.
-
Connect to Real-Time Wistia Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Wistia in Power Apps.
-
How to Connect DBeaver to Coda via a JDBC Driver
Manage Coda with visual tools in DBeaver like the query browser.
-
How to Connect Couchbase 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 Couchbase data in real time using natural language.
-
How to Connect to Live Microsoft OneDrive Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft OneDrive through natural language.
-
Create Cloudant-Connected Business Apps in AppSheet
Connect to Cloudant Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to IBM Cloudant.
-
Enable the Google Cloud Storage JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Cloud Storage.
-
Redshift Reporting in OBIEE with the Redshift JDBC Driver
Deploy the Redshift JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
A PostgreSQL Interface for Azure Synapse Data (MySQL Remoting via JDBC)
Use the Remoting features of the Azure Synapse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Consume Dynamics CRM OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Dynamics CRM as OData feeds from PowerBuilder using the API Server.
-
Use Dash to Build to Web Apps on Salesloft Data
Create Python applications that use pandas and Dash to build Salesloft-connected web apps.
-
DataBind Controls to BenchmarkEmail Data in C++Builder
DataBind to BenchmarkEmail in C++Builder with standard components and controls.
-
Access Customer.io Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Customer.io.
-
Integrate Live Bitbucket Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Bitbucket to Blue Prism using the CData ODBC Driver for Bitbucket to create automated workflows for repetitive business tasks.
-
How to Import Data from NetSuite into Google Sheets
Import NetSuite CRM & ERP into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous Supabase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Supabase replication to Azure SQL Database.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Teradata
Provide connectivity to Teradata through an SAP BusinessObjects universe.
-
Add FTP Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for FTP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build SAP BusinessObjects BI Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP BusinessObjects BI and build visualizations in Tableau Cloud.
-
Use the CData ODBC Driver for Blackbaud FE NXT in Microsoft Power Query
You can use the CData Blackbaud FE NXT ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Blackbaud FE NXT into Microsoft Power Query.
-
Import Marketo Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Marketo Data and provide access to live Marketo for custom reports in the Power BI Service.
-
Validate Sybase IQ Data with QuerySurge
Access and validate Sybase IQ in QuerySurge using the CData JDBC Driver.
-
Create Chargebee Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Chargebee from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Twilio Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Twilio from your Excel spreadsheets.
-
Use the CData Software JDBC Driver for SAP in MicroStrategy Web
Connect to SAP ERP/NetWeaver in MicroStrategy Web using the CData Software JDBC Driver for SAP.
-
How to Connect to SAS xpt Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAS XPORT. Leverage the pyodbc module for ODBC in Python.
-
Visualize SpaceX Data in TIBCO Spotfire through ADO.NET
Integrate SpaceX into dashboards in TIBCO Spotfire.
-
Build Adobe Commerce-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Adobe Commerce to explore live Adobe Commerce Data in Cursor to assist with building Adobe Commerce-powered applications.
-
How to Visualize Clockify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Clockify in Python.
-
Design BIRT Reports on Samanage Data
Provide current Samanage to your embedded analytics.
-
How to use SQLAlchemy ORM to access NetSuite Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of NetSuite CRM & ERP.
-
Enable the FTP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with FTP Servers.
-
How to Connect to CloudConvert Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CloudConvert. Leverage the pyodbc module for ODBC in Python.
-
DataBind Charts to YouTube Analytics Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to YouTube Analytics 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.
-
Building Dynamic Web Pages with Oracle Financials Cloud Data Using AngularJS
Create single-page applications with live connectivity to Oracle Financials Cloud using the CData API Server.
-
Publish Crystal Reports on Kafka Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Kafka.
-
Connect to Bannerbear Data in Jaspersoft Studio
Execute SQL to remote Bannerbear in Jaspersoft Studio.
-
Use Dash to Build to Web Apps on Unbounce Data
Create Python applications that use pandas and Dash to build Unbounce-connected web apps.
-
Integrate Real-Time Access to Zoho Books in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho Books in real time.
-
Prepare, Blend, and Analyze Office 365 Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Office 365 for self-service data analytics.
-
Connect and Visualize Live QuickBooks Time Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live QuickBooks Time into the Databricks platform and create visualization dashboards with real-time QuickBooks Time.
-
Connect to Shortcut Data in DBeaver
Use the CData ODBC Driver to connect to Shortcut in DBeaver.
-
Publish iContact-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live iContact.
-
Connect to GetResponse from Asprova with CData Software ODBC Driver for GetResponse
This article shows how to connect faster to GetResponse data from Asprova.
-
How to connect to Stripe Data from Spring Boot
Connect to Stripe in a Spring Boot Application using the CData JDBC Driver for Stripe
-
Build HCL Domino-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for HCL Domino to explore live HCL Domino Data in Cursor to assist with building HCL Domino-powered applications.