CData Software - Knowledge Base
Recent Articles
-
Analyze SendPulse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SendPulse with the CData JDBC Driver for SendPulse.
-
How to Query Live Greenhouse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Greenhouse data in natural language using Python.
-
Access Live IBM Informix Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate IBM Informix into the statistical analysis tools available in SAS JMP. This article shows how to use IBM Informix in the Graph Builder and Query Builder.
-
Use Grok to Talk to Your Facebook Ads 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 Facebook Ads for you.
-
Access Printify Data from MySQL in PHP
Connect to Printify through the standard MySQL libraries in PHP.
-
Integrate Google Tasks with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Tasks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Tasks.
-
Query Excel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Excel from Node.js.
-
Getting Started with the CData ADO.NET Provider for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Netweaver Gateway.
-
Getting Started with the CData ODBC Driver for Amazon S3
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Amazon S3.
-
Process & Analyze MarkLogic Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MarkLogic Data.
-
A PostgreSQL Interface for Bitly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bitly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bugsnag Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bugsnag facts in real time.
-
Integrating Rebilly Data in Talend Cloud Data Management Platform
Connect Rebilly Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query eBay Analytics Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume eBay Analytics entities in PHP by modeling them as objects.
-
Getting Started with the CData Tableau Connector for Splunk
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Splunk.
-
Use the CData Software ODBC Driver for Beeminder in MicroStrategy
Connect to Beeminder in MicroStrategy Developer using the CData Software ODBC Driver for Beeminder.
-
How to create Microsoft Teams federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Teams in MySQL .
-
Connect to Close Data in Ruby
Connect to Close in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Grok to Talk to Your Google Sheets 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 Google Sheets for you.
-
Operational Reporting on Facebook Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Facebook Ads.
-
How to connect to Coda Data with Squirrel SQL client
Connect to Coda and execute queries in the Squirrel SQL Client.
-
Integrate Certinia Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Certinia and integrate live Certinia into your Power Automate tasks.
-
Integrate with Facebook Ads Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Facebook Ads to a JSON file on disk.
-
Integrate with live Sage 200 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sage 200 in Jitterbit.
-
Connect to and Query LDAP Objects in QlikView over ODBC
Create data visualizations with LDAP in QlikView.
-
Automated Continuous Greenhouse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Greenhouse replication to Apache Kafka.
-
Analyze SingleStore Data in Cognos Analytics
Use CData Connect AI to connect to SingleStore Data from Cognos Analytics and analyze live SingleStore.
-
Integrating LlamaIndex with Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sugar CRM in real time.
-
Connect to Salesforce Marketing Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesforce Marketing Cloud from Crystal Reports.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google BigQuery using the Model Context Protocol.
-
How to Work with Attio Data in AWS Glue Jobs Using JDBC
Connect to Attio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Build an ETL App for Printify Data in Python with CData
Create ETL applications and real-time data pipelines for Printify in Python with petl.
-
Connect and Query Live Amazon Athena Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon Athena into Databricks
-
Deploy the ADO.NET Provider for Adobe Analytics on an SSRS Report Server
Connect to Adobe Analytics from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Landbot Data in DBeaver
Use the CData ODBC Driver to connect to Landbot in DBeaver.
-
Connect and Query Live Salesforce Pardot Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesforce Pardot into Databricks
-
Use JayDeBeApi to access Bannerbear Data in Python
Use standard Python scripting and the development environment of your choice to access live Bannerbear.
-
Automate ActiveCampaign Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live ActiveCampaign and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Smartsheet-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Smartsheet Data from Klipfolio and build custom visualizations using live Smartsheet.
-
Model Jira Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Jira, enabling the direct import of real-time Atlassian Jira.
-
Automated Continuous Spark Replication to SQLite
Use CData Sync for automated, continuous, customizable Spark replication to SQLite.
-
Automated Continuous Intercom Replication to MongoDB
Use CData Sync for automated, continuous, customizable Intercom replication to MongoDB.
-
How to use SQLAlchemy ORM to access Freshsales Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Freshsales.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Adobe Commerce to Power BI dashboards. Simply drag and drop Adobe Commerce into data visuals on the Power BI canvas.
-
Automated Continuous ZohoInvoice Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Amazon S3.
-
Import Bullhorn CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Bullhorn CRM Data from Azure Data Factory and import live Bullhorn CRM.
-
Automate DocuSign Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live DocuSign and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Easily Integrate Planio Data in Lazarus Pascal IDE
Learn how to easily integrate live Planio in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Work with Printful Data in AWS Glue Jobs Using JDBC
Connect to Printful from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Real-Time Couchbase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Couchbase and Dataflow to import and use Couchbase in Power Apps.
-
Authorize.Net Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Authorize.Net facts in real time.
-
Connect to Datadog Data in DBArtisan
Use wizards in DBArtisan to configure Datadog as a data source.
-
Automated Continuous PayPal Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PayPal replication to OneLake in Microsoft Fabric.
-
Connect to Mode Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mode using standard SQL.
-
DataBind Charts to Parquet Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Parquet 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.
-
Connect to SAS Data Sets Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAS Data Sets using standard SQL.
-
How to Access Auth0 Data Using Entity Framework
This article shows how to access Auth0 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Choosing the Best Method to Connect Telegram to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Telegram from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Aircall Data in Talend Cloud Data Management Platform
Connect Aircall Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Data Visualizations in Cognos BI with Google Sheets Data
Access Google Sheets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Live BigCommerce Data in the Power BI Service
Use CData Connect AI to connect to live BigCommerce and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect QuickBooks to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect QuickBooks with IBM WebSphere for seamless data integration and connectivity.
-
Integrating WooCommerce Data in Talend Cloud Data Management Platform
Connect WooCommerce Data with Talend Cloud Data Management Platform using the CData JDBC Driver for WooCommerce.
-
ETL Datadog in Oracle Data Integrator
This article shows how to transfer Datadog into a data warehouse using Oracle Data Integrator.
-
How to Query Live Bright Data Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bright Data data in natural language using Python.
-
Getting Started with the CData Power BI Connector for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MYOB AccountRight.
-
Connect to Snowflake Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Snowflake.
-
Use Microsoft Copilot Studio to talk to your SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Business One for you.
-
Integrating Claude Code CLI with Google Directory 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.
-
Trigger Excel IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Excel with standard wizards in Logic Apps.
-
Connect to AlloyDB from a Connection Pool in WebLogic
Use the CData JDBC Driver for AlloyDB to connect to Google AlloyDB from Web applications running on WebLogic.
-
How to integrate Helpscout with Apache Airflow
Access and process Helpscout in Apache Airflow using the CData JDBC Driver.
-
Integrating GitHub Copilot CLI with Webflow 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 and process Pipeliner CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pipeliner CRM.
-
Access Live Testmonitor Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Testmonitor into the statistical analysis tools available in SAS JMP. This article shows how to use Testmonitor in the Graph Builder and Query Builder.
-
Getting Started with the CData Connect AI Python SDK for Salesforce
Install the CData Connect AI Python SDK to read and write live Salesforce & Force.com with standard DB-API 2.0 Python code.
-
Viewing Avalara AvaTax Data in RAD Studio Data Explorer
How to view Avalara AvaTax in RAD Studio Data Explorer using the CData ODBC Driver for Avalara AvaTax.
-
Automated Continuous Oracle SCM Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Vertica.
-
Automated Continuous SAP SuccessFactors Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to MongoDB.
-
Natively Connect to Jira Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Atlassian Jira. Leverage the native support for ODBC in PHP.
-
Integrate with live Couchbase Data in Jitterbit
Use CData Connect AI to connect to and integrate live Couchbase in Jitterbit.
-
Creating Amazon DynamoDB-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon DynamoDB to Unqork and build custom business apps.
-
How to connect and process ZohoSubscriptions from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZohoSubscriptions.
-
Visualize ConvertKit Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ConvertKit.
-
Query Sybase Data in ColdFusion
Write standard ColdFusion data access code to connect to Sybase.
-
How to Query Live Dotmailer Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Dotmailer data in natural language using Python.
-
Build Automated Neo4J-Connected Workflows in Zapier
Use CData Connect AI to connect to live Neo4J and build automated workflows in Zapier.
-
Build Data Flows from Sugar CRM to SQL Server using SSIS
Easily back up Sugar CRM to SQL Server using the SSIS components for Sugar CRM.
-
Automated Continuous Shortcut Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Shortcut replication to delimited files (CSV/TSV).
-
Prepare, Blend, and Analyze Facebook Data in Alteryx Designer (ODBC)
Build workflows to access live Facebook for self-service data analytics.
-
Visualize SAP Data in Sisense
Create an ElastiCube in Sisense app with access to SAP ERP/NetWeaver.
-
Use Biml to Build SSIS Tasks to Replicate Templated Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Templated to SQL Server.
-
Connect to Cassandra Data from HeidiSQL
Use CData Connect AI to connect to and query live Apache Cassandra from HeidiSQL.
-
Build Blackbaud FE NXT-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Blackbaud FE NXT.
-
Build Dashboards with Adobe Target Data in Dundas BI
Create dynamic dashboards and perform analytics based on Adobe Target in Dundas BI.
-
Automated Continuous MessageBird Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MessageBird replication to Amazon S3.
-
Connect to Real-Time PostgreSQL Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PostgreSQL and Dataflow to import and use PostgreSQL in Power Apps.
-
Visualize HDFS 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 Apache HDFS into TIBCO Spotfire.
-
Establish a Live Connection with Cvent Data using Tableau Bridge
The CData ODBC Driver for Cvent enables you to integrate live Cvent into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for Act CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Act CRM to connect to Act CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Act CRM in Excel.