CData Software - Knowledge Base
Recent Articles
-
How to Import Data from eBay into Google Sheets
Import eBay into a Google spreadsheet that is automatically refreshed.
-
Query Ontraport Data in ColdFusion
Write standard ColdFusion data access code to connect to Ontraport.
-
Access Live MariaDB Data in Excel 365 Online (Excel for the web)
Connect to MariaDB from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData Power BI Connector for MessageBird
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Recurly
Create Recurly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Datasets from CSV in Domo Workbench and Build Visualizations of CSV Data in Domo
Use the CData Software ODBC Driver for CSV to create datasets from CSV/TSV Files in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Certinia Data in TIBCO Spotfire through ADO.NET
Integrate Certinia into dashboards in TIBCO Spotfire.
-
Replicate GitLab Data to Multiple Databases
Replicate GitLab to disparate databases with a point-and-click configuration.
-
Object-Relational Mapping (ORM) with Google Contacts Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Contacts into a Java-based ORM framework, Hibernate.
-
Automated Continuous Humanity Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Humanity replication to Amazon S3.
-
Connect to Google Forms Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Google Forms and work with Google Forms in your FileMaker application.
-
Use Agno to Talk to Your Apollo 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 Apollo for you.
-
How to Query Google Contacts Data in MySQL Workbench
Execute MySQL queries against live Google Contacts from MySQL Workbench.
-
Create SSAS Tabular Models from Cvent Data
How to build a SQL Server Analysis Service Tabular Model from Cvent using CData drivers.
-
Create a Data Access Object for Beeminder Data using JDBI
A brief overview of creating a SQL Object API for Beeminder in JDBI.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce Marketing
Create an ODBC connection to Salesforce Marketing in Informatica and browse and transfer Salesforce Marketing Cloud.
-
Build Excel Online-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Excel Online.
-
Integrating Kiro CLI with Avaza 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.
-
Use the CData ODBC Driver for Dynamics 365 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 to connect to Microsoft Dynamics 365 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Dynamics 365 in Excel.
-
Connect and Visualize Live Google Ad Manager Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Ad Manager into the Databricks platform and create visualization dashboards with real-time Google Ad Manager.
-
Connecting Moonlit Workflow with Vertica Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Vertica in real time.
-
Integrate Theia IDE with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData Software ODBC Driver for Front in MicroStrategy
Connect to Front in MicroStrategy Developer using the CData Software ODBC Driver for Front.
-
Getting Started with the CData JDBC Driver for SparkPost
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SparkPost.
-
Automated Continuous OnePageCrm Replication to SQLite
Use CData Sync for automated, continuous, customizable OnePageCrm replication to SQLite.
-
Build Data Flows from IBM Informix to SQL Server using SSIS
Easily back up IBM Informix to SQL Server using the SSIS components for IBM Informix.
-
Connect to and Query Codat Data in QlikView over ODBC
Create data visualizations with Codat in QlikView.
-
Automate MarkLogic Data Replication to Azure Data Lake
Use CData Sync to customize and automate MarkLogic replication to Azure Data Lake.
-
Create Dashboards and Visualize Live Couchbase Data in Geckoboard
Use CData Connect AI to connect to live Couchbase and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Typeform Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Typeform replication to OneLake in Microsoft Fabric.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ShipStation
Provide connectivity to ShipStation through an SAP BusinessObjects universe.
-
Visualize Live SAP HANA Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP HANA using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Vertica Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Vertica replication to PostgreSQL.
-
Integrate Apify Data in the Pentaho Report Designer
Publish reports based on Apify in the Pentaho BI tool.
-
Edit and Search SAP SuccessFactors LMS External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP SuccessFactors LMS to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP SuccessFactors LMS objects that you can access from apps and the dashboard.
-
Connect to GitHub Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live GitHub.
-
Visualize Zoho Recruit 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 Zoho Recruit into TIBCO Spotfire.
-
Add OnePageCrm Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for OnePageCrm with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Mixpanel Data Using Entity Framework
This article shows how to access Mixpanel using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Discord Data from a Connection Pool in JBoss
Integrate Discord into Java servlets: Use the Management Console in JBoss to install the Discord JDBC Driver.
-
Automate Salesforce Pardot Data Replication to SAP HANA
Use CData Sync to customize and automate Salesforce Pardot replication to SAP HANA.
-
Build Dashboards with Workable Data in Dundas BI
Create dynamic dashboards and perform analytics based on Workable in Dundas BI.
-
Connect to ZeroBounce Data in Jaspersoft Studio
Execute SQL to remote ZeroBounce in Jaspersoft Studio.
-
Enable the CapsuleCRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CapsuleCRM.
-
Replicate Drip Data to Multiple Databases via the CData Sync CLI
Replicate Drip to disparate databases with a single configuration.
-
Create Dynamic ConvertAPI Grids Using the Infragistics XamDataGrid
Learn how you can connect ConvertAPI to Infragistics XamDataGrid to build dynamic grids.
-
Connect Autopilot to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Autopilot using the CData Python MCP Server.
-
Replicate Bright Data Data from PowerShell
Write a quick PowerShell script to query Bright Data. Use connectivity to the live data to replicate Bright Data to SQL Server.
-
How to Connect the Power BI Service to Azure Table: Complete Guide
Connect to the CData Software Power BI Connector for Azure Table from PowerBI.com to provide real-time Azure Table Storage across the organization.
-
Connect to Google Cloud Storage Data in ACL Analytics
Connect to Google Cloud Storage via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Cloud Storage.
-
Connect to MySQL Data from PowerBuilder via JDBC
This article demonstrates how to access MySQL from PowerBuilder using the MySQL JDBC Driver.
-
Automate Google Spanner Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Spanner from PowerShell? This article demonstrates how to utilize the Google Spanner Cmdlets for tasks like connecting to Google Spanner, automating operations, downloading data, and more.
-
Analyze Instantly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Instantly in Microsoft R Open.
-
Access Elasticsearch Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Elasticsearch from HeidiSQL.
-
Connect to Real-Time PhantomBuster Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PhantomBuster in Power Apps.
-
Automated Continuous Monday.com Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Monday.com replication to PostgreSQL.
-
Publish Reports with Phoenix Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Phoenix.
-
Connect to Tally Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Tally ERP in Airbyte.
-
Use the CData Software JDBC Driver for HubSpot in MicroStrategy
Connect to HubSpot in MicroStrategy Developer using the CData Software JDBC Driver for HubSpot.
-
Access Live Azure DevOps Data in Excel 365 Online (Excel for the web)
Connect to Azure DevOps from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate DB2 Data from PowerShell
Write a quick PowerShell script to query IBM DB2. Use connectivity to the live data to replicate IBM DB2 to SQL Server.
-
How to create Google Campaign Manager 360 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Campaign Manager 360 in MySQL .
-
Connect to SharePoint Data from a Connection Pool in Jetty
The SharePoint JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft SharePoint from Web apps in Jetty.
-
Analyze Workday Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Workday and visualize live Workday in Infragistics Reveal.
-
Publish Stack Exchange-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Stack Exchange.
-
Connect to and Visualize Live YouTube Analytics Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live YouTube Analytics.
-
How to connect to Pinterest Data with Squirrel SQL client
Connect to Pinterest and execute queries in the Squirrel SQL Client.
-
Create Dashboards and Visualize Live SendGrid Data in Geckoboard
Use CData Connect AI to connect to live SendGrid and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Adobe Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Oracle.
-
Publish Crystal Reports on Grafana Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Grafana.
-
Automated Continuous Odoo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Odoo replication to Azure SQL Database.
-
Use Manus AI to Talk to Your Neo4J 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 Neo4J.
-
How to connect SharePoint with Google Cloud Storage Data through external lists
Provide Google Cloud Storage to SharePoint users as an external list.
-
Getting Started with the CData ODBC Driver for Campaigner
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Campaigner.
-
How to connect to Landbot Data with Squirrel SQL client
Connect to Landbot and execute queries in the Squirrel SQL Client.
-
Building Dynamic Web Pages with Sage Intacct Data Using AngularJS
Create single-page applications with live connectivity to Sage Intacct using the CData API Server.
-
Consume Stripe OData Feeds in PowerBuilder
This article demonstrates how to consume Stripe as OData feeds from PowerBuilder using the API Server.
-
Access Live SAP ByDesign Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP Business ByDesign through MCP integration.
-
Getting Started with the CData JDBC Driver for BambooHR
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for BambooHR.
-
Build SAP Ariba Procurement-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Ariba Procurement.
-
Query Retently Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Retently from Node.js.
-
Provide OData Services of ZohoMarketingHub Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoMarketingHub by developing a WCF Service Application.
-
Query, Visualize, and Share live SAP SuccessFactors LMS Data in Redash
Use CData Connect AI to connect to live SAP SuccessFactors LMS in Redash for querying, visualizing, and sharing.
-
Provide OData Services of Spotify Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Spotify by developing a WCF Service Application.
-
Object-Relational Mapping (ORM) with Pinterest Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Pinterest into a Java-based ORM framework, Hibernate.
-
Integrate SharePoint with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SharePoint with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft SharePoint.
-
Access Trello Data from MySQL in PHP
Connect to Trello through the standard MySQL libraries in PHP.
-
Connect to Tanda Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Tanda to connect to Tanda and execute queries in PowerBuilder.
-
Write a Simple Go Application to work with ServiceNow Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ServiceNow.
-
Integrating Claude Code with LinkedIn Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on LinkedIn Ads within assisted coding and automated development workflows.
-
Connect to Access Data in CloverDX (formerly CloverETL)
Transfer Microsoft Access using the visual workflow in the CloverDX data integration tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sugar CRM
Provide connectivity to Sugar CRM through an SAP BusinessObjects universe.
-
DataBind Moosend Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Moosend to a chart.
-
Automated Continuous Kintone Replication to MongoDB
Use CData Sync for automated, continuous, customizable Kintone replication to MongoDB.
-
DataBind Controls to Quaderno Data in C++Builder
DataBind to Quaderno in C++Builder with standard components and controls.
-
Integrate with Moosend Data in JReport Designer
Create charts and reports based on Moosend in JReport Designer.
-
Automated Continuous Timely Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Timely replication to Apache Kafka.
-
Create Highrise-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Highrise Data from OutSystems and build custom enterprise apps using live Highrise CRM.
-
Perform Batch Operations with Quickbase Data in Apache NiFi
Connect to Quickbase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use the CData ODBC Driver for Reckon from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Reckon to connect to Reckon from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Reckon in Excel.