CData Software - Knowledge Base
Recent Articles
-
Connect to Oracle Eloqua Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Eloqua and the Script function in FileMaker Pro to connect to Oracle Eloqua and work with Oracle Eloqua in your FileMaker application.
-
Automated Continuous Microsoft Dataverse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Google BigQuery.
-
Publish Reports with MarkLogic Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MarkLogic.
-
Connect to Real-Time Dynamics CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Dynamics CRM and Dataflow to import and use Microsoft Dynamics CRM in Power Apps.
-
Connect to SAP Hybris C4C Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Hybris C4C from HeidiSQL.
-
Connect to Auth0 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Auth0 as an External Source in Dremio.
-
Automate Printify Data Replication to Couchbase
Use CData Sync to Customize and automate Printify replication to Couchbase.
-
How to Create Power BI Visual Reports with Real-Time ShipEngine Data
Use CData Power BI Connectors to visualize ShipEngine in Power BI.
-
Visualize Live Google Directory Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Directory using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Facebook Ads Data in PHP
The CData ODBC driver for Facebook Ads enables you to create PHP applications with connectivity to Facebook Ads. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for Azure Synapse in Microsoft Power Query
You can use the CData Azure Synapse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Synapse into Microsoft Power Query.
-
How to work with Zuora Data in Apache Spark using SQL
Access and process Zuora Data in Apache Spark using the CData Software JDBC Driver.
-
How to work with Klaviyo Data in Apache Spark using SQL
Access and process Klaviyo Data in Apache Spark using the CData Software JDBC Driver.
-
Build MVC Applications with Connectivity to Outlook Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Outlook from an ASP.NET MVC application.
-
Provide OData Services of Coda Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Coda by developing a WCF Service Application.
-
Use JayDeBeApi to access SparkPost Data in Python
Use standard Python scripting and the development environment of your choice to access live SparkPost.
-
Integrate Cline with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Avalara AvaTax from within your IDE.
-
Connect to Webflow Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Webflow.
-
Connect to Miro Data from a Connection Pool in Jetty
The Miro JDBC Driver supports connection pooling: This article shows how to connect faster to Miro from Web apps in Jetty.
-
Working with Cohere Data in LINQPad
Execute LINQ queries to Cohere in LINQPad.
-
Process & Analyze FTP Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live FTP Data.
-
Replicate Rootly Data from PowerShell
Write a quick PowerShell script to query Rootly. Use connectivity to the live data to replicate Rootly to SQL Server.
-
Integrating Everhour Data in Talend Cloud Data Management Platform
Connect Everhour Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to load MessageBird data into Elasticsearch via Logstash
Introducing a simple method to load MessageBird data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Insightly in MicroStrategy Desktop
Connect to Insightly in MicroStrategy Desktop using the CData Software ODBC Driver for Insightly.
-
LINQ to Strava Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Strava Data Provider.
-
How to Connect to Exact Online Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Exact Online. Leverage the pyodbc module for ODBC in Python.
-
Connect to Postmark Data in RazorSQL
Connect to Postmark from wizards and query Postmark from the GUI in the RazorSQL database management tool.
-
Consume Exact Online OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Exact Online feeds that reflect any changes in SAP Lumira.
-
Use Manus AI to Talk to Your Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Atlassian Confluence.
-
Integrating LangChain with API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on API within automated workflows.
-
Analyze Float Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Float with the CData JDBC Driver for Float.
-
Integrate SAP SuccessFactors Data in Pentaho Data Integration
Build ETL pipelines based on SAP SuccessFactors in the Pentaho Data Integration tool.
-
Getting Started with the CData ADO.NET Provider for Google Spanner
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Spanner.
-
Design BIRT Reports on Oracle Service Cloud Data
Provide current Oracle Service Cloud to your embedded analytics.
-
Automated Continuous Asana Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Asana replication to IBM DB2.
-
Connect to SAP SuccessFactors Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP SuccessFactors from Appeon PowerBuilder using the CData ADO.NET Provider for SAP SuccessFactors.
-
Connect to PabblySubscriptions Data in NetBeans
Connect to PabblySubscriptions in NetBeans with the data source configuration wizard.
-
Query FTP Data in ColdFusion
Write standard ColdFusion data access code to connect to FTP Servers.
-
How to import MySQL Data into Apache Solr
Use the CData Software JDBC Driver for MySQL in Data Import Handler and create an automated import of MySQL to Apache Solr Enterprise Search platform.
-
Integrating Sybase Data in Talend Cloud Data Management Platform
Connect Sybase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sybase.
-
Natively Connect to FTP Data in PHP
The CData ODBC driver for FTP enables you to create PHP applications with connectivity to FTP Servers. Leverage the native support for ODBC in PHP.
-
Build Salesforce-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Salesforce to explore live Salesforce Data in Gemini Code Assist to assist with building Salesforce-powered applications.
-
Build Apps with Live Gong Data Using the Low-Code Development Platform of Mendix
Connect Gong with Mendix to build apps using the CData API Driver for JDBC.
-
How to connect and process Postmark from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Postmark.
-
Use Agno to Talk to Your WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your WooCommerce for you.
-
Anaplan Reporting in OBIEE with the Anaplan JDBC Driver
Deploy the Anaplan JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Explore Geographical Relationships in ServiceNow Data with Power Map
Create data visualizations with ServiceNow in Power Map.
-
Consume Google Cloud Storage OData Feeds in PowerBuilder
This article demonstrates how to consume Google Cloud Storage as OData feeds from PowerBuilder using the API Server.
-
Create Marketo-Connected Applications in Appsmith
Connect to Marketo Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Marketo.
-
Migrating data from Oracle Financials Cloud to Snowflake using CData SSIS Components.
Easily push Oracle Financials Cloud to Snowflake using the CData SSIS Tasks for Oracle Financials Cloud and Snowflake.
-
Getting Started with the CData ADO.NET Provider for Pingdom
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze ShipStation Data in Looker
Use CData Connect AI to connect to ShipStation Data from Looker and build custom apps using live ShipStation.
-
Copper Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Copper facts in real time.
-
How to Visualize Pipedrive Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pipedrive in Python.
-
Integrate Live Zoho Books Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Books to Blue Prism using the CData ODBC Driver for Zoho Books to create automated workflows for repetitive business tasks.
-
Integrating Claude Code CLI with Salesforce CRM Analytics 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.
-
Automated Continuous Google Forms Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Forms replication to Oracle.
-
Moving Data from Azure Data Catalog to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Data Catalog data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Automated eBay-Connected Workflows in Zapier
Use CData Connect AI to connect to live eBay and build automated workflows in Zapier.
-
How to connect PolyBase to Google Ad Manager
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Ad Manager.
-
Connect to Real-Time ServiceNow Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ServiceNow and Dataflow to import and use ServiceNow in Power Apps.
-
How to create Shortcut federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Shortcut in MySQL .
-
Visualize Live Trello Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Trello.
-
Access ConstantContact Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ConstantContact from HeidiSQL.
-
Create Cloudant-Connected Dashboards in Grafana
Connect to Cloudant Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to IBM Cloudant.
-
DataBind ZohoMarketingHub Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoMarketingHub to a chart.
-
Load Amazon DynamoDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon DynamoDB to a database.
-
Moosend Reporting in OBIEE with the Moosend JDBC Driver
Deploy the Moosend JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect Salesforce to SQL Server with SSIS
Easily back-up Salesforce data to SQL Server using the CData ADO.NET Provider for Salesforce. This example uses an SSIS workflow to populate a database with Salesforce data using the CData ADO.NET Data Provider for Salesforce.
-
Create Reports with Reckon Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Reckon.
-
Easily Integrate Avalara AvaTax Data in Lazarus Pascal IDE
Learn how to easily integrate live Avalara AvaTax in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Choosing the Best Method to Connect Couchbase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Couchbase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to QuickBooks from Asprova with CData Software ODBC Driver for QuickBooks
This article shows how to connect faster to QuickBooks data from Asprova.
-
Migrating data from PayPal to Google BigQuery using CData SSIS Components.
Easily push PayPal to Google BigQuery using the CData SSIS Tasks for PayPal and Google BigQuery.
-
How to connect to SAP Concur Data from Spring Boot
Connect to SAP Concur in a Spring Boot Application using the CData JDBC Driver for SAP Concur
-
Publish ChargeOver-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ChargeOver.
-
Integrate with Live Salesforce Pardot Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Pardot from the MuleSoft Anypoint Platform to integrate live Salesforce Pardot into custom reports and dashboards.
-
Add Power BI XMLA Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Power BI XMLA with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Amazon DynamoDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amazon DynamoDB to Blue Prism using the CData ODBC Driver for Amazon DynamoDB to create automated workflows for repetitive business tasks.
-
Manage Reckon Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Reckon.
-
Connect to Wrike Data from a Connection Pool in Jetty
The Wrike JDBC Driver supports connection pooling: This article shows how to connect faster to Wrike from Web apps in Jetty.
-
Getting Started with the CData Python Connector for Jira Assets
Learn to install and license the CData Python Connector
-
Integrating GitHub Copilot CLI with Sage 300 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.
-
Integrate with Freshteam Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshteam to a JSON file on disk.
-
Automated Continuous OneNote Replication to SQL Server
Use CData Sync for automated, continuous, customizable OneNote replication to SQL Server.
-
Automated Continuous Couchbase Replication to SingleStore
Use CData Sync for automated, continuous, customizable Couchbase replication to SingleStore.
-
Build Splunk-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Splunk and build web apps with connectivity to live Splunk.
-
Integrating Antigravity CLI with SparkPost via CData CLI
Connect SparkPost to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to SAS Data Sets Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAS Data Sets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Teams
Provide connectivity to Microsoft Teams through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Service Cloud
Create Oracle Service Cloud data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software JDBC Driver for Box in MicroStrategy
Connect to Box in MicroStrategy Developer using the CData Software JDBC Driver for Box.
-
Connect to AgileCRM Data in HULFT Integrate
Connect to AgileCRM as a JDBC data source in HULFT Integrate
-
Connect to Landbot Data in Ruby
Connect to Landbot in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Amazon DynamoDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Amazon DynamoDB Data and create custom apps in Bubble.
-
Migrating data from SAP Hybris C4C to Google BigQuery using CData SSIS Components.
Easily push SAP Hybris C4C to Google BigQuery using the CData SSIS Tasks for SAP Hybris C4C and Google BigQuery.
-
Connect to OData Services in DBeaver
Use the CData ODBC Driver to connect to OData in DBeaver.
-
Design BIRT Reports on Google Ads Data
Provide current Google Ads to your embedded analytics.
-
Automate Superchat Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Superchat from PowerShell? This article demonstrates how to utilize the Superchat Cmdlets for tasks like connecting to Superchat, automating operations, downloading data, and more.