CData Software - Knowledge Base
Recent Articles
-
Connect to Apify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Apify and the SQL Gateway to access Apify from Google Apps Script.
-
Create GraphQL-Connected Dashboards in Grafana
Connect to GraphQL Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to GraphQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Eloqua
Create Oracle Eloqua data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect Google Cloud Storage Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Cloud Storage using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build SAP HANA-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP HANA.
-
Getting Started with the CData ODBC Driver for Tanda
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tanda.
-
Automated Continuous HBase Replication to Databricks
Use CData Sync for automated, continuous, customizable HBase replication to Databricks.
-
Configure the CData JDBC Driver for ScrapingBee in a Connection Pool in Tomcat
Connect to ScrapingBee from a connection pool in Tomcat.
-
Migrating data from JobNimbus to Databricks using CData SSIS Components.
Easily push JobNimbus to Databricks using the CData SSIS Tasks for JobNimbus and Databricks.
-
Publish Reports with Paymo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paymo.
-
Use Dash to Build to Web Apps on Discourse Data
Create Python applications that use pandas and Dash to build Discourse-connected web apps.
-
Connect to Google Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Analytics to connect to Google Analytics from Web applications running on WebLogic.
-
DataBind Controls to Scrapfly Data in C++Builder
DataBind to Scrapfly in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for Gong in MicroStrategy Desktop
Connect to Gong in MicroStrategy Desktop using the CData Software ODBC Driver for Gong.
-
Use the CData SSIS Components to Insert New or Update Existing Xero Records from SQL Server
Easily push SQL Server data to Xero using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Xero or update existing records with data from a SQL Server database.
-
Import Apollo Data Using Azure Data Factory
Use CData Connect AI to connect to Apollo Data from Azure Data Factory and import live Apollo.
-
Use the CData Software JDBC Driver for LinkedIn in MicroStrategy Web
Connect to LinkedIn in MicroStrategy Web using the CData Software JDBC Driver for LinkedIn.
-
Connect to MYOB AccountRight Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MYOB AccountRight using standard SQL.
-
Create Google Drive-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Drive Data from Klipfolio and build custom visualizations using live Google Drive.
-
Build a Simple VCL Application for Superchat Data
How to build a simple VCL Application to view Superchat in RAD Studio using the CData ODBC Driver for Superchat.
-
Integrating GitHub Copilot CLI with VWO 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 Microsoft Exchange Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Exchange from Informatica Cloud.
-
Validate Zoom Data with QuerySurge
Access and validate Zoom in QuerySurge using the CData JDBC Driver.
-
Access FreshBooks Data from MySQL in PHP
Connect to FreshBooks through the standard MySQL libraries in PHP.
-
How to Connect to Live GraphQL Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your GraphQL for you.
-
Integrate with live Authorize.Net Data in Jitterbit
Use CData Connect AI to connect to and integrate live Authorize.Net in Jitterbit.
-
How to Connect to & Open Google Ad Manager Data in Microsoft Excel
This article uses the CData ODBC driver for Google Ad Manager to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software ODBC Driver for PDFMonkey in MicroStrategy Web
Connect to PDFMonkey in MicroStrategy Web using the CData Software ODBC Driver for PDFMonkey.
-
Consume Oracle Sales OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Sales as OData feeds from PowerBuilder using the API Server.
-
Integrating Claude Code CLI with Salesforce 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.
-
Build Dashboards with ScrapingBee Data in DBxtra
Create dynamic dashboards and perform analytics based on ScrapingBee in DBxtra.
-
Prepare, Blend, and Analyze ZeroBounce Data in Alteryx Designer (ODBC)
Build workflows to access live ZeroBounce for self-service data analytics.
-
Connect to Hive Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Hive as an External Source in Dremio.
-
Natively Connect to Cassandra Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache Cassandra. Leverage the native support for ODBC in PHP.
-
Connect SAP Fieldglass Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Fieldglass using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
View Reports on Real-Time Active Directory Data in Power BI Report Server
Use the CData ODBC Driver for Active Directory to visualize Active Directory in Power BI Desktop and then publish them to Power BI Report Server.
-
DataBind Cosmos DB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Cosmos DB with the DevExpress Windows Forms and Web controls to provide Azure Cosmos DB to a chart.
-
Visualize Live CockroachDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CockroachDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to and Visualize Live HubDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HubDB.
-
Use the CData ODBC Driver for Reckon Accounts Hosted in Microsoft Power Query
You can use the CData Reckon Accounts Hosted ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Reckon Accounts Hosted into Microsoft Power Query.
-
Connect to DB2 Data in Claris FileMaker Pro
Use the CData ODBC Driver for DB2 in FileMaker Pro to connect to DB2 and work with IBM DB2 in your FileMaker applications.
-
How to Connect the Power BI Service to Miro: Complete Guide
Connect to the CData Software Power BI Connector for Miro from PowerBI.com to provide real-time Miro across the organization.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle Service Cloud to Power BI dashboards. Simply drag and drop Oracle Service Cloud into data visuals on the Power BI canvas.
-
Prepare, Blend, and Analyze SurveyMonkey Data in Alteryx Designer (Connect AI)
Build workflows to access live SurveyMonkey for self-service data analytics.
-
Deploy the ADO.NET Provider for Float on an SSRS Report Server
Connect to Float 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.
-
Publish Parquet-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache Parquet.
-
How to connect Amazon QuickSight to MarkLogic Data
Create a connection to MarkLogic in CData Connect AI and insert MarkLogic into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Airtable Data in NetBeans
Connect to Airtable in NetBeans with the data source configuration wizard.
-
Use Grok to Talk to Your Tally 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 Tally ERP for you.
-
Automate Sage Intacct Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sage Intacct replication to Azure Data Lake.
-
Getting Started with the CData SSIS Components for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Data Lake Storage.
-
Automated Continuous Avro Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Avro replication to Azure SQL Database.
-
How to Design Blackbaud FE NXT Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Blackbaud FE NXT from mobile and tablet Power Apps.
-
Connect ShipStation to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ShipStation with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Live CouchDB Data in the Power BI Service
Use CData Connect AI to connect to live Apache CouchDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Provide OData Services of Scrapfly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Scrapfly by developing a WCF Service Application.
-
Integrate Harvest with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Harvest with External Services.
-
Connect to ClickTime Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ClickTime using standard SQL.
-
Use CloverDX (formerly CloverETL) and CData JDBC Drivers to Transfer Data
The CData JDBC Drivers work with all tools that support JDBC. This allows for rapid data integration with a tool of your choice. This article shows how CData drivers can be used from CloverDX, a data integration tool, to transfer data between two data stores.
-
Use Agno to Talk to Your JSON Services 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 JSON for you.
-
Publish Reports with Discord Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Discord.
-
Integrate Live Authorize.Net Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Authorize.Net from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Authorize.Net.
-
How to Seamlessly Import ZarMoney Data into IBM SPSS Modeler
Integrate ZarMoney data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Analyze Google Ads Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Ads and visualize Google Ads in SAP Analytics Cloud.
-
Choosing the Best Method to Connect Coinbase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Coinbase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Manage Guru Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Guru.
-
Automated Continuous LionDesk Replication to MySQL
Use CData Sync for automated, continuous, customizable LionDesk replication to MySQL.
-
How to connect SharePoint with Azure DevOps Data through external lists
Provide Azure DevOps to SharePoint users as an external list.
-
Automate CouchDB Data Replication to Couchbase
Use CData Sync to Customize and automate Apache CouchDB replication to Couchbase.
-
Query SAP HANA Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP HANA.
-
Getting Started with the CData Python Connector for Productboard
Learn to install and license the CData Python Connector
-
Easily Integrate SFTP Data in Lazarus Pascal IDE
Learn how to easily integrate live SFTP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Adobe Target Data in JReport Designer
Create charts and reports based on Adobe Target in JReport Designer.
-
Integrate with PayPal Data in JReport Designer
Create charts and reports based on PayPal in JReport Designer.
-
Publish Google Drive-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Drive.
-
Create Datasets from Slack in Domo Workbench and Build Visualizations of Slack Data in Domo
Use the CData Software ODBC Driver for Slack to create datasets from Slack in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Theia IDE with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating OpenCode Terminal with Lakebase 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 integrate ConvertKit with Apache Airflow
Access and process ConvertKit in Apache Airflow using the CData JDBC Driver.
-
Build Visualizations of Miro Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Miro in Birst.
-
Query ConstantContact Data in DataGrip
Create a Data Source for ConstantContact in DataGrip and use SQL to query live ConstantContact.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed TaxJar to Power BI dashboards. Simply drag and drop TaxJar into data visuals on the Power BI canvas.
-
Migrating data from Zuora to Snowflake using CData SSIS Components.
Easily push Zuora to Snowflake using the CData SSIS Tasks for Zuora and Snowflake.
-
Connect to and Visualize Live Moosend Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Moosend.
-
How to Connect to Amazon S3 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amazon S3. Leverage the pyodbc module for ODBC in Python.
-
Connect to NetSuite Data in Google Apps Script via Connect AI
Use CData Connect AI to access NetSuite CRM & ERP in Google Apps Script.
-
Integrating Kiro CLI with Placid 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.
-
Integrate with Zoho Books Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho Books to a JSON file on disk.
-
How to work with Billsby Data in Apache Spark using SQL
Access and process Billsby Data in Apache Spark using the CData Software JDBC Driver.
-
Create Foursquare Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Foursquare data access from reports, embedded analytics, and more.
-
Using the CData Software ODBC Driver for Oracle Eloqua Reporting in PyCharm
Connect to Oracle Eloqua Reporting as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Eloqua Reporting.
-
Create LinkedIn Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LinkedIn data access from reports, embedded analytics, and more.
-
Connect and Query Live Azure DevOps Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure DevOps into Databricks
-
Establish a Live Connection with Excel Data using Tableau Bridge
The CData ODBC Driver for Excel enables you to integrate live Microsoft Excel into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software ODBC Driver for Suadeo in MicroStrategy Web
Connect to Suadeo in MicroStrategy Web using the CData Software ODBC Driver for Suadeo.
-
Connecting Agentforce with Xero 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 Xero Accounting for you.
-
Automated Continuous Microsoft Dataverse Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to SQLite.
-
Create Power BI Reports on Real-Time Avaza Data
Use the CData ODBC Driver for Avaza to visualize Avaza in Power BI Desktop.
-
Connect Instantly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Instantly using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous SendGrid Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SendGrid replication to Azure SQL Database.