CData Software - Knowledge Base
Recent Articles
-
Integrate BigQuery with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BigQuery with External Services.
-
Object-Relational Mapping (ORM) with Front 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 Front data into a Java-based ORM framework, Hibernate.
-
Connect to Humanity Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Humanity data using standard SQL.
-
How to Access Google Directory Data Using Entity Framework
This article shows how to access Google Directory data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live BigCommerce 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 BigCommerce data through MCP integration.
-
How to create Zoho CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho CRM data in MySQL .
-
Analyze Adobe Target Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Adobe Target data and visualize live Adobe Target data in Infragistics Reveal.
-
Analyze Live ConstantContact Data in SAS Viya
Use CData Connect AI to connect to ConstantContact data from SAS Viya and deploy self-service analytics using live ConstantContact data.
-
Visualize Live GitHub Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live GitHub data into custom reports in Power BI.
-
ETL Discourse in Oracle Data Integrator
This article shows how to transfer Discourse data into a data warehouse using Oracle Data Integrator.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Sales Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Sales data to SQL Server.
-
Connect to and Visualize Live AfterShip Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live AfterShip data.
-
Automated Continuous OpenWeatherMap Replication to SQL Server
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to SQL Server.
-
Analyze BenchmarkEmail Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze BenchmarkEmail data with the CData JDBC Driver for BenchmarkEmail.
-
Build Apps with Live Snapchat Ads Data Using the Low-Code Development Platform of Mendix
Connect Snapchat Ads data with Mendix to build apps using the CData JDBC Driver for Snapchat Ads.
-
Integrate Google Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Analytics data.
-
Integrate Live Mailjet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mailjet data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Bitbucket Data in CloverDX (formerly CloverETL)
Transfer Bitbucket data using the visual workflow in the CloverDX data integration tool.
-
Replicate Asana Data to Multiple Databases
Replicate Asana data to disparate databases with a point-and-click configuration.
-
Bind Live Freshdesk Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Freshdesk data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho CRM
Provide connectivity to Zoho CRM data through an SAP BusinessObjects universe.
-
Integrate with ConvertAPI Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ConvertAPI data to a JSON file on disk.
-
Connect to Exact Online Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Exact Online as an External Source in Dremio.
-
Automated Continuous Amazon Athena Replication to MongoDB
Use CData Sync for automated, continuous, customizable Amazon Athena replication to MongoDB.
-
Bridge Zoho Creator Connectivity with Apache NiFi
Access and process Zoho Creator data in Apache NiFi using the CData JDBC Driver.
-
Enable the Cvent JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Cvent data.
-
Build Airtable-Connected Apps in Choreo
Use CData Connect AI to connect to Airtable Data from Choreo and build custom apps using live Airtable data.
-
Automate SAP SuccessFactors Data Replication to SAP HANA
Use CData Sync to customize and automate SAP SuccessFactors data replication to SAP HANA.
-
Interact with Live Raisers Edge NXT Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Raisers Edge NXT data.
-
Integrating Dataiku with Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Ads data.
-
Create Reports with Basecamp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Basecamp data.
-
Automated Continuous Smartsheet Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Smartsheet replication to PostgreSQL.
-
Use the CData Software JDBC Driver for Freshservice in MicroStrategy Web
Connect to Freshservice data in MicroStrategy Web using the CData Software JDBC Driver for Freshservice.
-
Connect to Campaigner Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Campaigner data.
-
Connect to Gumroad Data in RazorSQL
Connect to Gumroad from wizards and query Gumroad data from the GUI in the RazorSQL database management tool.
-
Automated Continuous WordPress Replication to SingleStore
Use CData Sync for automated, continuous, customizable WordPress replication to SingleStore.
-
How to integrate Oracle HCM Cloud with Apache Airflow
Access and process Oracle HCM Cloud data in Apache Airflow using the CData JDBC Driver.
-
Visualize GetResponse Data in Tableau
The CData ODBC driver for GetResponse enables you integrate GetResponse data into Tableau dashboards.
-
How to Connect to Live Timely 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 Timely data for you.
-
Automated Continuous ClickTime Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ClickTime replication to Apache Cassandra.
-
Automated Continuous Google Translate Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Translate replication to SQLite.
-
LINQ to ZarMoney Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the ZarMoney Data Provider.
-
How to Create Power BI Visual Reports with Real-Time Google Campaign Manager 360 Data
Use CData Power BI Connectors to visualize Google Campaign Manager 360 data in Power BI.
-
Analyze Greenplum Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Greenplum data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Visualize Lakebase Data in Tableau
The CData ODBC driver for Lakebase enables you integrate Lakebase data into Tableau dashboards.
-
Automate DB2 for i Data Replication to Couchbase
Use CData Sync to Customize and automate DB2 for i data replication to Couchbase.
-
Connect to Zuora Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zuora Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Publish Crystal Reports on Google Spanner Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Spanner data.
-
Create Informatica Mappings From/To an ODBC Data Source for Excel
Create an ODBC connection to Excel in Informatica and browse and transfer Excel data.
-
How to Connect to SAP HANA Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP HANA data. Leverage the pyodbc module for ODBC in Python.
-
Access Intercom Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Intercom data from HeidiSQL.
-
Build MVC Applications with Connectivity to FTP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FTP from an ASP.NET MVC application.
-
Integrate Neo4J Data into Power Automate Desktop using CData Connect
CData Connect for Neo4J Data enables you to integrate Neo4J data into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to Lakebase Data in PHP
The CData ODBC driver for Lakebase enables you to create PHP applications with connectivity to Lakebase data. Leverage the native support for ODBC in PHP.
-
How to connect to ScrapingBee Data in DBVisualizer
Integrate ScrapingBee data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Mouseflow Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Mouseflow replication to Amazon S3.
-
Getting Started with the CData Power BI Connector for Figshare
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData Python Connector for Egnyte
Learn to install and license the CData Python Connector and configure a connection to live Egnyte data.
-
Replicate SharePoint Data in Heroku for Use in Salesforce Connect
Replicate SharePoint data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Strava Replication to MySQL
Use CData Sync for automated, continuous, customizable Strava replication to MySQL.
-
Integrate Gorgias Data in Pentaho Data Integration
Build ETL pipelines based on Gorgias data in the Pentaho Data Integration tool.
-
Integrate Google's Antigravity Agent with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Pipedrive data using the Model Context Protocol.
-
Integrate Cline with Live AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live AfterShip data from within your IDE.
-
Build Charts with Insightly Data in Clear Analytics
Create dynamic charts and perform analytics based on Insightly data in Clear Analytics.
-
Create Parquet Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Parquet from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating GitHub Copilot with DB2 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 Oracle SCM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle SCM data using the CData Python MCP Server.
-
Query Zoho Recruit Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Recruit data from Node.js.
-
Getting Started with the CData Python Connector for Parallel
Learn to install and license the CData Python Connector and configure a connection to live Parallel data.
-
How to Visualize SFTP Data in Python with pandas
Use pandas and other modules to analyze and visualize live SFTP data in Python.
-
Access Live CSV Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CSV data from your Excel spreadsheets.
-
Automate TaxJar Data Replication to Couchbase
Use CData Sync to Customize and automate TaxJar data replication to Couchbase.
-
Build Gumroad-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gumroad data and build web apps with connectivity to live Gumroad data.
-
Query Live Salesforce Marketing Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Salesforce Marketing data through a conversational interface.
-
Visualize Jumpseller Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Jumpseller data.
-
Create Informatica Mappings From/To an ODBC Data Source for Quickbase
Create an ODBC connection to Quickbase in Informatica and browse and transfer Quickbase data.
-
Connect Parallel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Parallel data using the CData Python MCP Server.
-
Connect to Scrapfly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Scrapfly data in the Denodo Virtual DataPort Administrator.
-
How to Connect to OnePageCrm Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to OnePageCrm data. Leverage the pyodbc module for ODBC in Python.
-
Visualize NASA Data in Tableau
The CData ODBC driver for NASA enables you integrate NASA data into Tableau dashboards.
-
Create Paylocity-Connected Nintex Workflows
Use CData Connect AI to connect to Paylocity Data from Nintex Workflow Cloud and build custom workflows using live Paylocity data.
-
Connect to Anaplan Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Anaplan data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous IBM Cloud Object Storage Replication to Vertica
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Vertica.
-
Integrate Theia IDE with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Azure DevOps data from within the development environment.
-
How to use SQLAlchemy ORM to access LaunchDarkly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LaunchDarkly data.
-
Use Grok to Talk to Your FreshBooks 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 FreshBooks data for you.
-
DataBind Controls to Sybase Data in C++Builder
DataBind to Sybase data in C++Builder with standard components and controls.
-
Build Charts with FreshBooks Data in Clear Analytics
Create dynamic charts and perform analytics based on FreshBooks data in Clear Analytics.
-
Use the CData Software JDBC Driver for Missive in MicroStrategy
Connect to Missive data in MicroStrategy Developer using the CData Software JDBC Driver for Missive.
-
Choosing the Best Method to Connect Certinia to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Certinia data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect to VWO Data from IntelliJ
Integrate connectivity to VWO data with wizards in IntelliJ.
-
Access ZohoPeople Data from MySQL in PHP
Connect to ZohoPeople through the standard MySQL libraries in PHP.
-
Create Data Visualizations Based On VWO Data in Mode
Use CData Connect AI to connect to VWO Data from Mode and build visualizations using live VWO data.
-
How to Easily Query Anaplan Data in OpenOffice Base
Connect to Anaplan data in OpenOffice Base using the CData ODBC Driver for Anaplan and generate reports with live data insights.
-
Automate Discord Data Replication to Couchbase
Use CData Sync to Customize and automate Discord data replication to Couchbase.
-
Query MailChimp Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MailChimp entities in PHP by modeling them as objects.
-
Use CData Connect AI to Access BigQuery Data in Microsoft Power Pivot
Use CData Connect AI to connect to live BigQuery data in the Power Pivot business intelligence tool.
-
How to Connect to Facebook Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Facebook data. Leverage the pyodbc module for ODBC in Python.
-
Analyze SendGrid Data in Cognos Analytics
Use CData Connect AI to connect to SendGrid Data from Cognos Analytics and analyze live SendGrid data.
-
How to connect to Mailgun Data in DBVisualizer
Integrate Mailgun data with visual data analysis tools and data connection wizards in DBVisualizer