CData Software - Knowledge Base
Recent Articles
-
Moving Data from Billsby to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Billsby data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to iContact Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for iContact and the SQL Gateway to access iContact data from Google Apps Script.
-
Visualize Snowflake Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Snowflake data into TIBCO Spotfire.
-
Replicate Asana Data from PowerShell
Write a quick PowerShell script to query Asana data. Use connectivity to the live data to replicate Asana data to SQL Server.
-
How to Connect to Live Zoho Creator Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zoho Creator data through natural language.
-
Connect to Salesforce Data 360 Data in Ruby
Connect to Salesforce Data 360 data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data for you.
-
Build MVC Applications with Connectivity to Ontraport Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Ontraport from an ASP.NET MVC application.
-
Automated Continuous Aha! Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Aha! replication to Apache Kafka.
-
Build Automated Facebook Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live Facebook Ads data and build automated workflows in Zapier.
-
Connect to Real-Time Timely Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Timely data in Power Apps.
-
Connect to Real-Time Oracle Sales Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle Sales and Dataflow to import and use Oracle Sales data in Power Apps.
-
Connect to Sage 300 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sage 300 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Google Spanner Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Spanner data access from reports, embedded analytics, and more.
-
Connect to Google Campaign Manager 360 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Campaign Manager 360 as an External Source in Dremio.
-
Access Live GraphQL Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GraphQL data from your Google Sheets.
-
Integrate Google's Vertex AI Agent with Live Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Bannerbear data within intelligent workflows.
-
Feed Webex Data into FineReport
How to set Webex data as a JDBC data source in FineReport.
-
Integrate Devin with Live Reckon Accounts Hosted Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Reckon Accounts Hosted data.
-
Integrate Slack Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Slack data from Informatica Cloud.
-
Connect to Monday.com from Asprova with CData Software ODBC Driver for Monday.com
This article shows how to connect faster to Monday.com data from Asprova.
-
Automated Continuous AlloyDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable AlloyDB replication to Amazon Redshift.
-
Automated Continuous Authorize.Net Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Amazon Redshift.
-
Publish SAP Fieldglass-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Fieldglass data.
-
Publish Reports with Avro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Avro data.
-
Access Live Snapchat Ads Data in Excel 365 Online (Excel for the web)
Connect to Snapchat Ads data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Goose with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAS xpt data from within the local AI agent.
-
How to Connect to & Open SuiteCRM Data in Microsoft Excel
This article uses the CData ODBC driver for SuiteCRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Omnisend Data in the Pentaho Report Designer
Publish reports based on Omnisend data in the Pentaho BI tool.
-
Integrate Strava Data in the Pentaho Report Designer
Publish reports based on Strava data in the Pentaho BI tool.
-
Build Oracle Service Cloud-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Service Cloud Data from Zoho Analytics and import live Oracle Service Cloud data.
-
How to Build an ETL App for Teradata Data in Python with CData
Create ETL applications and real-time data pipelines for Teradata data in Python with petl.
-
eBay Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on eBay facts in real time.
-
Connect to HubDB in SpagoBI
Create reports featuring live HubDB data in SpagoBI Studio. Host HubDB reports on SpagoBI Server.
-
Create Amazon S3-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon S3 Data from OutSystems and build custom enterprise apps using live Amazon S3 data.
-
Connect to Spotify from Asprova with CData Software ODBC Driver for Spotify
This article shows how to connect faster to Spotify data from Asprova.
-
Validate SAP SuccessFactors LMS Data with QuerySurge
Access and validate SAP SuccessFactors LMS data in QuerySurge using the CData JDBC Driver.
-
Explore Geographical Relationships in Cassandra Data with Power Map
Create data visualizations with Cassandra data in Power Map.
-
Using the CData Software ODBC Driver for Neo4J in PyCharm
Connect to Neo4J as an ODBC data source in PyCharm using the CData Software ODBC Driver for Neo4J.
-
Object-Relational Mapping (ORM) with HelloSign 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 HelloSign data into a Java-based ORM framework, Hibernate.
-
A PostgreSQL Interface for SAP Ariba Procurement Data using the CData ODBC Driver
Use the SQL Gateway and SAP Ariba Procurement ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple ActiveCampaign Accounts via the CData Sync CLI
Replicate multiple ActiveCampaign accounts to one or many databases.
-
A PostgreSQL Interface for Google Cloud Storage Data using the CData ODBC Driver
Use the SQL Gateway and Google Cloud Storage ODBC Driver to create a PostgreSQL entry-point for data access.
-
Stream Jumpseller Data into Apache Kafka Topics
Access and stream Jumpseller data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Agno to Talk to Your NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your NetSuite data for you.
-
Build AI/ML Models with Live Customer.io Data using Dataiku
Connect Customer.io Data with Dataiku using the CData API Driver for JDBC.
-
Automate SuiteCRM Data Replication to Azure Synapse
Use CData Sync to customize and automate SuiteCRM data replication to Azure Synapse.
-
Automated Continuous LeadDesk Replication to Oracle
Use CData Sync for automated, continuous, customizable LeadDesk replication to Oracle.
-
Automated Continuous BigCommerce Replication to Vertica
Use CData Sync for automated, continuous, customizable BigCommerce replication to Vertica.
-
Connect to Zoho Recruit from Asprova with CData Software ODBC Driver for Zoho Recruit
This article shows how to connect faster to Zoho Recruit data from Asprova.
-
How to publish and share Quickbase Data dashboards with Tableau Server
The CData ODBC driver for Quickbase enables you integrate Quickbase data into Tableau dashboards.
-
Automated Continuous HubSpot Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HubSpot replication to Apache Kafka.
-
Visualize Azure Analysis Services Data in Tableau
The CData ODBC driver for Azure Analysis Services enables you integrate Azure Analysis Services data into Tableau dashboards.
-
Migrating data from PhantomBuster to Databricks using CData SSIS Components.
Easily push PhantomBuster data to Databricks using the CData SSIS Tasks for PhantomBuster and Databricks.
-
How to Connect to Live Paylocity Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Paylocity data without replication.
-
Establish a Live Connection with Klaviyo Data using Tableau Bridge
The CData ODBC Driver for Klaviyo enables you to integrate live Klaviyo data into Tableau Cloud dashboards using the Tableau Bridge.
-
Import Toggl Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Toggl Data and provide access to live Toggl data for custom reports in the Power BI Service.
-
Access Snowflake Data from MySQL in Amazon QuickSight
Connect to Snowflake and build visualizations of Snowflake data using a MySQL Connection in Amazon QuickSight.
-
How to Work with Presto Data in ETL Validator JDBC
Connect to Presto from ETL Validator jobs using the CData Software JDBC Driver.
-
Working with LDAP Objects in LINQPad
Execute LINQ queries to LDAP objects in LINQPad.
-
Connect to Workday Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Workday.
-
Moving Data from Google Spanner to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Spanner data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Excel Online Replication to Databricks
Use CData Sync for automated, continuous, customizable Excel Online replication to Databricks.
-
Viewing Telegram Data in RAD Studio Data Explorer
How to view Telegram data in RAD Studio Data Explorer using the CData ODBC Driver for Telegram.
-
Build AI/ML Models with Live EmailOctopus Data using Dataiku
Connect EmailOctopus Data with Dataiku using the CData API Driver for JDBC.
-
How to connect PolyBase to MessageBird
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MessageBird data.
-
Automate eBay Analytics Data Replication to SAP HANA
Use CData Sync to customize and automate eBay Analytics data replication to SAP HANA.
-
LINQ to Customer.io 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 Customer.io Data Provider.
-
Connect to SharePoint Excel Services Data in CloverDX (formerly CloverETL)
Transfer SharePoint Excel Services data using the visual workflow in the CloverDX data integration tool.
-
New Adobe Analytics Views
This article reviews the newly added views to the CData Adobe Analytics Drivers, the UniversalReport view and new predefined report views.
-
Connect to Couchbase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Couchbase.
-
Integrating LangGraph with Zendesk Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zendesk data within automated workflows.
-
Access Live Dynamics CRM 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 Dynamics CRM data through MCP integration.
-
DataBind Controls to Sage Cloud Accounting Data in Delphi
DataBind to Sage Cloud Accounting data in Delphi with standard data access components and controls.
-
Connect to Microsoft Teams Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Teams to connect to Microsoft Teams data and execute queries in PowerBuilder.
-
Create Apps from JSON Services in Qlik Sense Cloud
Use CData Connect AI to connect to JSON Services and build apps from live JSON services in Qlik Sense Cloud.
-
Use Claude to Talk to Your Salesforce Data 360 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 Salesforce Data 360 data for you.
-
How to load Mode data into Elasticsearch via Logstash
Introducing a simple method to load Mode data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData ADO.NET Provider for Brex
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Live Sybase IQ Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sybase IQ data into custom reports in Power BI.
-
Connect Foursquare Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Foursquare data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
View Reports on Real-Time Qualaroo Data in Power BI Report Server
Use the CData ODBC Driver for Qualaroo to visualize Qualaroo data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query, Visualize, and Share live Bitly Data in Redash
Use CData Connect AI to connect to live Bitly data in Redash for querying, visualizing, and sharing.
-
Connect to Active Directory Data from a Connection Pool in Jetty
The Active Directory JDBC Driver supports connection pooling: This article shows how to connect faster to Active Directory data from Web apps in Jetty.
-
How to Connect to Wave Financial Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Wave Financial data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Basecamp from Asprova with CData Software ODBC Driver for Basecamp
This article shows how to connect faster to Basecamp data from Asprova.
-
Create Dashboards and Visualize Live Perplexity Data in Geckoboard
Use CData Connect AI to connect to live Perplexity data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
PostgreSQL Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PostgreSQL facts in real time.
-
Process & Analyze Oracle Sales Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Sales Data.
-
Integrate OpenCode with Live Acumatica Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Acumatica data from within your AI coding agent.
-
How to load CSV data into Elasticsearch via Logstash
Introducing a simple method to load CSV data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Apps with Live ConvertKit Data Using the Low-Code Development Platform of Mendix
Connect ConvertKit data with Mendix to build apps using the CData API Driver for JDBC.
-
Create SSAS Tabular Models from ZohoMarketingHub Data
How to build a SQL Server Analysis Service Tabular Model from ZohoMarketingHub data using CData drivers.
-
How to connect PolyBase to Demio
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Demio data.
-
Connect to Optimizely Data from PowerBuilder via ADO.NET
This article demonstrates how to access Optimizely data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Model Dynamics CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics CRM, enabling the direct import of real-time Dynamics CRM data.
-
Automated Continuous Xero Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Xero replication to IBM DB2.
-
Visualize ConvertKit Data in Sisense
Create an ElastiCube in Sisense app with access to ConvertKit data.
-
How to Connect DBeaver to Browserless via a JDBC Driver
Manage Browserless data with visual tools in DBeaver like the query browser.
-
Connect to Supabase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Supabase data, and over 250 other data sources, right inside your Excel and Google spreadsheets!