CData Software - Knowledge Base
Recent Articles
-
Use Biml to Build SSIS Tasks to Replicate VWO Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate VWO to SQL Server.
-
Integrating GitHub Copilot CLI with Pipedrive 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.
-
Connect to JobNimbus Data in DBArtisan
Use wizards in DBArtisan to configure JobNimbus as a data source.
-
Build SAP SuccessFactors LMS-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP SuccessFactors LMS and build SAP SuccessFactors LMS-connected web apps with Axios.
-
Automated Continuous Amazon S3 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Amazon S3 replication to PostgreSQL.
-
Choosing the Best Method to Connect Workable to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Workable from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to SQL Analysis Services Data in Jaspersoft Studio
Execute SQL to remote SQL Analysis Services in Jaspersoft Studio.
-
Build Apps with Live Airtable in Adalo using CData Connect AI
Use CData Connect AI to integrate live Airtable into the Adalo platform and build custom mobile and web applications with real-time Airtable.
-
Use the CData ODBC Driver for Productboard from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Productboard to connect to Productboard from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Productboard in Excel.
-
Automated Continuous Epicor Kinetic Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Apache Cassandra.
-
Trigger SQL Server IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SQL Server with standard wizards in Logic Apps.
-
Analyze Zoho Projects Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho Projects in Microsoft R Open.
-
Automated Continuous Freshteam Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Freshteam replication to Apache Cassandra.
-
Automated Google Search Results Replication to Teradata
Use CData Sync to Customize and automate Google Search replication to Teradata.
-
Build Semantic Layer Views for Sage Cloud Accounting Data in APOS Live Data Gateway
Use the CData Connector for Sage Cloud Accounting in APOS Live Data Gateway to build Semantic Layer Views for Sage Business Cloud Accounting.
-
Replicate Adobe Commerce Data in Heroku for Use in Salesforce Connect
Replicate Adobe Commerce to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Printify Data with Squirrel SQL client
Connect to Printify and execute queries in the Squirrel SQL Client.
-
How to create Mode federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mode in MySQL .
-
How to connect to PivotalTracker Data from IntelliJ
Integrate connectivity to PivotalTracker with wizards in IntelliJ.
-
How to work with Oracle HCM Cloud Data in Apache Spark using SQL
Access and process Oracle HCM Cloud Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Cvent Data in DBxtra
Create dynamic dashboards and perform analytics based on Cvent in DBxtra.
-
Integrate Live FreshBooks Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live FreshBooks to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Getting Started with the CData Connect AI Python SDK for IBM Informix
Install the CData Connect AI Python SDK to read and write live IBM Informix with standard DB-API 2.0 Python code.
-
How to Use a Microsoft Access Database to Update Teradata Data in Real Time
Update Teradata data by creating a linked table in Microsoft Access with the CData Teradata ODBC Driver.
-
Integrating Claude Code CLI with Guru 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.
-
Model CockroachDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and CockroachDB, enabling the direct import of real-time CockroachDB.
-
How to connect SharePoint with SQL Server Data through external lists
Provide Microsoft SQL Server to SharePoint users as an external list.
-
Viewing SageHR Data in RAD Studio Data Explorer
How to view SageHR in RAD Studio Data Explorer using the CData ODBC Driver for SageHR.
-
Analyze Parallel Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Parallel with the CData JDBC Driver for Parallel.
-
Load Notion Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Notion to a database.
-
Query Neo4J Data as a SQL Server Database in Node.js
Execute SQL Server queries against Neo4J from Node.js.
-
Create Reports with Printful Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Printful.
-
Visualize Snowflake Data in TIBCO Spotfire through ADO.NET
Integrate Snowflake into dashboards in TIBCO Spotfire.
-
Visualize Certinia Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Certinia.
-
Configure the CData JDBC Driver for CircleCI in a Connection Pool in Tomcat
Connect to CircleCI from a connection pool in Tomcat.
-
How to Access Live Opsgenie Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Opsgenie enables you to integrate Opsgenie into workflows built using Microsoft Power Automate Desktop.
-
Use Grok to Talk to Your Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Shopify for you.
-
Access Live Pinecone Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pinecone into the statistical analysis tools available in SAS JMP. This article shows how to use Pinecone in the Graph Builder and Query Builder.
-
Analyze Live Amazon Marketplace Data in SAS Viya
Use CData Connect AI to connect to Amazon Marketplace from SAS Viya and deploy self-service analytics using live Amazon Marketplace.
-
Create Reports from Trello Data in Looker Studio
Use CData Connect AI to gain access to live Trello and create custom reports in Looker Studio.
-
Build Active Directory-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Active Directory and build web apps with connectivity to live Active Directory.
-
Connect to Microsoft Entra ID Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Entra ID and the SQL Gateway to access Microsoft Entra ID from Google Apps Script.
-
Use the CData Software ODBC Driver for Simplesat in MicroStrategy
Connect to Simplesat in MicroStrategy Developer using the CData Software ODBC Driver for Simplesat.
-
Create a Data Access Object for Gong Data using JDBI
A brief overview of creating a SQL Object API for Gong in JDBI.
-
Prepare, Blend, and Analyze SAP Ariba Source Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Ariba Source for self-service data analytics.
-
Visualize Aha! Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Aha!.
-
How to Create Power BI Visual Reports with Real-Time Moosend Data
Use CData Power BI Connectors to visualize Moosend in Power BI.
-
Replicate Excel Data from PowerShell
Write a quick PowerShell script to query Microsoft Excel. Use connectivity to the live data to replicate Microsoft Excel to SQL Server.
-
Connect and Query Live Instagram Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Instagram into Databricks
-
Integrate Zoho Creator Data in the Pentaho Report Designer
Publish reports based on Zoho Creator in the Pentaho BI tool.
-
Automated Continuous Chargebee Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Chargebee replication to Google BigQuery.
-
Build Google Ad Manager-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Ad Manager Data and create custom apps in Bubble.
-
Replicate Multiple SparkPost Accounts
Replicate multiple SparkPost accounts to one or many databases.
-
Operational Reporting on Google Directory Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Directory.
-
Integrate EmailOctopus with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate EmailOctopus with External Services.
-
DataBind Charts to Teamwork Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Teamwork from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use the CData SSIS Components to Insert New or Update Existing Slack Records from SQL Server
Easily push SQL Server data to Slack using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Slack or update existing records with data from a SQL Server database.
-
Query Optimizely Data in DataGrip
Create a Data Source for Optimizely in DataGrip and use SQL to query live Optimizely.
-
Query Coinbase Data in DataGrip
Create a Data Source for Coinbase in DataGrip and use SQL to query live Coinbase.
-
Creating Google Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed Google Analytics to Unqork and build custom business apps.
-
How to Connect to Live Email Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Email securely in real time.
-
Connecting Moonlit Workflow with Google Campaign Manager 360 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 Google Campaign Manager 360 in real time.
-
How to integrate Campaigner with Apache Airflow
Access and process Campaigner in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Act CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Act CRM replication to Oracle.
-
Load HelloSign Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HelloSign to a database.
-
How to connect to Intercom Data with Squirrel SQL client
Connect to Intercom and execute queries in the Squirrel SQL Client.
-
Integrate Onfleet Data in the Pentaho Report Designer
Publish reports based on Onfleet in the Pentaho BI tool.
-
Integrate Sage Cloud Accounting with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sage Cloud Accounting with External Services.
-
Typeform Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Typeform facts in real time.
-
Access Live SAP HANA Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP HANA through MCP integration.
-
Build JSON-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for JSON to explore live JSON Services in Cursor to assist with building JSON-powered applications.
-
Rapidly Develop EnterpriseDB-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 EnterpriseDB.
-
Connect to SendInBlue Data in DBeaver
Use the CData ODBC Driver to connect to SendInBlue in DBeaver.
-
Build Freshdesk-Connected Apps in Choreo
Use CData Connect AI to connect to Freshdesk Data from Choreo and build custom apps using live Freshdesk.
-
Use the CData ODBC Driver for Missive in Microsoft Power Query
You can use the CData Missive ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Missive into Microsoft Power Query.
-
Automate SAS Data Sets Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAS Data Sets and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Query Salesforce Marketing Data in DataGrip
Create a Data Source for Salesforce Marketing in DataGrip and use SQL to query live Salesforce Marketing Cloud.
-
Add Google Translate Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Translate with the Informatica Enterprise Data Catalog to classify and organize data.
-
Process & Analyze Quickbase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Quickbase Data.
-
Access Live SAP Business One Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Business One from your Google Sheets.
-
Automate PivotalTracker Data Replication to Azure Synapse
Use CData Sync to customize and automate PivotalTracker replication to Azure Synapse.
-
Build Azure Table-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Azure Table to explore live Azure Table Data in Gemini Code Assist to assist with building Azure Table-powered applications.
-
Visualize Google Forms Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Forms.
-
Connect to WooCommerce Data from PowerBuilder via ADO.NET
This article demonstrates how to access WooCommerce from Appeon PowerBuilder using the CData ADO.NET Provider for WooCommerce.
-
Integrate Live Oracle HCM Cloud Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle HCM Cloud to Blue Prism using the CData ODBC Driver for Oracle HCM Cloud to create automated workflows for repetitive business tasks.
-
Integrate with Freshdesk Data in JReport Designer
Create charts and reports based on Freshdesk in JReport Designer.
-
Build Charts with Dynamics 365 Business Central Data in Clear Analytics
Create dynamic charts and perform analytics based on Dynamics 365 Business Central in Clear Analytics.
-
Choosing the Best Method to Connect Mailgun to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mailgun from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Import Real-Time ZohoDesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZohoDesk in ColdFusion.
-
Analyze Office 365 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Office 365 with the CData JDBC Driver for Office 365.
-
Connect ConstantContact to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ConstantContact with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Redis Data in Pentaho Data Integration
Build ETL pipelines based on Redis in the Pentaho Data Integration tool.
-
Access Foursquare Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Foursquare.
-
Create Data Visualizations Based On MarkLogic Data in Mode
Use CData Connect AI to connect to MarkLogic Data from Mode and build visualizations using live
-
Analyze Outreach.io Data in Cognos Analytics
Use CData Connect AI to connect to Outreach.io Data from Cognos Analytics and analyze live Outreach.io.
-
Build Automated Workflows with Live Instagram Data in Workato
Use CData Connect AI to connect to live Instagram and build automated workflows in Workato.
-
Replicate Multiple Dynamics 365 Business Central Accounts via the CData Sync CLI
Replicate multiple Dynamics 365 Business Central accounts to one or many databases.
-
Access Live Quickbase Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Quickbase through MCP integration.
-
Access Webex Data from MySQL in PHP
Connect to Webex through the standard MySQL libraries in PHP.
-
Connect to Adobe Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Adobe Analytics as an External Source in Dremio.