CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop IBM Informix-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by IBM Informix.
-
Integrate OpenCode with Live QuickBooks Online Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live QuickBooks Online data from within your AI coding agent.
-
Connect to Autopilot Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Autopilot.
-
How to Connect to Live SAP Concur 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 SAP Concur data through natural language.
-
Access Live ZohoPeople Data in Coginiti Pro
Connect to and query live ZohoPeople data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Sybase Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sybase replication to SingleStore.
-
Automated Continuous LeadDesk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LeadDesk replication to Azure SQL Database.
-
Connect to Suadeo in SpagoBI
Create reports featuring live Suadeo data in SpagoBI Studio. Host Suadeo reports on SpagoBI Server.
-
Visualize Perplexity 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 Perplexity data into TIBCO Spotfire.
-
Connect to Sage Intacct Data from HeidiSQL
Use CData Connect AI to connect to and query live Sage Intacct data from HeidiSQL.
-
Getting Started with the CData JDBC Driver for Google Contacts
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Contacts.
-
Build Semantic Layer Views for Oracle Eloqua Data in APOS Live Data Gateway
Use the CData Connector for Oracle Eloqua in APOS Live Data Gateway to build Semantic Layer Views for Oracle Eloqua data.
-
How to Connect Flowise AI Agents to Live Salesforce Data 360 Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Salesforce Data 360 data without replication.
-
Query ShipStation Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ShipStation data from Node.js.
-
Automated Continuous GraphQL Replication to MongoDB
Use CData Sync for automated, continuous, customizable GraphQL replication to MongoDB.
-
Create Informatica Mappings From/To an ODBC Data Source for Pushbullet
Create an ODBC connection to Pushbullet in Informatica and browse and transfer Pushbullet data.
-
Connecting Moonlit Workflow with Pinterest Data 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 Pinterest data in real time.
-
How to Connect DBeaver to Snowflake via a JDBC Driver
Manage Snowflake data with visual tools in DBeaver like the query browser.
-
Connecting GenSpark with HBase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to HBase data without any replication or custom integration required.
-
Excel Spreadsheet Automation on Zoho Creator Data with the QUERY Formula
Pull data from Zoho Creator, automate spreadsheets, and more with the QUERY formula.
-
How to connect to HubSpot Data in DBVisualizer
Integrate HubSpot data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData ODBC Driver for Typeform from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Typeform to connect to Typeform data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Typeform data in Excel.
-
Build Apps with Live SAP Concur data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Concur data into the Adalo platform and build custom mobile and web applications with real-time SAP Concur data.
-
Create Data Visualizations Based On SAP SuccessFactors LMS Data in Mode
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Mode and build visualizations using live SAP SuccessFactors LMS data.
-
Write a Simple Go Application to work with SingleStore Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SingleStore data.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Drive
Create Google Drive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SurveyMonkey Data in RazorSQL
Connect to SurveyMonkey from wizards and query SurveyMonkey data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Campaigner Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Campaigner replication to AlloyDB.
-
Build Agents in Relevance AI with Access to Live Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Kafka data within intelligent agent workflows.
-
Integrate with SAP HANA XS Advanced Data in JReport Designer
Create charts and reports based on SAP HANA XS Advanced data in JReport Designer.
-
How to Connect DBeaver to Email via a JDBC Driver
Manage Email data with visual tools in DBeaver like the query browser.
-
How to Work with Cassandra Data in AWS Glue Jobs Using JDBC
Connect to Cassandra from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Entra ID Data
Use CData Power BI Connectors to visualize Microsoft Entra ID data in Power BI.
-
Create Jira Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Jira from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate Google Cloud Storage Data to Multiple Databases via the CData Sync CLI
Replicate Google Cloud Storage data to disparate databases with a single configuration.
-
Integrate ZohoSubscriptions Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoSubscriptions data from Informatica Cloud.
-
Connect to Trello Data in Ruby
Connect to Trello data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Stream Azure Data Catalog Data into Apache Kafka Topics
Access and stream Azure Data Catalog data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Microsoft Planner Replication to Snowflake
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Snowflake.
-
Back Up Access data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Access. In this article, we will employ an SSIS workflow to populate a database with Access data data.
-
Integrate Live Avalara AvaTax Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Avalara AvaTax data and integrate live Avalara AvaTax data into apps built in Microsoft Power Apps.
-
Getting Started with the CData Tableau Connector for Jodoo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP
Create an ODBC connection to SAP in Informatica and browse and transfer SAP data.
-
Create Microsoft Exchange Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Exchange from PowerBI.com to create Power BI Dataflows with real-time data.
-
Easily Integrate Redshift Data in Lazarus Pascal IDE
Learn how to easily integrate live Redshift data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Attio Data from MySQL in Amazon QuickSight
Connect to Attio and build visualizations of Attio data using a MySQL Connection in Amazon QuickSight.
-
Configure the CData JDBC Driver for Kintone in a Connection Pool in Tomcat
Connect to Kintone data from a connection pool in Tomcat.
-
Stream Mixpanel Data into Apache Kafka Topics
Access and stream Mixpanel data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Explore Geographical Relationships in Recurly Data with Power Map
Create data visualizations with Recurly data in Power Map.
-
Stream Dynamics 365 Data into Apache Kafka Topics
Access and stream Dynamics 365 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Google Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Ads replication to AlloyDB.
-
Use the CData Software JDBC Driver for PhantomBuster in MicroStrategy
Connect to PhantomBuster data in MicroStrategy Developer using the CData Software JDBC Driver for PhantomBuster.
-
Getting Started with the CData JDBC Driver for MailerLite
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MailerLite.
-
A PostgreSQL Interface for Google Tasks Data using the CData ODBC Driver
Use the SQL Gateway and Google Tasks ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Mailjet Data in Excel 365 Online (Excel for the web)
Connect to Mailjet data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to ElevenLabs Data from PowerBuilder via ADO.NET
This article demonstrates how to access ElevenLabs data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to and Visualize Live Microsoft Exchange Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Exchange data.
-
How to connect to Dynamics NAV Data in DBVisualizer
Integrate Dynamics NAV data with visual data analysis tools and data connection wizards in DBVisualizer
-
Migrating data from Printify to Snowflake using CData SSIS Components.
Easily push Printify data to Snowflake using the CData SSIS Tasks for Printify and Snowflake.
-
GitHub Reporting in OBIEE with the GitHub JDBC Driver
Deploy the GitHub JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Trae with Live Google Contacts Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Google Contacts data from within the AI-powered IDE.
-
Connect to LDAP Objects from a Connection Pool in JBoss
Integrate LDAP objects into Java servlets: Use the Management Console in JBoss to install the LDAP JDBC Driver.
-
Build ZohoMarketingHub-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live ZohoMarketingHub data without replication.
-
Publish Bannerbear-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bannerbear data.
-
Automated Continuous Google Contacts Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Contacts data replication to OneLake in Microsoft Fabric.
-
Create Webex Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Webex from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Acumatica Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Acumatica replication to delimited files (CSV/TSV).
-
Query ChartMogul Data in DataGrip
Create a Data Source for ChartMogul in DataGrip and use SQL to query live ChartMogul data.
-
A PostgreSQL Interface for Dynamics 365 Business Central Data (MySQL Remoting via JDBC)
Use the Remoting features of the Dynamics 365 Business Central JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Excel Add-In for LDAP
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LDAP.
-
Build a PostgreSQL Interface for Telegram Data using the CData JDBC Driver
Use the Remoting features of the Telegram JDBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for Beeminder in PyCharm
Connect to Beeminder as an ODBC data source in PyCharm using the CData Software ODBC Driver for Beeminder.
-
Analyze Perplexity Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Perplexity from Power Pivot. You will use the Table Import Wizard to load Perplexity data. You can visually build the import query or use any SQL supported by the driver.
-
Connect Tanda Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Tanda data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Zoom-Connected Nintex Workflows
Use CData Connect AI to connect to Zoom Data from Nintex Workflow Cloud and build custom workflows using live Zoom data.
-
Create a Data Access Object for Copper Data using JDBI
A brief overview of creating a SQL Object API for Copper data in JDBI.
-
How to Connect Greenplum Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Greenplum data in real time using natural language.
-
Automated Continuous Access Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Access replication to AlloyDB.
-
How to load Wave Financial data into Elasticsearch via Logstash
Introducing a simple method to load Wave Financial data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect PolyBase to PostgreSQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PostgreSQL data.
-
Build SAP Hybris C4C Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Hybris C4C data and build visualizations in Tableau.
-
Create Datasets from Printful in Domo Workbench and Build Visualizations of Printful Data in Domo
Use the CData Software ODBC Driver for Printful to create datasets from Printful data in Domo Workbench and then build visualizations in the Domo service.
-
Build Voice Agents in ElevenLabs with access to Live Oracle Service Cloud Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle Service Cloud data.
-
How to Access Live Procore Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Procore enables you to integrate Procore data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Sage 200 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sage 200 replication to SingleStore.
-
Integrating Codex with QuickBooks 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 connect to Facebook Ads Data with Squirrel SQL client
Connect to Facebook Ads data and execute queries in the Squirrel SQL Client.
-
Use Biml to Build SSIS Tasks to Replicate Klaviyo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Klaviyo data to SQL Server.
-
Connect to Teamgate Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Teamgate data.
-
Automated Continuous Tanda Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Tanda replication to delimited files (CSV/TSV).
-
Import Google Directory Data Using Azure Data Factory
Use CData Connect AI to connect to Google Directory Data from Azure Data Factory and import live Google Directory data.
-
How to import Scrapfly Data into Apache Solr
Use the CData Software JDBC Driver for Scrapfly in Data Import Handler and create an automated import of Scrapfly data to Apache Solr Enterprise Search platform.
-
How to Create Power BI Visual Reports with Real-Time Parallel Data
Use CData Power BI Connectors to visualize Parallel data in Power BI.
-
Manage Autopilot Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Autopilot.
-
Access Live Mailgun Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mailgun data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Avaza Data in Pentaho Data Integration
Build ETL pipelines based on Avaza data in the Pentaho Data Integration tool.
-
Access Live Shippo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Shippo data from your Google Sheets.
-
Using the CData Software ODBC Driver for SuiteCRM in PyCharm
Connect to SuiteCRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for SuiteCRM.
-
Access Live Exact Online 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 Exact Online data through MCP integration.
-
Query Paymo Data in ColdFusion
Write standard ColdFusion data access code to connect to Paymo data.