CData Software - Knowledge Base
Recent Articles
-
How to Access Zoho Books Using Entity Framework
This article shows how to access Zoho Books using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect and Visualize Live Twitter Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Twitter into the Databricks platform and create visualization dashboards with real-time Twitter.
-
How to Connect to Live Freshdesk in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Freshdesk for you.
-
How to Build an ETL App for Google Directory in Python with CData
Create ETL applications and real-time data pipelines for Google Directory in Python with petl.
-
Publish QuickBooks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live QuickBooks Desktop.
-
Use Claude to Talk to Your Hive via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Apache Hive for you.
-
Access Live SAP Business One in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Business One from your Excel spreadsheets.
-
Connect to Excel Online in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Excel Online and connect to Microsoft Excel Online in Akorbi Digital RunMyProcess.
-
Visualize AlloyDB in TIBCO Spotfire through ADO.NET
Integrate Google AlloyDB into dashboards in TIBCO Spotfire.
-
Create a Data Access Object for Certinia using JDBI
A brief overview of creating a SQL Object API for Certinia in JDBI.
-
DataBind Controls to Parquet in C++Builder
DataBind to Apache Parquet in C++Builder with standard components and controls.
-
Integrate with Amazon DynamoDB in JReport Designer
Create charts and reports based on Amazon DynamoDB in JReport Designer.
-
Choosing the Best Method to Connect Oracle Eloqua Reporting to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Eloqua Reporting from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Greenplum 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 Pivotal GreenPlum for you.
-
Build Semantic Layer Views for OData Services in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for OData.
-
Automated Continuous Kafka Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Kafka replication to Amazon Redshift.
-
How to Connect Flowise AI Agents to Live Azure DevOps via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Create Apps from Airtable in Qlik Sense Cloud
Use CData Connect AI to connect to Airtable and build apps from live Airtable in Qlik Sense Cloud.
-
Build a Singer.io Tap for Amazon DynamoDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amazon DynamoDB data using
-
Build Data Flows from SQL Server to Certinia through SSIS
Easily push SQL Server data to Certinia using the CData SSIS Tasks for Certinia.
-
Object-Relational Mapping (ORM) with Printful 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 Printful into a Java-based ORM framework, Hibernate.
-
How to connect to LinkedIn Ads in DBVisualizer
Integrate LinkedIn Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
ETL PostgreSQL in Oracle Data Integrator
This article shows how to transfer PostgreSQL into a data warehouse using Oracle Data Integrator.
-
Use the CData ODBC Driver for RSS from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for RSS to connect to RSS Feeds from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring RSS Feeds in Excel.
-
Explore Geographical Relationships in JSON Services with Power Map
Create data visualizations with JSON in Power Map.
-
Build Apps with Live Sage 200 in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sage 200 into the Adalo platform and build custom mobile and web applications with real-time Sage 200.
-
Create Reports with SAP in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP ERP/NetWeaver.
-
Access Live Reckon Accounts Hosted in Coginiti Pro
Connect to and query live Reckon Accounts Hosted from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create SSAS Tabular Models from Printful
How to build a SQL Server Analysis Service Tabular Model from Printful using CData drivers.
-
Getting Started with the CData ODBC Driver for Calendly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Calendly.
-
Build a Simple VCL Application for Google Campaign Manager 360
How to build a simple VCL Application to view Google Campaign Manager 360 in RAD Studio using the CData ODBC Driver for Google Campaign Manager 360.
-
Automate GraphQL Replication to Couchbase
Use CData Sync to Customize and automate GraphQL replication to Couchbase.
-
How to Connect to Live Instagram 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 Instagram for you.
-
Connect to and Visualize Live Google Ads in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Ads.
-
Connect to Xero in Google Apps Script via SQL Gateway
Use the ODBC Driver for Xero and the SQL Gateway to access Xero Accounting from Google Apps Script.
-
Replicate SAP from PowerShell
Write a quick PowerShell script to query SAP ERP/NetWeaver. Use connectivity to the live data to replicate SAP ERP/NetWeaver to SQL Server.
-
Connect and Query Live ActiveCampaign Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ActiveCampaign into Databricks
-
Connect to BigCommerce through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with BigCommerce using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Avalara AvaTax from Crystal Reports
Use CData Connect AI to connect to and report on live Avalara AvaTax from Crystal Reports.
-
Connect to Presto in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Presto in Airbyte.
-
Use the CData SSIS Components to Insert New or Update Existing Tableau CRM Analytics Records from SQL Server
Easily push SQL Server data to Tableau CRM Analytics using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Tableau CRM Analytics or update existing records with data from a SQL Server database.
-
Automated Continuous Typeform Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Typeform replication to PostgreSQL.
-
How to create Visio diagrams from ActiveCampaign
Automatically update ActiveCampaign with the changes you make to Visio master shapes.
-
Connect to Bullhorn CRM from PowerBuilder via JDBC
This article demonstrates how to access Bullhorn CRM from PowerBuilder using the Bullhorn CRM JDBC Driver.
-
Automated Continuous Azure Data Lake Storage Replication to SQLite
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to SQLite.
-
Connect to WooCommerce in CloverDX (formerly CloverETL)
Transfer WooCommerce using the visual workflow in the CloverDX data integration tool.
-
Access MarkLogic from MySQL in Amazon QuickSight
Connect to MarkLogic and build visualizations of MarkLogic using a MySQL Connection in Amazon QuickSight.
-
Automate Zoho Projects Replication to SAP HANA
Use CData Sync to customize and automate Zoho Projects replication to SAP HANA.
-
Use the CData API Server to Access Asana in Microsoft PowerPivot
Use the CData API Server to connect to live Asana in the Power Pivot business intelligence tool.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Integrate with Live DocuSign in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to DocuSign from the MuleSoft Anypoint Platform to integrate live DocuSign into custom reports and dashboards.
-
Visualize PingOne from Tableau
Use the Tableau Desktop business intelligence tool to connect to PingOne.
-
How to use SQLAlchemy ORM to access Databricks in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Databricks.
-
Publish Zoho Inventory-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho Inventory.
-
Visualize Workday in TIBCO Spotfire through OData
Integrate Workday into dashboards in TIBCO Spotfire.
-
Use Biml to Build SSIS Tasks to Replicate Outreach.io to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Outreach.io to SQL Server.
-
How to Connect to Live Quickbase in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Quickbase without replication.
-
Connect to Live Dynamics 365 in MicroStrategy through CData Connect AI
Create a live connection to Dynamics 365 in CData Connect AI and connect to your Microsoft Dynamics 365 from MicroStrategy.
-
Prepare, Blend, and Analyze QuickBooks Online in Alteryx Designer (ODBC)
Build workflows to access live QuickBooks Online for self-service data analytics.
-
Integrating LangChain with CockroachDB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on CockroachDB within automated workflows.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Bullhorn CRM using the Model Context Protocol.
-
How to Access Live SAP in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP enables you to integrate SAP ERP/NetWeaver into workflows built using Microsoft Power Automate Desktop.
-
Build a PostgreSQL Interface for Wave Financial using the CData JDBC Driver
Use the Remoting features of the Wave Financial JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Gumloop with Hive via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apache Hive within automated workflows.
-
Automated Continuous Shopify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Shopify replication to Snowflake.
-
Automated Continuous Basecamp Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Basecamp replication to Apache Kafka.
-
Connect to Bullhorn CRM from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Bullhorn CRM from Filemaker Pro on Mac.
-
How to Connect the Power BI Service to Adobe Commerce: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Query Printify through ODBC in Node.js
Use node-odbc to execute SQL queries against Printify from Node.js.
-
Access Live Amazon Athena in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Athena from your Google Sheets.
-
Build Google Contacts-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Contacts and create custom apps in Mendix.
-
Connect to SendGrid through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SendGrid using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Fieldglass
Create SAP Fieldglass data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Pipedrive in the Pentaho Report Designer
Publish reports based on Pipedrive in the Pentaho BI tool.
-
Connect EnterpriseDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect EnterpriseDB with IBM WebSphere for seamless data integration and connectivity.
-
Work with Acumatica in FoxPro
Load Acumatica ERP into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Semantic Layer Views for Azure Table in APOS Live Data Gateway
Use the CData Connector for Azure Table in APOS Live Data Gateway to build Semantic Layer Views for Azure Table Storage.
-
Stream SAP into Apache Kafka Topics
Access and stream SAP ERP/NetWeaver in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software JDBC Driver for SQL Server in MicroStrategy Web
Connect to Microsoft SQL Server in MicroStrategy Web using the CData Software JDBC Driver for SQL Server.
-
How to connect to Redshift from IntelliJ
Integrate connectivity to Amazon Redshift with wizards in IntelliJ.
-
Access Live Impala in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Impala from your Excel spreadsheets.
-
Visualize OneNote in Tableau
The CData ODBC driver for OneNote enables you integrate Microsoft OneNote into Tableau dashboards.
-
Connect and Query Live Snowflake Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Snowflake into Databricks
-
Connect to Marketo in JRuby
Create a simple JRuby app with access to live Marketo.
-
Analyze SAP Hybris C4C in Looker
Use CData Connect AI to connect to SAP Hybris C4C from Looker and build custom apps using live SAP Hybris C4C.
-
Build FHIR-Connected Apps in Choreo
Use CData Connect AI to connect to FHIR from Choreo and build custom apps using live FHIR.
-
PowerShell Scripting to Replicate MarkLogic to MySQL
Write a simple PowerShell script to replicate MarkLogic to a MySQL database.
-
Integrate Microsoft Planner in Pentaho Data Integration
Build ETL pipelines based on Microsoft Planner in the Pentaho Data Integration tool.
-
Import Slack into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Slack. In this article, you will use the OData format to import Slack into Microsoft Power Query.
-
Use Claude to Talk to Your Salesforce via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Salesforce & Force.com for you.
-
Integrate Twitter Ads into Power Automate Desktop using CData Connect
CData Connect for Twitter Ads enables you to integrate Twitter Ads into workflows built using Microsoft Power Automate Desktop.
-
Analyze Twitter in R via JDBC
Use standard R functions and the development environment of your choice to analyze Twitter with the CData JDBC Driver for Twitter.
-
Import Real-Time SAS Data Sets via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAS Data Sets in ColdFusion.
-
PowerShell Scripting to Replicate Basecamp to MySQL
Write a simple PowerShell script to replicate Basecamp to a MySQL database.
-
How to connect to OneNote in DBVisualizer
Integrate Microsoft OneNote with visual data analysis tools and data connection wizards in DBVisualizer
-
Prepare, Blend, and Analyze Dropbox in Alteryx Designer (ODBC)
Build workflows to access live Dropbox for self-service data analytics.
-
Integrating LangChain with Excel Online via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Excel Online within automated workflows.
-
Connect Amazon Marketplace to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amazon Marketplace using the CData Python MCP Server.
-
Build Semantic Layer Views for Parquet in APOS Live Data Gateway
Use the CData Connector for Parquet in APOS Live Data Gateway to build Semantic Layer Views for Apache Parquet.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for QuickBooks Time
Provide connectivity to QuickBooks Time through an SAP BusinessObjects universe.