CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for HubDB in MicroStrategy Desktop
Connect to HubDB in MicroStrategy Desktop using the CData Software ODBC Driver for HubDB.
-
Connect to Calendly in Ruby
Connect to Calendly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect and Query Live Couchbase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Couchbase into Databricks
-
Publish Reports with HBase in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache HBase.
-
Connect to Marketo as an External Source in Dremio
Use the CData JDBC Driver to connect to Marketo as an External Source in Dremio.
-
Connect to Xero from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Xero to connect to Xero Accounting and execute queries in PowerBuilder.
-
How to connect and process SAP Hybris C4C from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Hybris C4C.
-
Build Reckon-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Reckon and build Reckon-connected web apps with Axios.
-
Publish Dynamics NAV-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics NAV.
-
DataBind Controls to Printify in C++Builder
DataBind to Printify in C++Builder with standard components and controls.
-
How to Use a Microsoft Access Database to Update Avalara AvaTax in Real Time
Update Avalara AvaTax data by creating a linked table in Microsoft Access with the CData Avalara AvaTax ODBC Driver.
-
Automated Amazon Marketplace Replication to Teradata
Use CData Sync to Customize and automate Amazon Marketplace replication to Teradata.
-
Publish Todoist-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Todoist.
-
Build Visualizations of MariaDB in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MariaDB in Birst.
-
Automated Continuous CouchDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CouchDB replication to delimited files (CSV/TSV).
-
Connect to Zoho Projects from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho Projects from Crystal Reports.
-
How to Connect to Live AlloyDB 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 Google AlloyDB for you.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon DynamoDB within intelligent workflows.
-
Visualize Microsoft Planner in Tableau
The CData ODBC driver for Microsoft Planner enables you integrate Microsoft Planner into Tableau dashboards.
-
Connecting Moonlit Workflow with Marketo 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 Marketo in real time.
-
Query, Visualize, and Share live Presto in Redash
Use CData Connect AI to connect to live Presto in Redash for querying, visualizing, and sharing.
-
Connect to SAP Fieldglass in CloverDX (formerly CloverETL)
Transfer SAP Fieldglass using the visual workflow in the CloverDX data integration tool.
-
Perform Batch Operations with Microsoft Planner in Apache NiFi
Connect to Microsoft Planner and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create SSAS Tabular Models from Google Ads
How to build a SQL Server Analysis Service Tabular Model from Google Ads using CData drivers.
-
How to Connect to Live ShipStation 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 ShipStation for you.
-
Use the CData Software JDBC Driver for Adobe Analytics in MicroStrategy Desktop
Connect to Adobe Analytics in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Analytics.
-
Validate Bullhorn CRM with QuerySurge
Access and validate Bullhorn CRM in QuerySurge using the CData JDBC Driver.
-
Build Google Sheets-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Sheets and build web apps with connectivity to live Google Sheets.
-
Connect to Dynamics 365 Business Central in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Dynamics 365 Business Central in Airbyte.
-
Manage QuickBooks Online in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for QuickBooks Online.
-
Analyze Live Google Analytics in SAS Viya
Use CData Connect AI to connect to Google Analytics from SAS Viya and deploy self-service analytics using live Google Analytics.
-
Connect Dynamics CRM to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Dynamics CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live MailChimp 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 MailChimp for you.
-
Analyze Redshift with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Redshift from Power Pivot. You will use the Table Import Wizard to load Amazon Redshift. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Controls to Paylocity in C++Builder
DataBind to Paylocity in C++Builder with standard components and controls.
-
Create Datasets from Gmail in Domo Workbench and Build Visualizations of Gmail in Domo
Use the CData Software ODBC Driver for Gmail to create datasets from Gmail in Domo Workbench and then build visualizations in the Domo service.
-
Add Salesforce to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Neo4J-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Neo4J and build web apps with connectivity to live Neo4J.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for eBay Analytics
Provide connectivity to eBay Analytics through an SAP BusinessObjects universe.
-
How to connect to Redis from IntelliJ
Integrate connectivity to Redis with wizards in IntelliJ.
-
Use Biml to Build SSIS Tasks to Replicate Splunk to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Splunk to SQL Server.
-
How to Work with Avalara AvaTax in ETL Validator JDBC
Connect to Avalara AvaTax from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Kintone from Crystal Reports
Use CData Connect AI to connect to and report on live Kintone from Crystal Reports.
-
How to Build an ETL App for Dynamics 365 in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Dynamics 365 in Python with petl.
-
Create Informatica Mappings From/To an ODBC Data Source for Workday
Create an ODBC connection to Workday in Informatica and browse and transfer Workday.
-
Working with Klaviyo in LINQPad
Execute LINQ queries to Klaviyo in LINQPad.
-
Getting Started with the CData JDBC Driver for Square
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Square.
-
Replicate Multiple SAP Netweaver Gateway Accounts
Replicate multiple SAP Netweaver Gateway accounts to one or many databases.
-
PowerShell Scripting to Replicate PostgreSQL to MySQL
Write a simple PowerShell script to replicate PostgreSQL to a MySQL database.
-
Automated Continuous eBay Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable eBay Analytics replication to MySQL.
-
Connect to Salesforce as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce & Force.com.
-
Migrating data from Gmail to Snowflake using CData SSIS Components.
Easily push Gmail to Snowflake using the CData SSIS Tasks for Gmail and Snowflake.
-
How to load Printify data into Elasticsearch via Logstash
Introducing a simple method to load Printify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate Power BI XMLA Replication to Azure Synapse
Use CData Sync to customize and automate Power BI XMLA replication to Azure Synapse.
-
Create Paylocity-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Paylocity from Klipfolio and build custom visualizations using live Paylocity.
-
Connect to Live GraphQL in PostGresSQL Interface through CData Connect AI
Create a live connection to GraphQL in CData Connect AI and connect to your GraphQL from PostgreSQL.
-
MarkLogic: SQL-NOCOLUMN: Column Not Found Error
In this entry you will find information relating to MarkLogic's "SQL-NOCOLUMN" error.
-
Visualize Epicor Kinetic in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Epicor Kinetic into TIBCO Spotfire.
-
Automated Continuous ConstantContact Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ConstantContact replication to Google Cloud SQL.
-
Connect to Google Sheets from PowerBuilder via ADO.NET
This article demonstrates how to access Google Sheets from Appeon PowerBuilder using the CData ADO.NET Provider for Google Sheets.
-
How to Query Live Zoho Creator in Perplexity MacOS Desktop
Connect to and query live Zoho Creator in Perplexity Desktop using CData Code Assist MCP.
-
View Reports on Real-Time OData Services in Power BI Report Server
Use the CData ODBC Driver for OData to visualize OData in Power BI Desktop and then publish them to Power BI Report Server.
-
Build a Singer.io Tap for Sage 300 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sage 300 data using
-
Build Automated Workflows with Live Gmail in Workato
Use CData Connect AI to connect to live Gmail and build automated workflows in Workato.
-
Connect to Google Directory in Claris FileMaker Pro
-