CData Software - Knowledge Base
Recent Articles
-
Visualize Salesforce Marketing Data in Tableau
The CData ODBC driver for Salesforce Marketing enables you integrate Salesforce Marketing Cloud into Tableau dashboards.
-
GitHub Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to GitHub through CData Connect AI using different applications and tools.
-
Build Sage Intacct-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Sage Intacct to explore live Sage Intacct Data in Gemini Code Assist to assist with building Sage Intacct-powered applications.
-
Prepare, Blend, and Analyze Snapchat Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Snapchat Ads for self-service data analytics.
-
Automated Continuous Google Spanner Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Spanner replication to Amazon Redshift.
-
Replicate Kafka Data in Heroku for Use in Salesforce Connect
Replicate Apache Kafka to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Azure DevOps Data in NetBeans
Connect to Azure DevOps in NetBeans with the data source configuration wizard.
-
ETL FTP in Oracle Data Integrator
This article shows how to transfer FTP Servers into a data warehouse using Oracle Data Integrator.
-
Access Live JotForm Data in AWS Lambda (with IntelliJ IDEA)
Connect to live JotForm in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Apps from HBase Data in Qlik Sense Cloud
Use CData Connect AI to connect to HBase Data and build apps from live Apache HBase in Qlik Sense Cloud.
-
How to load Google Tasks data into Elasticsearch via Logstash
Introducing a simple method to load Google Tasks data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use CData Connect AI to Access Oracle SCM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle SCM in the Power Pivot business intelligence tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Presto
Create an ODBC connection to Presto in Informatica and browse and transfer Presto.
-
Build MessageBird-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MessageBird.
-
Integrating Antigravity CLI with Google AlloyDB via CData CLI
Connect Google AlloyDB to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software ODBC Driver for Demio in MicroStrategy
Connect to Demio in MicroStrategy Developer using the CData Software ODBC Driver for Demio.
-
Validate Clari Data with QuerySurge
Access and validate Clari in QuerySurge using the CData JDBC Driver.
-
Integrating MailChimp Data in Talend Cloud Data Management Platform
Connect MailChimp Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MailChimp.
-
Automate Google Search Results Replication to Couchbase
Use CData Sync to Customize and automate Google Search replication to Couchbase.
-
Connect to SendInBlue Data in Ruby
Connect to SendInBlue in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Real-Time Exact Online Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Exact Online and Dataflow to import and use Exact Online in Power Apps.
-
How to Connect to Live Azure Analysis Services 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 Azure Analysis Services for you.
-
Analyze eBay Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of eBay and visualize eBay in SAP Analytics Cloud.
-
How to Connect to Smartsheet Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Smartsheet. Leverage the pyodbc module for ODBC in Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live CockroachDB using the Model Context Protocol.
-
Visualize QuickBooks Time 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 QuickBooks Time into TIBCO Spotfire.
-
How to Visualize Exact Online Data in Python with pandas
Use pandas and other modules to analyze and visualize live Exact Online in Python.
-
Access Live Procore Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Procore from your Excel spreadsheets.
-
Build Semantic Layer Views for Perigon Data in APOS Live Data Gateway
Use the CData Connector for Perigon in APOS Live Data Gateway to build Semantic Layer Views for Perigon.
-
Connect to Highrise Data from Crystal Reports
Use CData Connect AI to connect to and report on live Highrise CRM from Crystal Reports.
-
Integrate Theia IDE with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Natively Connect to AgileCRM Data in PHP
The CData ODBC driver for AgileCRM enables you to create PHP applications with connectivity to AgileCRM. Leverage the native support for ODBC in PHP.
-
Create LeadDesk Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LeadDesk from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate Power BI XMLA Data in Heroku for Use in Salesforce Connect
Replicate Power BI XMLA to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build MVC Applications with Connectivity to Amazon S3 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon S3 from an ASP.NET MVC application.
-
Access Live Humanity Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Humanity in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect Sage 300 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sage 300 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Dynamic Webex Grids Using the Infragistics XamDataGrid
Learn how you can connect Webex to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Databricks Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Databricks as an External Source in Dremio.
-
Use the CData Software ODBC Driver for Chargebee in MicroStrategy Web
Connect to Chargebee in MicroStrategy Web using the CData Software ODBC Driver for Chargebee.
-
Build Adobe Commerce-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Adobe Commerce Data from Zoho Analytics and import live Adobe Commerce.
-
Integrate with live Sugar CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sugar CRM in Jitterbit.
-
Use the CData Software ODBC Driver for PolarTeamPro in MicroStrategy
Connect to PolarTeamPro in MicroStrategy Developer using the CData Software ODBC Driver for PolarTeamPro.
-
How to connect to CouchDB Data with Squirrel SQL client
Connect to Apache CouchDB and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on ZeroBounce Data
Create Python applications that use pandas and Dash to build ZeroBounce-connected web apps.
-
Use the CData Software JDBC Driver for Sentry in MicroStrategy Desktop
Connect to Sentry in MicroStrategy Desktop using the CData Software JDBC Driver for Sentry.
-
Connect to PingOne Data in DBArtisan
Use wizards in DBArtisan to configure PingOne as a data source.
-
Automated Continuous AlloyDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable AlloyDB replication to SQL Server.
-
Automated Continuous Accelo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Accelo replication to IBM DB2.
-
Getting Started with the CData Python Connector for Notion
Learn to install and license the CData Python Connector
-
How to Connect DBeaver to Dotmailer via a JDBC Driver
Manage Dotmailer with visual tools in DBeaver like the query browser.
-
Work with OpenWeatherMap Data in FoxPro
Load OpenWeatherMap into a FoxPro database. This article includes full code and a walk-through of the process.
-
Excel Spreadsheet Automation on Bitbucket Data with the QUERY Formula
Pull data from Bitbucket, automate spreadsheets, and more with the QUERY formula.
-
Build Charts with Tickspot Data in Clear Analytics
Create dynamic charts and perform analytics based on Tickspot in Clear Analytics.
-
Build Active Directory-Connected Apps in Choreo
Use CData Connect AI to connect to Active Directory Data from Choreo and build custom apps using live Active Directory.
-
Integrating OpenCode Terminal with Sage 200 Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
How to load ServiceNow data into Elasticsearch via Logstash
Introducing a simple method to load ServiceNow data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate Zoho Books Data to Multiple Databases via the CData Sync CLI
Replicate Zoho Books to disparate databases with a single configuration.
-
Integrate Goose with Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Dynamics 365 from within the local AI agent.
-
Automated Continuous Monday.com Replication to MongoDB
Use CData Sync for automated, continuous, customizable Monday.com replication to MongoDB.
-
Integrate Cline with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft OneDrive from within your IDE.
-
How to use SQLAlchemy ORM to access GraphQL Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GraphQL.
-
Getting Started with the CData JDBC Driver for Kafka
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Kafka.
-
Connect to Reckon Accounts Hosted from a Connection Pool in WebLogic
Use the CData JDBC Driver for Reckon Accounts Hosted to connect to Reckon Accounts Hosted from Web applications running on WebLogic.
-
Create Excel Online-Connected Business Apps in AppSheet
Connect to Excel Online Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Excel Online.
-
Integrate with live SurveyMonkey Data in Jitterbit
Use CData Connect AI to connect to and integrate live SurveyMonkey in Jitterbit.
-
How to Create Power BI Visual Reports with Real-Time Hubstaff Data
Use CData Power BI Connectors to visualize Hubstaff in Power BI.
-
Using the CData Data Providers with the DevExpress Data Grid
The CData ADO.NET providers are standards-based libraries that can be used with various third-party components and tools. This article shows how to use the CData ADO.NET Provider for Salesforce with the DevExpress Chart Control.
-
How to Connect to Live SurveyMonkey 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 SurveyMonkey for you.
-
Create Epicor Kinetic-Connected Nintex Workflows
Use CData Connect AI to connect to Epicor Kinetic Data from Nintex Workflow Cloud and build custom workflows using live Epicor Kinetic.
-
Build an OLAP Cube in SSAS from Paddle Data
Establish a connection to Paddle data from SQL Server Analysis Services, and use the Paddle Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software JDBC Driver for Omnisend in MicroStrategy
Connect to Omnisend in MicroStrategy Developer using the CData Software JDBC Driver for Omnisend.
-
Visualize Live Instantly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Instantly.
-
Build Visualizations of Gmail Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Gmail in Birst.
-
Automated Continuous OnePageCrm Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable OnePageCrm replication to OneLake in Microsoft Fabric.
-
Query Templated Data in DataGrip
Create a Data Source for Templated in DataGrip and use SQL to query live Templated.
-
Prepare, Blend, and Analyze Oracle Sales Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle Sales for self-service data analytics.
-
Automated Continuous SparkPost Replication to SQLite
Use CData Sync for automated, continuous, customizable SparkPost replication to SQLite.
-
Query, Visualize, and Share live Salesforce Marketing Data in Redash
Use CData Connect AI to connect to live Salesforce Marketing Cloud in Redash for querying, visualizing, and sharing.
-
Use Claude to Talk to Your CockroachDB 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 CockroachDB for you.
-
Replicate NASA Data from PowerShell
Write a quick PowerShell script to query NASA. Use connectivity to the live data to replicate NASA to SQL Server.
-
Create SSAS Tabular Models from Zoho Creator Data
How to build a SQL Server Analysis Service Tabular Model from Zoho Creator using CData drivers.
-
Automate Okta Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Okta from PowerShell? This article demonstrates how to utilize the Okta Cmdlets for tasks like connecting to Okta, automating operations, downloading data, and more.
-
Build an OLAP Cube in SSAS from eBay Analytics Data
Establish a connection to eBay Analytics data from SQL Server Analysis Services, and use the eBay Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from SAP Ariba Source to Google BigQuery using CData SSIS Components.
Easily push SAP Ariba Source to Google BigQuery using the CData SSIS Tasks for SAP Ariba Source and Google BigQuery.
-
How to integrate SparkPost with Apache Airflow
Access and process SparkPost in Apache Airflow using the CData JDBC Driver.
-
Dynamics 365 Business Central Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Dynamics 365 Business Central through CData Connect AI using different applications and tools.
-
Import AlloyDB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google AlloyDB. In this article, you will use the OData format to import Google AlloyDB into Microsoft Power Query.
-
Migrating data from Tanda to Databricks using CData SSIS Components.
Easily push Tanda to Databricks using the CData SSIS Tasks for Tanda and Databricks.
-
Connect to Zoho Recruit Data in RazorSQL
Connect to Zoho Recruit from wizards and query Zoho Recruit from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy
Connect to SAS Data Sets in MicroStrategy Developer using the CData Software JDBC Driver for SAS Data Sets.
-
Create Data Visualizations in Cognos BI with Coinbase Data
Access Coinbase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Antigravity CLI with IBM Cloud Object Storage via CData CLI
Connect IBM Cloud Object Storage to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live Salesforce Marketing Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Salesforce Marketing Cloud from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to JDBC-ODBC Bridge Data in NetBeans
Connect to JDBC-ODBC Bridge in NetBeans with the data source configuration wizard.
-
Visualize Codat Data in Sisense
Create an ElastiCube in Sisense app with access to Codat.
-
How to Query Freshsales Data in MySQL Workbench
Execute MySQL queries against live Freshsales from MySQL Workbench.
-
Query Cvent Data as a SQL Server Database in Node.js
Execute SQL Server queries against Cvent from Node.js.
-
Connect to Kintone Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Kintone from Filemaker Pro on Mac.
-
Build SendGrid-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SendGrid.