CData Software - Knowledge Base
Recent Articles
-
Connecting Mastra with Google Spanner via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Analyze Sage Cloud Accounting in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sage Business Cloud Accounting and visualize live Sage Business Cloud Accounting in Infragistics Reveal.
-
Build Visualizations of Cvent in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cvent in Birst.
-
Create Reports with Hive in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Hive.
-
Automated Continuous Splunk Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Splunk replication to OneLake in Microsoft Fabric.
-
Automated Continuous Zoho Books Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Books replication to IBM DB2.
-
Replicate Multiple SurveyMonkey Accounts
Replicate multiple SurveyMonkey accounts to one or many databases.
-
Work with FHIR in FoxPro
Load FHIR into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live PostgreSQL of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PostgreSQL using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Access SAS Data Sets Using Entity Framework
This article shows how to access SAS Data Sets using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Asana in Pentaho Data Integration
Build ETL pipelines based on Asana in the Pentaho Data Integration tool.
-
Choosing the Best Method to Connect Drip to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Drip from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Redshift with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Redshift with External Services.
-
Build Automated Instagram-Connected Workflows in Zapier
Use CData Connect AI to connect to live Instagram and build automated workflows in Zapier.
-
How to Import Data from Google Search into Google Sheets
Import Google Search into a Google spreadsheet that is automatically refreshed.
-
Access Live MongoDB in AWS Lambda (with IntelliJ IDEA)
Connect to live MongoDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Claude to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your OData for you.
-
Publish Crystal Reports on Google Data Catalog
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Data Catalog.
-
Connect to Trello in RapidMiner
Integrate Trello with standard components and data source configuration wizards in RapidMiner Studio.
-
Create SSAS Tabular Models from Couchbase
How to build a SQL Server Analysis Service Tabular Model from Couchbase using CData drivers.
-
Configure the CData JDBC Driver for Azure Data Lake Storage in a Connection Pool in Tomcat
Connect to Azure Data Lake Storage from a connection pool in Tomcat.
-
Configure the CData JDBC Driver for SAP Fieldglass in a Connection Pool in Tomcat
Connect to SAP Fieldglass from a connection pool in Tomcat.
-
Natively Connect to Azure Data Catalog in PHP
The CData ODBC driver for Azure Data Catalog enables you to create PHP applications with connectivity to Azure Data Catalog. Leverage the native support for ODBC in PHP.
-
Automated Continuous Drift Replication to SQL Server
Use CData Sync for automated, continuous, customizable Drift replication to SQL Server.
-
Create Data Visualizations in Cognos BI with Email
Access Email as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Sage 200 as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage 200 as an External Source in Dremio.
-
How to Connect to & Open Harvest in Microsoft Excel
This article uses the CData ODBC driver for Harvest to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Coinbase Replication to MySQL
Use CData Sync for automated, continuous, customizable Coinbase replication to MySQL.
-
Migrating data from Zendesk to Snowflake using CData SSIS Components.
Easily push Zendesk to Snowflake using the CData SSIS Tasks for Zendesk and Snowflake.
-
Import Google Ads into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Ads. In this article, you will use the OData format to import Google Ads into Microsoft Power Query.
-
Connect to Oracle Eloqua Reporting from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Eloqua Reporting from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Eloqua Reporting.
-
Consume Sage 300 OData Feeds in PowerBuilder
This article demonstrates how to consume Sage 300 as OData feeds from PowerBuilder using the API Server.
-
Automated IBM Cloud Object Storage Replication to Teradata
Use CData Sync to Customize and automate IBM Cloud Object Storage replication to Teradata.
-
Use the CData Software JDBC Driver for Pinterest in MicroStrategy Desktop
Connect to Pinterest in MicroStrategy Desktop using the CData Software JDBC Driver for Pinterest.
-
How to connect to Google Ads from Spring Boot
Connect to Google Ads in a Spring Boot Application using CData JDBC Google Ads Driver
-
Easily Integrate SingleStore in Lazarus Pascal IDE
Learn how to easily integrate live SingleStore in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData ODBC Driver for Phoenix from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Phoenix to connect to Apache Phoenix from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Phoenix in Excel.
-
DataBind Controls to Elasticsearch in Delphi
DataBind to Elasticsearch in Delphi with standard data access components and controls.
-
Consume Twitter Ads OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Twitter Ads feeds that reflect any changes in SAP Lumira.
-
Visualize Zoho Books in TIBCO Spotfire through OData
Integrate Zoho Books into dashboards in TIBCO Spotfire.
-
Using the CData Software ODBC Driver for xBase in PyCharm
Connect to xBase as an ODBC data source in PyCharm using the CData Software ODBC Driver for xBase.
-
Connect to SAP SuccessFactors as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP SuccessFactors.
-
Analyze Google Search Results in Cognos Analytics
Use CData Connect AI to connect to Google Search Results from Cognos Analytics and analyze live Google Search.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ActiveCampaign
Provide connectivity to ActiveCampaign through an SAP BusinessObjects universe.
-
Bind Live Stripe Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Stripe data
-
Build a Singer.io Tap for Google Sheets With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Sheets data using
-
Build Square-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Square.
-
Use the CData API Server to Access Google Sheets in Microsoft PowerPivot
Use the CData API Server to connect to live Google Sheets in the Power Pivot business intelligence tool.
-
Publish Tally-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Tally ERP.
-
Create Avalara AvaTax-Connected Business Apps in AppSheet
Connect to Avalara AvaTax via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Avalara AvaTax.
-
Create Data Visualizations Based On Amazon Athena in Mode
Use CData Connect AI to connect to Amazon Athena from Mode and build visualizations using live
-
How to Connect DBeaver to EnterpriseDB via a JDBC Driver
Manage EnterpriseDB with visual tools in DBeaver like the query browser.
-
How to create MongoDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MongoDB in MySQL .
-
Automate SuiteCRM Replication to Azure Synapse
Use CData Sync to customize and automate SuiteCRM replication to Azure Synapse.
-
Model ServiceNow Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ServiceNow, enabling the direct import of real-time ServiceNow.
-
Integrating CSV in Talend Cloud Data Management Platform
-