CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Oracle Service Cloud in MicroStrategy Web
Connect to Oracle Service Cloud in MicroStrategy Web using the CData Software JDBC Driver for Oracle Service Cloud.
-
Connect to Google Forms Data in Jaspersoft Studio
Execute SQL to remote Google Forms in Jaspersoft Studio.
-
Use the CData ODBC Driver for Pipeliner CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Pipeliner CRM to connect to Pipeliner CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pipeliner CRM in Excel.
-
Automate PhantomBuster Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PhantomBuster from PowerShell? This article demonstrates how to utilize the PhantomBuster Cmdlets for tasks like connecting to PhantomBuster, automating operations, downloading data, and more.
-
Use ChatGPT to Talk to Your ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ADP for you.
-
How to Connect Flowise AI Agents to Live SAP BusinessObjects BI 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 SAP BusinessObjects BI without replication.
-
Publish Reply.io-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Reply.io.
-
Use Dash to Build to Web Apps on ElevenLabs Data
Create Python applications that use pandas and Dash to build ElevenLabs-connected web apps.
-
Create Reports from Phoenix Data in Looker Studio
Use CData Connect AI to gain access to live Apache Phoenix and create custom reports in Looker Studio.
-
Automated Continuous Sendwithus Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sendwithus replication to AlloyDB.
-
Connect to ConstantContact from a Connection Pool in WebLogic
Use the CData JDBC Driver for ConstantContact to connect to ConstantContact from Web applications running on WebLogic.
-
Integrating Codex CLI with QuickBooks Time 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.
-
Work with Contentful Data in FoxPro
Load Contentful into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Apollo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apollo and visualize Apollo in SAP Analytics Cloud.
-
Natively Connect to Airtable Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Airtable. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData SSIS Components for Gorgias
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Gorgias.
-
Automated Continuous Testmonitor Replication to Oracle
Use CData Sync for automated, continuous, customizable Testmonitor replication to Oracle.
-
Automate Sugar CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Sugar CRM replication to Couchbase.
-
Connect to BambooHR Data from a Connection Pool in JBoss
Integrate BambooHR into Java servlets: Use the Management Console in JBoss to install the BambooHR JDBC Driver.
-
How to Easily Query Workday Data in OpenOffice Base
Connect to Workday data in OpenOffice Base using the CData ODBC Driver for Workday and generate reports with live data insights.
-
Use the CData ODBC Driver for Nuclia from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Nuclia to connect to Nuclia from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Nuclia in Excel.
-
Replicate SendInBlue Data to Multiple Databases via the CData Sync CLI
Replicate SendInBlue to disparate databases with a single configuration.
-
Build ZarMoney-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZarMoney.
-
Integrating Microsoft Exchange Data in Talend Cloud Data Management Platform
Connect Microsoft Exchange Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft Exchange.
-
Automated Continuous LeadDesk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LeadDesk replication to Apache Kafka.
-
Connect to Vimeo Data in DBeaver
Use the CData ODBC Driver to connect to Vimeo in DBeaver.
-
Publish ScrapingBee-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ScrapingBee.
-
Automated Continuous OnePageCrm Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable OnePageCrm replication to PostgreSQL.
-
Prepare, Blend, and Analyze WordPress Data in Alteryx Designer (Connect AI)
Build workflows to access live WordPress for self-service data analytics.
-
How to use SQLAlchemy ORM to access Pipeline CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pipeline CRM.
-
Natively Connect to Elasticsearch Data in PHP
The CData ODBC driver for Elasticsearch enables you to create PHP applications with connectivity to Elasticsearch. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with Sage 200 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage 200.
-
Configure the CData JDBC Driver for Oracle Sales in a Connection Pool in Tomcat
Connect to Oracle Sales from a connection pool in Tomcat.
-
How to Connect Flowise AI Agents to Live Adobe Commerce 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 Adobe Commerce without replication.
-
Integrate Cline with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Acumatica ERP from within your IDE.
-
Connect to Neo4J Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Neo4J from Filemaker Pro on Mac.
-
Create Dynamic Microsoft Exchange Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Exchange to Infragistics XamDataGrid to build dynamic grids.
-
How to Access ZohoMarketingHub Data Using Entity Framework
This article shows how to access ZohoMarketingHub using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Publish Calendly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Calendly.
-
Excel Spreadsheet Automation on Mailgun Data with the QUERY Formula
Pull data from Mailgun, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous ServiceNow Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ServiceNow replication to OneLake in Microsoft Fabric.
-
Build Microsoft Dataverse-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Microsoft Dataverse to explore live Microsoft Dataverse Data in GitHub Copilot to assist with building Microsoft Dataverse-powered applications.
-
Import Real-Time Snapchat Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Snapchat Ads in ColdFusion.
-
Integrate Live FTP Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to FTP Servers and integrate live FTP Servers into apps built in Microsoft Power Apps.
-
Connect to Oracle HCM Cloud from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle HCM Cloud, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize BigQuery Data in Sisense
Create an ElastiCube in Sisense app with access to Google BigQuery.
-
How to Connect to Sage Cloud Accounting Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sage Business Cloud Accounting. Leverage the pyodbc module for ODBC in Python.
-
Replicate MailerLite Data to Multiple Databases via the CData Sync CLI
Replicate MailerLite to disparate databases with a single configuration.
-
Integrate Amplitude Data in Pentaho Data Integration
Build ETL pipelines based on Amplitude in the Pentaho Data Integration tool.
-
Access Live Onfleet Data in Coginiti Pro
Connect to and query live Onfleet from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Kiro CLI with SAP SuccessFactors 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 PolyBase to DB2
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM DB2.
-
Easily Integrate SharePoint Excel Services Data in Lazarus Pascal IDE
Learn how to easily integrate live SharePoint Excel Services in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Real-Time Jumpseller Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Jumpseller in Power Apps.
-
Create SSAS Tabular Models from Excel Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Excel using CData drivers.
-
Natively Connect to ChargeOver Data in PHP
The CData ODBC driver for ChargeOver enables you to create PHP applications with connectivity to ChargeOver. Leverage the native support for ODBC in PHP.
-
Query Close Data as a MySQL Database in Node.js
Execute MySQL queries against Close from Node.js.
-
Automated Continuous QuickBooks Time Replication to SQL Server
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to SQL Server.
-
Getting Started with the CData ADO.NET Provider for FHIR
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for FHIR.
-
Connect to SendGrid Data in DBArtisan
Use wizards in DBArtisan to configure SendGrid as a data source.
-
Connect and Visualize Live HCL Domino Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live HCL Domino into the Databricks platform and create visualization dashboards with real-time HCL Domino.
-
Connect to Unbounce Data from a Connection Pool in Jetty
The Unbounce JDBC Driver supports connection pooling: This article shows how to connect faster to Unbounce from Web apps in Jetty.
-
Connect to Office 365 Data in RapidMiner
Integrate Microsoft Office 365 with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Vault CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Vault CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Veeva Vault & Vault CRM.
-
Connecting Pipedream with Procore Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Procore data in real time.
-
Integrating OpenCode Terminal with Pinecone 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 Seamlessly Import Cloudant Data into IBM SPSS Modeler
Integrate Cloudant data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Adobe Target Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Adobe Target.
-
Integrate with HCL Domino Data in JReport Designer
Create charts and reports based on HCL Domino in JReport Designer.
-
Getting Started with the CData Excel Add-In for ClickTime
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ClickTime.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Everhour
Provide connectivity to Everhour through an SAP BusinessObjects universe.
-
Connecting Pipedream with Kintone Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Kintone data in real time.
-
Integrating Kiro CLI with Zoom 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.
-
Connect to and Visualize Live Redshift Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon Redshift.
-
Visualize Live SAS Data Sets Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAS Data Sets into custom reports in Power BI.
-
Integrate PabblySubscriptions with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PabblySubscriptions with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PabblySubscriptions.
-
How to load Authorize.Net data into Elasticsearch via Logstash
Introducing a simple method to load Authorize.Net data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Data Visualizations Based On Paylocity Data in Mode
Use CData Connect AI to connect to Paylocity Data from Mode and build visualizations using live
-
Explore Geographical Relationships in Codat Data with Power Map
Create data visualizations with Codat in Power Map.
-
Load BigQuery Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google BigQuery to a database.
-
Build Dashboards with Postmark Data in Dundas BI
Create dynamic dashboards and perform analytics based on Postmark in Dundas BI.
-
Access Live Raisers Edge NXT Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Raisers Edge NXT data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Nethunt Data in RapidMiner
Integrate Nethunt with standard components and data source configuration wizards in RapidMiner Studio.
-
Query FHIR Data in DataGrip
Create a Data Source for FHIR in DataGrip and use SQL to query live FHIR.
-
Automated Continuous BenchmarkEmail Replication to MongoDB
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to MongoDB.
-
Replicate Multiple Google Cloud Storage Accounts
Replicate multiple Google Cloud Storage accounts to one or many databases.
-
Extract, Transform, and Load Shortcut Data in Informatica PowerCenter
Create a simple Workflow for Shortcut in Informatica PowerCenter.
-
Build an OLAP Cube in SSAS from Superchat Data
Establish a connection to Superchat data from SQL Server Analysis Services, and use the Superchat Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Procore Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Replicate JSON Services to Multiple Databases via the CData Sync CLI
Replicate JSON to disparate databases with a single configuration.
-
Establish a Live Connection with Workday Data using Tableau Bridge
The CData ODBC Driver for Workday enables you to integrate live Workday into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Adobe Experience Manager Data in HULFT Integrate
Connect to Adobe Experience Manager as a JDBC data source in HULFT Integrate
-
Connect to Customer.io Data from a Connection Pool in JBoss
Integrate Customer.io into Java servlets: Use the Management Console in JBoss to install the Customer.io JDBC Driver.
-
Integrate ServiceDesk Plus Data in Pentaho Data Integration
Build ETL pipelines based on ServiceDesk Plus in the Pentaho Data Integration tool.
-
Viewing IBM Cloud Object Storage Data in RAD Studio Data Explorer
How to view IBM Cloud Object Storage in RAD Studio Data Explorer using the CData ODBC Driver for IBM Cloud Object Storage.
-
Connecting Agentforce with Redis Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Redis for you.
-
SSIS Components Getting Started Guide
A basic guide to using the CData SSIS Components for Salesforce to transfer data into a MS SQL Server database.
-
View Reports on Real-Time EnterpriseDB Data in Power BI Report Server
Use the CData ODBC Driver for EnterpriseDB to visualize EnterpriseDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Moving Data from Kintone to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Kintone data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to import Microsoft Teams Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft Teams in Data Import Handler and create an automated import of Microsoft Teams to Apache Solr Enterprise Search platform.