CData Software - Knowledge Base
Recent Articles
-
How to connect to Dynamics CRM from Spring Boot
Connect to Dynamics CRM in a Spring Boot Application using CData JDBC Dynamics CRM Driver
-
Connect to Impala from a Connection Pool in WebLogic
Use the CData JDBC Driver for Impala to connect to Apache Impala from Web applications running on WebLogic.
-
How to Query Live ClickUp Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ClickUp data in natural language using Python.
-
Build Splunk-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Splunk and create custom apps in Bubble.
-
How to create Visio diagrams from Outreach.io
Automatically update Outreach.io with the changes you make to Visio master shapes.
-
Automated Continuous Drift Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Drift replication to Apache Cassandra.
-
Connect to Facebook in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import Zoho Inventory Using Azure Data Factory
Use CData Connect AI to connect to Zoho Inventory from Azure Data Factory and import live Zoho Inventory.
-
How to load Outreach.io data into Elasticsearch via Logstash
Introducing a simple method to load Outreach.io data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft Teams
Create Microsoft Teams data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to eBay in Jaspersoft Studio
Execute SQL to remote eBay in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for OData in MicroStrategy Desktop
Connect to OData in MicroStrategy Desktop using the CData Software ODBC Driver for OData.
-
Connect to Shippo from a Connection Pool in JBoss
Integrate Shippo into Java servlets: Use the Management Console in JBoss to install the Shippo JDBC Driver.
-
Analyze Airtable in Looker
Use CData Connect AI to connect to Airtable from Looker and build custom apps using live Airtable.
-
Query Zoho Projects as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Projects from Node.js.
-
Connect to SAP BusinessObjects BI in Aqua Data Studio
Access SAP BusinessObjects BI from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to use SQLAlchemy ORM to access Salesloft in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesloft.
-
Analyze Klipfolio in Infragistics Reveal
Use the CData API Server to create an OData API on top of Klipfolio and visualize live Klipfolio in Infragistics Reveal.
-
Query Oracle Sales in DataGrip
Create a Data Source for Oracle Sales in DataGrip and use SQL to query live Oracle Sales.
-
How to pipe Adobe Commerce to CSV in PowerShell
Use standard PowerShell cmdlets to access Adobe Commerce tables.
-
Connect to Salesforce Data Cloud in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesforce Data Cloud in the Denodo Virtual DataPort Administrator.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon DynamoDB within intelligent workflows.
-
Stream Facebook into Apache Kafka Topics
Access and stream Facebook in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize BambooHR in TIBCO Spotfire through ADO.NET
Integrate BambooHR into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle
Create an ODBC connection to Oracle in Informatica and browse and transfer Oracle Database.
-
Using the CData Software ODBC Driver for SAP Netweaver Gateway in PyCharm
Connect to SAP Netweaver Gateway as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Connect to Clio in DBeaver
Use the CData ODBC Driver to connect to Clio in DBeaver.
-
Build Agents in Relevance AI with Access to Live Salesforce Marketing via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce Marketing Cloud within intelligent agent workflows.
-
Use the CData Software JDBC Driver for Parquet in MicroStrategy
Connect to Apache Parquet in MicroStrategy Developer using the CData Software JDBC Driver for Parquet.
-
Use the CData ODBC Driver for Xero in Microsoft Power Query
You can use the CData Xero ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Xero Accounting into Microsoft Power Query.
-
Automated Continuous GitHub Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable GitHub replication to delimited files (CSV/TSV).
-
How to publish and share MYOB AccountRight dashboards with Tableau Server
The CData ODBC driver for MYOB AccountRight enables you integrate MYOB AccountRight into Tableau dashboards.
-
Integrating Claude Code with Elasticsearch via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Elasticsearch within assisted coding and automated development workflows.
-
Create Power BI Reports on Real-Time Acumatica
Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop.
-
Connect to Sage 200 from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sage 200 from Filemaker Pro on Mac.
-
How to Access Live Google Spanner in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Spanner enables you to integrate Google Spanner into workflows built using Microsoft Power Automate Desktop.
-
Feed FHIR into FineReport
How to set FHIR as a JDBC data source in FineReport.
-
Automated Continuous Salesforce Replication to SQLite
Use CData Sync for automated, continuous, customizable Salesforce replication to SQLite.
-
Access Live Dynamics CRM in AWS Lambda
Connect to live Microsoft Dynamics CRM in AWS Lambda using the CData JDBC Driver.
-
Access Live SharePoint Excel Services in Coginiti Pro
Connect to and query live SharePoint Excel Services from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Perform Batch Operations with REST in Apache NiFi
Connect to REST and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Feed ActiveCampaign into FineReport
How to set ActiveCampaign as a JDBC data source in FineReport.
-
Getting Started with the CData Excel Add-In for NetSuite
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for NetSuite.
-
Create Dashboards and Visualize Live Azure Data Lake Storage in Geckoboard
Use CData Connect AI to connect to live Azure Data Lake Storage and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize Live Redshift in the Power BI Service
Use CData Connect AI to connect to live Amazon Redshift and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Klipfolio in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Klipfolio into TIBCO Spotfire.
-
Connect to GitHub in DBeaver
Use the CData ODBC Driver to connect to GitHub in DBeaver.
-
Create GraphQL-Connected Dashboards in Grafana
Connect to GraphQL via CData Connect AI in Grafana and create custom business dashboards with real-time access to GraphQL.
-
DataBind Controls to Cosmos DB in Delphi
DataBind to Azure Cosmos DB in Delphi with standard data access components and controls.
-
Automate QuickBooks Online Replication to Azure Synapse
Use CData Sync to customize and automate QuickBooks Online replication to Azure Synapse.
-
Prepare, Blend, and Analyze Greenplum in Alteryx Designer (Connect AI)
Build workflows to access live Pivotal GreenPlum for self-service data analytics.
-
Use the CData Software JDBC Driver for Exact Online in MicroStrategy
Connect to Exact Online in MicroStrategy Developer using the CData Software JDBC Driver for Exact Online.
-
Analyze Epicor Kinetic in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Epicor Kinetic in Microsoft R Open.
-
Integrate with live Zoho Creator in Jitterbit
Use CData Connect AI to connect to and integrate live Zoho Creator in Jitterbit.
-
Create Dynamic NetSuite Grids Using the Infragistics XamDataGrid
Learn how you can connect NetSuite to Infragistics XamDataGrid to build dynamic grids.
-
Process & Analyze Splunk in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Splunk .
-
Choosing the Best Method to Connect Oracle Eloqua to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Eloqua from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Dynamics 365 Business Central from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Dynamics 365 Business Central for you.
-
Connect to ServiceNow from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ServiceNow from Filemaker Pro on Mac.
-
Build Google Search-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Search.
-
Consume Sybase IQ OData Feeds in PowerBuilder
This article demonstrates how to consume Sybase IQ as OData feeds from PowerBuilder using the API Server.
-
How to Access Live Excel in Power Automate Desktop via ODBC
The CData ODBC Driver for Excel enables you to integrate Microsoft Excel into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Sage 50 UK to Google BigQuery using CData SSIS Components.
Easily push Sage 50 UK to Google BigQuery using the CData SSIS Tasks for Sage 50 UK and Google BigQuery.
-
Connect to OData Services as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for OData.
-
Connect to MongoDB in Ruby
Connect to MongoDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Dynamics 365 from MySQL in Amazon QuickSight
Connect to Dynamics 365 and build visualizations of Microsoft Dynamics 365 using a MySQL Connection in Amazon QuickSight.
-
Connect to AlloyDB in RapidMiner
Integrate Google AlloyDB with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for JotForm in MicroStrategy Desktop
Connect to JotForm in MicroStrategy Desktop using the CData Software ODBC Driver for JotForm.
-
How to Connect the Power BI Service to HarperDB: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous Aha Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Aha replication to AlloyDB.
-
Use the CData Software JDBC Driver for Salesforce in MicroStrategy Web
Connect to Salesforce & Force.com in MicroStrategy Web using the CData Software JDBC Driver for Salesforce.
-
Connect to Dropbox in Claris FileMaker Pro
-