CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to MariaDB: Complete Guide
Connect to the CData Software Power BI Connector for MariaDB from PowerBI.com to provide real-time MariaDB across the organization.
-
Automated Continuous Stripe Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Stripe replication to IBM DB2.
-
Operational Reporting on Dotmailer Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Dotmailer.
-
Migrating data from Vault CRM to Google BigQuery using CData SSIS Components.
Easily push Veeva Vault & Vault CRM to Google BigQuery using the CData SSIS Tasks for Vault CRM and Google BigQuery.
-
Build Greenhouse-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Greenhouse and build Greenhouse-connected web apps with Axios.
-
Getting Started with the CData ADO.NET Provider for Apollo
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Natively Connect to Microsoft Exchange Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Exchange. Leverage the native support for ODBC in PHP.
-
How to Seamlessly Import Campaigner Data into IBM SPSS Modeler
Integrate Campaigner data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
A PostgreSQL Interface for Adobe Analytics Data (MySQL Remoting via JDBC)
Use the Remoting features of the Adobe Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData SSIS Components for Bitly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bitly.
-
Use the CData Software JDBC Driver for Amazon S3 in MicroStrategy Desktop
Connect to Amazon S3 in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon S3.
-
How to Seamlessly Import SAP Data into IBM SPSS Modeler
Integrate SAP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish Simplesat-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Simplesat.
-
Access WooCommerce Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access WooCommerce from your Oracle system.
-
Connect to Power BI XMLA Data in Ruby
Connect to Power BI XMLA in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect Discord to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Discord using the CData Python MCP Server.
-
Import Trello Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Trello. In this article, you will use the OData format to import Trello into Microsoft Power Query.
-
DataBind Controls to Oracle Financials Cloud Data in C++Builder
DataBind to Oracle Financials Cloud in C++Builder with standard components and controls.
-
Migrating data from ConvertKit to Snowflake using CData SSIS Components.
Easily push ConvertKit to Snowflake using the CData SSIS Tasks for ConvertKit and Snowflake.
-
How to connect to Dynamics NAV Data with Squirrel SQL client
Connect to Microsoft Dynamics NAV and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Connect AI Python SDK for Tally
Install the CData Connect AI Python SDK to read and write live Tally ERP with standard DB-API 2.0 Python code.
-
Use Dash to Build to Web Apps on Front Data
Create Python applications that use pandas and Dash to build Front-connected web apps.
-
Load Grafana Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Grafana to a database.
-
Access Live CockroachDB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CockroachDB from your Excel spreadsheets.
-
Publish Recurly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Recurly.
-
Use the CData ODBC Driver for Salesforce Marketing in Microsoft Power Query
You can use the CData Salesforce Marketing ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesforce Marketing Cloud into Microsoft Power Query.
-
Build Semantic Layer Views for Bitly Data in APOS Live Data Gateway
Use the CData Connector for Bitly in APOS Live Data Gateway to build Semantic Layer Views for Bitly.
-
Connect to Salesforce Data in DBeaver
Use the CData ODBC Driver to connect to Salesforce & Force.com in DBeaver.
-
Integrating LlamaIndex with GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on GitLab in real time.
-
Using the CData Software ODBC Driver for PivotalTracker in PyCharm
Connect to PivotalTracker as an ODBC data source in PyCharm using the CData Software ODBC Driver for PivotalTracker.
-
How to load Facebook data into Elasticsearch via Logstash
Introducing a simple method to load Facebook data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Authorize.Net Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Teamgate Replication to SingleStore
Use CData Sync for automated, continuous, customizable Teamgate replication to SingleStore.
-
Replicate BigQuery Data from PowerShell
Write a quick PowerShell script to query Google BigQuery. Use connectivity to the live data to replicate Google BigQuery to SQL Server.
-
Back Up FreeAgent to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with FreeAgent data.
-
Integrating GitHub Copilot CLI with Mailjet 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.
-
Create Reports with Discourse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Discourse.
-
Automated Continuous Rebilly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Rebilly replication to delimited files (CSV/TSV).
-
Moving Data from Planio to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Planio data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query, Visualize, and Share live Kintone Data in Redash
Use CData Connect AI to connect to live Kintone in Redash for querying, visualizing, and sharing.
-
Operational Reporting on Humanity Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Humanity.
-
Automated Continuous OnePageCrm Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Google Cloud SQL.
-
Use Biml to Build SSIS Tasks to Replicate Adobe Analytics Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Adobe Analytics to SQL Server.
-
Connect to Demio Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Demio and work with Demio in your FileMaker applications.
-
Automated Continuous Excel Online Replication to SQLite
Use CData Sync for automated, continuous, customizable Excel Online replication to SQLite.
-
Connect to Zoho Inventory Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoho Inventory Data and connect to Zoho Inventory in Akorbi Digital RunMyProcess.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LightSpeedRetail
Provide connectivity to LightSpeedRetail through an SAP BusinessObjects universe.
-
Extend Google Sheets with CockroachDB Data
Make calls to CockroachDB from Google Apps Script via the API Server.
-
Integrate Live Highrise Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Highrise from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Highrise CRM.
-
Integrate with Google Spanner Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Spanner in SnapLogic.
-
Build Agents in Relevance AI with Access to Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce Pardot within intelligent agent workflows.
-
Automated Continuous Sage Intacct Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sage Intacct replication to SingleStore.
-
How to Visualize Avro Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache Avro in Python.
-
How to Access CockroachDB Data Using Entity Framework
This article shows how to access CockroachDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect and Visualize Live EnterpriseDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live EnterpriseDB into the Databricks platform and create visualization dashboards with real-time EnterpriseDB.
-
Getting Started with the CData Power BI Connector for ShipEngine
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Shippo Data Using Entity Framework
This article shows how to access Shippo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData ADO.NET Provider for Excel
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Excel.
-
Replicate Short.io Data from PowerShell
Write a quick PowerShell script to query Short.io. Use connectivity to the live data to replicate Short.io to SQL Server.
-
Access DocuSign Data from MySQL in Amazon QuickSight
Connect to DocuSign and build visualizations of DocuSign using a MySQL Connection in Amazon QuickSight.
-
A PostgreSQL Interface for Bugsnag Data using the CData ODBC Driver
Use the SQL Gateway and Bugsnag ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LlamaIndex with Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Freshservice in real time.
-
Integrate with Act CRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Act CRM in SnapLogic.
-
Connect Wave Financial Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Wave Financial using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData JDBC Driver for Teamwork
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Teamwork.
-
Replicate eBay Data in Heroku for Use in Salesforce Connect
Replicate eBay to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Live DB2 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to DB2 in CData Connect AI and connect to your IBM DB2 from PostgreSQL.
-
Create Oracle Financials Cloud Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle Financials Cloud from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Oracle Service Cloud Data in Tableau
The CData ODBC driver for Oracle Service Cloud enables you integrate Oracle Service Cloud into Tableau dashboards.
-
Access Live Basecamp Data in TIBCO Data Virtualization
Use the Basecamp Tibco DV Adapter to create a Basecamp data source in TIBCO Data Virtualization Studio and gain access to live Basecamp from your TDV Server.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Presto to Power BI dashboards. Simply drag and drop Presto into data visuals on the Power BI canvas.
-
Publish Crystal Reports on Asana Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Asana.
-
Build AI/ML Models with Live Act CRM Data using Dataiku
Connect Act CRM Data with Dataiku using the CData JDBC Driver for Act CRM.
-
Use the CData Software ODBC Driver for Microsoft Exchange in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Exchange in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Exchange.
-
How to Connect to & Open Azure Synapse Data in Microsoft Excel
This article uses the CData ODBC driver for Azure Synapse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize MYOB AccountRight Data in Tableau
The CData ODBC driver for MYOB AccountRight enables you integrate MYOB AccountRight into Tableau dashboards.
-
Integrate Cloudant Data in the Pentaho Report Designer
Publish reports based on IBM Cloudant in the Pentaho BI tool.
-
Visualize Live Zoho Creator Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoho Creator using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query EmailOctopus Data through ODBC in Node.js
Use node-odbc to execute SQL queries against EmailOctopus from Node.js.
-
How to connect PolyBase to Delighted
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Delighted.
-
Build Semantic Layer Views for Facebook Data in APOS Live Data Gateway
Use the CData Connector for Facebook in APOS Live Data Gateway to build Semantic Layer Views for Facebook.
-
Manage Suadeo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Suadeo.
-
How to create Visio diagrams from Google Campaign Manager 360 Data
Automatically update Google Campaign Manager 360 with the changes you make to Visio master shapes.
-
Printful Reporting in OBIEE with the Printful JDBC Driver
Deploy the Printful JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Real-Time Spotify Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Spotify in Power Apps.
-
Stream Certinia Data into Apache Kafka Topics
Access and stream Certinia in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Dash to Build Web Apps on Cloudant Data via CData Connect AI
Build interactive Dash web apps on live IBM Cloudant using pandas and the CData Connect AI Python SDK.
-
Replicate ZohoPeople Data in Heroku for Use in Salesforce Connect
Replicate ZohoPeople to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build SAP HANA XS Advanced-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP HANA XS Advanced to explore live SAP HANA XS Advanced Data in GitHub Copilot to assist with building SAP HANA XS Advanced-powered applications.
-
Use Grok to Talk to Your Microsoft OneDrive 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 Microsoft OneDrive for you.
-
Automated Continuous Outreach.io Replication to Oracle
Use CData Sync for automated, continuous, customizable Outreach.io replication to Oracle.
-
Use the CData Software JDBC Driver for GitLab in MicroStrategy
Connect to GitLab in MicroStrategy Developer using the CData Software JDBC Driver for GitLab.
-
Use the CData Software ODBC Driver for Flowlu in MicroStrategy Web
Connect to Flowlu in MicroStrategy Web using the CData Software ODBC Driver for Flowlu.
-
How to Connect to Live SQL Analysis Services Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SQL Analysis Services without replication.
-
Enable the Elorus JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Elorus.
-
Build a PostgreSQL Interface for SAP Business Warehouse Data using the CData JDBC Driver
Use the Remoting features of the SAP Business Warehouse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Charts with Facebook Ads Data in Clear Analytics
Create dynamic charts and perform analytics based on Facebook Ads in Clear Analytics.
-
Automated Continuous Stack Exchange Replication to MySQL
Use CData Sync for automated, continuous, customizable Stack Exchange replication to MySQL.
-
Build a Singer.io Tap for Shortcut With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Shortcut data using
-
Connect to Live SAP ByDesign Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP ByDesign in CData Connect AI and connect to your SAP Business ByDesign from PostgreSQL.