CData Software - Knowledge Base
Recent Articles
-
Connect Wrike Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Wrike using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous HDFS Replication to Databricks
Use CData Sync for automated, continuous, customizable HDFS replication to Databricks.
-
Query LightSpeedRetail Data in DataGrip
Create a Data Source for LightSpeedRetail in DataGrip and use SQL to query live LightSpeedRetail.
-
Getting Started with the CData Python Connector for ZendeskSell
Learn to install and license the CData Python Connector
-
Work with Live Amazon DynamoDB Data in Power Query
Use CData Connect AI to connect to Amazon DynamoDB and work with live Amazon DynamoDB in Microsoft Power Query.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Exa to Power BI dashboards. Simply drag and drop Exa into data visuals on the Power BI canvas.
-
Build xBase-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for xBase to explore live xBase Data in Cursor to assist with building xBase-powered applications.
-
Create Datasets from PingOne in Domo Workbench and Build Visualizations of PingOne Data in Domo
Use the CData Software ODBC Driver for PingOne to create datasets from PingOne in Domo Workbench and then build visualizations in the Domo service.
-
Access Suadeo Data from MySQL in Amazon QuickSight
Connect to Suadeo and build visualizations of Suadeo using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Raisers Edge NXT Replication to MongoDB
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to MongoDB.
-
Automated Continuous ZohoInvoice Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to SingleStore.
-
Visualize Live SAS xpt Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAS XPORT.
-
Access Live Paylocity 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 Paylocity through MCP integration.
-
How to create Cloudant federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for IBM Cloudant in MySQL .
-
Integrate with Live Google Campaign Manager 360 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Campaign Manager 360 from the MuleSoft Anypoint Platform to integrate live Google Campaign Manager 360 into custom reports and dashboards.
-
Getting Started with the CData ODBC Driver for Cloudflare
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cloudflare.
-
Explore Geographical Relationships in Pipeline CRM Data with Power Map
Create data visualizations with Pipeline CRM in Power Map.
-
Automated Continuous SpaceX Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SpaceX replication to AlloyDB.
-
Visualize Live Slack Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Slack.
-
Integrate MessageBird Data in Pentaho Data Integration
Build ETL pipelines based on MessageBird in the Pentaho Data Integration tool.
-
Vertica Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Vertica through CData Connect AI using different applications and tools.
-
Automated Continuous Typeform Replication to SQL Server
Use CData Sync for automated, continuous, customizable Typeform replication to SQL Server.
-
Object-Relational Mapping (ORM) with Dynamics 365 Business Central 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 Dynamics 365 Business Central into a Java-based ORM framework, Hibernate.
-
Integrating Claude Code with Google Campaign Manager 360 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Campaign Manager 360 within assisted coding and automated development workflows.
-
LINQ to RSS Feeds
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 RSS Data Provider.
-
Create Omnisend Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Omnisend from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Build an ETL App for Hive Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Hive in Python with petl.
-
Automated Continuous Reckon Accounts Hosted Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to AlloyDB.
-
Build Semantic Layer Views for Delighted Data in APOS Live Data Gateway
Use the CData Connector for Delighted in APOS Live Data Gateway to build Semantic Layer Views for Delighted.
-
Use JayDeBeApi to access Microsoft Entra ID Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Entra ID.
-
Visualize Factorial Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Factorial.
-
How to Connect to Live LinkedIn Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your LinkedIn for you.
-
Model Microsoft Entra ID Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Entra ID, enabling the direct import of real-time Microsoft Entra ID.
-
How to import ZohoSubscriptions Data into Apache Solr
Use the CData Software JDBC Driver for ZohoSubscriptions in Data Import Handler and create an automated import of ZohoSubscriptions to Apache Solr Enterprise Search platform.
-
Integrate Live CockroachDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to CockroachDB and integrate live CockroachDB into apps built in Microsoft Power Apps.
-
Visualize Live Demio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Demio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with VWO Data in Dundas BI
Create dynamic dashboards and perform analytics based on VWO in Dundas BI.
-
Visualize Live Productboard Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Productboard.
-
Publish Crystal Reports on Factorial Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Factorial.
-
Getting Started with the CData Tableau Connector for Cloudant
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for IBM Cloudant.
-
Getting Started with the CData Python Connector for Oracle Service Cloud
Learn to install and license the CData Python Connector
-
Prepare, Blend, and Analyze SAP SuccessFactors Data in Alteryx Designer (ODBC)
Build workflows to access live SAP SuccessFactors for self-service data analytics.
-
Access SAP Ariba Procurement Data from MySQL in Amazon QuickSight
Connect to SAP Ariba Procurement and build visualizations of SAP Ariba Procurement using a MySQL Connection in Amazon QuickSight.
-
Integrating LangGraph with Avalara AvaTax Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Avalara AvaTax within automated workflows.
-
How to create an RPA flow for Google Translate Data in UiPath Studio
Use the Google Translate ODBC Driver to create workflows that access real-time Google Translate without any coding.
-
Use the CData API Server to Access Authorize.Net Data in Microsoft PowerPivot
Use the CData API Server to connect to live Authorize.Net in the Power Pivot business intelligence tool.
-
Integrate Copper Data in Pentaho Data Integration
Build ETL pipelines based on Copper in the Pentaho Data Integration tool.
-
Use the CData Software JDBC Driver for Google Spanner in MicroStrategy
Connect to Google Spanner in MicroStrategy Developer using the CData Software JDBC Driver for Google Spanner.
-
Automated Continuous Sybase IQ Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sybase IQ replication to SingleStore.
-
How to create an RPA flow for Microsoft Ads Data in UiPath Studio
Use the Microsoft Ads ODBC Driver to create workflows that access real-time Microsoft Ads without any coding.
-
Automate Adobe Commerce Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Commerce replication to Couchbase.
-
How to connect to Microsoft Ads Data with Squirrel SQL client
Connect to Microsoft Ads and execute queries in the Squirrel SQL Client.
-
Connect to Reckon Accounts Hosted Data in RazorSQL
Connect to Reckon Accounts Hosted from wizards and query Reckon Accounts Hosted from the GUI in the RazorSQL database management tool.
-
Automate SAP BusinessObjects BI Data Replication to SAP HANA
Use CData Sync to customize and automate SAP BusinessObjects BI replication to SAP HANA.
-
Choosing the Best Method to Connect Customer.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Customer.io from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Explore Geographical Relationships in PDFMonkey Data with Power Map
Create data visualizations with PDFMonkey in Power Map.
-
How to Connect to & Open CapsuleCRM Data in Microsoft Excel
This article uses the CData ODBC driver for CapsuleCRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect and Query Live Impala Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache Impala into Databricks
-
Back Up Sage Intacct to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage Intacct. In this article, we will employ an SSIS workflow to populate a database with Sage Intacct data.
-
Create CouchDB-Connected Applications in Appsmith
Connect to CouchDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Apache CouchDB.
-
Create Apps from SAP Hybris C4C Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Hybris C4C Data and build apps from live SAP Hybris C4C in Qlik Sense Cloud.
-
Integrate SendPulse Data in the Pentaho Report Designer
Publish reports based on SendPulse in the Pentaho BI tool.
-
Use Biml to Build SSIS Tasks to Replicate Gong Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Gong to SQL Server.
-
Billsby Reporting in OBIEE with the Billsby JDBC Driver
Deploy the Billsby JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Multiple Unbounce Accounts via the CData Sync CLI
Replicate multiple Unbounce accounts to one or many databases.
-
Connect to Placid Data from a Connection Pool in JBoss
Integrate Placid into Java servlets: Use the Management Console in JBoss to install the Placid JDBC Driver.
-
Build Todoist-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Todoist Data in GitHub Copilot to assist with building Todoist-powered applications.
-
Integrate with Zuora Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zuora to a JSON file on disk.
-
How to create Accelo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Accelo in MySQL .
-
Create Datasets from Microsoft Planner in Domo Workbench and Build Visualizations of Microsoft Planner Data in Domo
Use the CData Software ODBC Driver for Microsoft Planner to create datasets from Microsoft Planner in Domo Workbench and then build visualizations in the Domo service.
-
Replicate Multiple Adobe Commerce Accounts via the CData Sync CLI
Replicate multiple Adobe Commerce accounts to one or many databases.
-
Access Live MySQL Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MySQL from your Google Sheets.
-
Automated Continuous Azure Data Catalog Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Azure SQL Database.
-
Visualize Live Basecamp Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Basecamp.
-
Connect to Aweber Data in HULFT Integrate
Connect to Aweber as a JDBC data source in HULFT Integrate
-
Load Insightly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Insightly to a database.
-
How to create Gorgias federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Gorgias in MySQL .
-
How to Create Power BI Visual Reports with Real-Time ZeroBounce Data
Use CData Power BI Connectors to visualize ZeroBounce in Power BI.
-
Import Real-Time Salesforce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce & Force.com in ColdFusion.
-
Use the CData Software ODBC Driver for Oracle in MicroStrategy Desktop
Connect to Oracle Database in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle.
-
Automate Authorize.Net Data Replication to Azure Synapse
Use CData Sync to customize and automate Authorize.Net replication to Azure Synapse.
-
Create Apps from MongoDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to MongoDB Data and build apps from live MongoDB in Qlik Sense Cloud.
-
Query ZohoPeople Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoPeople.
-
Create a Data Access Object for Mode Data using JDBI
A brief overview of creating a SQL Object API for Mode in JDBI.
-
Integrate with Live Trello Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Trello from the MuleSoft Anypoint Platform to integrate live Trello into custom reports and dashboards.
-
Import Adobe Target Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Adobe Target. In this article, you will use the OData format to import Adobe Target into Microsoft Power Query.
-
Integrate Cline with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Pipedrive from within your IDE.
-
Connect to GitHub Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for GitHub Data and connect to GitHub in Akorbi Digital RunMyProcess.
-
Connect to Live Microsoft Teams Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Teams Data in CData Connect AI and connect to your Microsoft Teams from MicroStrategy.
-
Create Reports with GitHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitHub.
-
How to integrate Highrise with Apache Airflow
Access and process Highrise CRM in Apache Airflow using the CData JDBC Driver.
-
Use Manus AI to Talk to Your LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on LinkedIn Ads.
-
Access Live Splunk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Splunk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous eBay Replication to SQL Server
Use CData Sync for automated, continuous, customizable eBay replication to SQL Server.
-
Getting Started with the CData JDBC Driver for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics 365 Business Central.
-
Use Claude to Talk to Your Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Oracle Sales for you.
-
How to Connect to Live CSV Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your CSV/TSV Files for you.
-
LINQ to HDFS 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 HDFS Data Provider.
-
Integrate Phoenix Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Phoenix from Informatica Cloud.
-
Use the CData Software ODBC Driver for Exa in MicroStrategy Web
Connect to Exa in MicroStrategy Web using the CData Software ODBC Driver for Exa.