CData Software - Knowledge Base
Recent Articles
-
Visualize Live Scrapfly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Scrapfly using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Real-Time Twilio Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Twilio and Dataflow to import and use Twilio in Power Apps.
-
How to Connect to Live Google Contacts Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Contacts securely in real time.
-
Load Authorize.Net Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Authorize.Net to a database.
-
How to Connect to Live IBM Informix Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your IBM Informix for you.
-
Publish Invoiced-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Invoiced.
-
Connect to SAP HANA XS Advanced Data from a Connection Pool in Jetty
The SAP HANA XS Advanced JDBC Driver supports connection pooling: This article shows how to connect faster to SAP HANA XS Advanced from Web apps in Jetty.
-
Visualize BenchmarkEmail Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to BenchmarkEmail.
-
Automated Continuous Bugsnag Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bugsnag replication to Apache Cassandra.
-
Migrating data from Aweber to Databricks using CData SSIS Components.
Easily push Aweber to Databricks using the CData SSIS Tasks for Aweber and Databricks.
-
How to Import Data from Azure Table into Google Sheets
Import Azure Table Storage into a Google spreadsheet that is automatically refreshed.
-
Query Oracle Sales Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle Sales from Node.js.
-
Prepare, Blend, and Analyze Missive Data in Alteryx Designer (ODBC)
Build workflows to access live Missive for self-service data analytics.
-
Choosing the Best Method to Connect Recurly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Recurly from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Presto Replication to SQLite
Use CData Sync for automated, continuous, customizable Presto replication to SQLite.
-
How to Connect to Live LinkedIn Ads Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your LinkedIn Ads for you.
-
Connect to Airtable Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Airtable to connect to Airtable and execute queries in PowerBuilder.
-
Analyze FHIR Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of FHIR and visualize live FHIR in Infragistics Reveal.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Power BI XMLA
Provide connectivity to Power BI XMLA through an SAP BusinessObjects universe.
-
Easily Integrate Couchbase Data in Lazarus Pascal IDE
Learn how to easily integrate live Couchbase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software ODBC Driver for Dynamics CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Dynamics CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dynamics CRM.
-
How to Work with ConvertAPI Data in ETL Validator JDBC
Connect to ConvertAPI from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Teamwork Data in DBeaver
Use the CData ODBC Driver to connect to Teamwork in DBeaver.
-
Excel Spreadsheet Automation on Demio Data with the QUERY Formula
Pull data from Demio, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Live MailChimp Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your MailChimp for you.
-
Configure the CData JDBC Driver for Stripe in a Connection Pool in Tomcat
Connect to Stripe from a connection pool in Tomcat.
-
Connect Jodoo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Jodoo with IBM WebSphere for seamless data integration and connectivity.
-
Create Mailgun Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mailgun data access from reports, embedded analytics, and more.
-
Visualize Live Splunk Data in the Power BI Service
Use CData Connect AI to connect to live Splunk and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Semantic Layer Views for Google Contacts Data in APOS Live Data Gateway
Use the CData Connector for Google Contacts in APOS Live Data Gateway to build Semantic Layer Views for Google Contacts.
-
Integrate Live Amazon DynamoDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Amazon DynamoDB and integrate live Amazon DynamoDB into apps built in Microsoft Power Apps.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle Service Cloud using the Model Context Protocol.
-
Query MailerLite Data in ColdFusion
Write standard ColdFusion data access code to connect to MailerLite.
-
Rapidly Develop SAP Business Warehouse-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SAP Business Warehouse.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for JobNimbus
Provide connectivity to JobNimbus through an SAP BusinessObjects universe.
-
How to connect to Zoho Projects Data from Spring Boot
Connect to Zoho Projects in a Spring Boot Application using the CData JDBC Driver for Zoho Projects
-
Visualize Azure Synapse Data in Tableau
The CData ODBC driver for Azure Synapse enables you integrate Azure Synapse into Tableau dashboards.
-
Automated Coinbase Data Replication to Teradata
Use CData Sync to Customize and automate Coinbase replication to Teradata.
-
Access Live Highrise Data in TIBCO Data Virtualization
Use the Highrise Tibco DV Adapter to create a Highrise CRM data source in TIBCO Data Virtualization Studio and gain access to live Highrise CRM from your TDV Server.
-
Integrate Couchbase Data in Pentaho Data Integration
Build ETL pipelines based on Couchbase in the Pentaho Data Integration tool.
-
ETL Office 365 in Oracle Data Integrator
This article shows how to transfer Microsoft Office 365 into a data warehouse using Oracle Data Integrator.
-
A PostgreSQL Interface for Anaplan Data using the CData ODBC Driver
Use the SQL Gateway and Anaplan ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Paylocity Data in Ruby
Connect to Paylocity in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Back Up Microsoft Excel to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel. In this article, we will employ an SSIS workflow to populate a database with Microsoft Excel data.
-
Access Live ConstantContact Data in Coginiti Pro
Connect to and query live ConstantContact from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Consume xBase OData Feeds in PowerBuilder
This article demonstrates how to consume xBase as OData feeds from PowerBuilder using the API Server.
-
How to Easily Query Ontraport Data in OpenOffice Base
Connect to Ontraport data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
LINQ to SAP Netweaver Gateway 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 SAP Netweaver Gateway Data Provider.
-
Connect to Dotmailer Data in Jaspersoft Studio
Execute SQL to remote Dotmailer in Jaspersoft Studio.
-
DataBind Highrise Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Highrise with the DevExpress Windows Forms and Web controls to provide Highrise CRM to a chart.
-
A PostgreSQL Interface for SpaceX Data (MySQL Remoting via JDBC)
Use the Remoting features of the SpaceX JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData JDBC Driver for Airtable
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Airtable.
-
Access SpaceX Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SpaceX from your Oracle system.
-
Build Dashboards with Avro Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache Avro in DBxtra.
-
Build Data Flows from SQL Server to MySQL through SSIS
Easily push SQL Server data to MySQL using the CData SSIS Tasks for MySQL.
-
Use the CData ODBC Driver for Cosmos DB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cosmos DB to connect to Azure Cosmos DB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Cosmos DB in Excel.
-
Create Zoom Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoom from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Use a Microsoft Access Database to Update OData Services in Real Time
Update OData data by creating a linked table in Microsoft Access with the CData OData ODBC Driver.
-
Replicate Multiple Freshsales Accounts
Replicate multiple Freshsales accounts to one or many databases.
-
Connect to Real-Time ZarMoney Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZarMoney in Power Apps.
-
Integrating Antigravity CLI with Quickbase via CData CLI
Connect Quickbase to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Real-Time Optimizely Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Optimizely in Power Apps.
-
Integrating Claude Code with Dynamics CRM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Dynamics CRM within assisted coding and automated development workflows.
-
Access Live Zendesk Data in AWS Lambda
Connect to live Zendesk in AWS Lambda using the CData JDBC Driver.
-
Integrate Goose with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Apache Impala from within the local AI agent.
-
Consume Oracle OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle feeds that reflect any changes in SAP Lumira.
-
Replicate Multiple Vertica Accounts via the CData Sync CLI
Replicate multiple Vertica accounts to one or many databases.
-
Integrate with live SAP Netweaver Gateway Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Netweaver Gateway in Jitterbit.
-
Connect to HelloSign from Asprova with CData Software ODBC Driver for HelloSign
This article shows how to connect faster to HelloSign data from Asprova.
-
Connect to HubSpot Data from a Connection Pool in JBoss
Integrate HubSpot into Java servlets: Use the Management Console in JBoss to install the HubSpot JDBC Driver.
-
Build Hive Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apache Hive and build visualizations in Tableau Cloud.
-
How to Build an ETL App for Reckon Data in Python with CData
Create ETL applications and real-time data pipelines for Reckon in Python with petl.
-
Integrate Coinbase Data in Pentaho Data Integration
Build ETL pipelines based on Coinbase in the Pentaho Data Integration tool.
-
How to connect to Elasticsearch Data in DBVisualizer
Integrate Elasticsearch with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Dashboards with MessageBird Data in Dundas BI
Create dynamic dashboards and perform analytics based on MessageBird in Dundas BI.
-
How to load Microsoft Ads data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Ads 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 PostgreSQL in MicroStrategy
Connect to PostgreSQL in MicroStrategy Developer using the CData Software ODBC Driver for PostgreSQL.
-
Build Agents in Relevance AI with Access to Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Business One within intelligent agent workflows.
-
Connect to ADP Data in HULFT Integrate
Connect to ADP as a JDBC data source in HULFT Integrate
-
Replicate Rebilly Data in Heroku for Use in Salesforce Connect
Replicate Rebilly to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Elorus Data from a Connection Pool in JBoss
Integrate Elorus into Java servlets: Use the Management Console in JBoss to install the Elorus JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP SuccessFactors
Create an ODBC connection to SAP SuccessFactors in Informatica and browse and transfer SAP SuccessFactors.
-
Build Dashboards with PayPal Data in DBxtra
Create dynamic dashboards and perform analytics based on PayPal in DBxtra.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Recurly
Provide connectivity to Recurly through an SAP BusinessObjects universe.
-
Build Azure Synapse-Connected Apps in Choreo
Use CData Connect AI to connect to Azure Synapse Data from Choreo and build custom apps using live Azure Synapse.
-
Connect to DocuSign Data in NetBeans
Connect to DocuSign in NetBeans with the data source configuration wizard.
-
Integrate Live LinkedIn Ads Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to LinkedIn Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live LinkedIn Ads.
-
Query CouchDB Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache CouchDB.
-
Replicate Act CRM Data to Multiple Databases via the CData Sync CLI
Replicate Act CRM to disparate databases with a single configuration.
-
How to connect to OnePageCrm Data from Spring Boot
Connect to OnePageCrm in a Spring Boot Application using the CData API Driver for JDBC
-
Use the CData Software JDBC Driver for Nethunt in MicroStrategy Web
Connect to Nethunt in MicroStrategy Web using the CData Software JDBC Driver for Nethunt.
-
Import SendGrid Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SendGrid Data and provide access to live SendGrid for custom reports in the Power BI Service.
-
Connect to Gorgias Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gorgias using standard SQL.
-
Analyze Excel Online Data in Cognos Analytics
Use CData Connect AI to connect to Excel Online Data from Cognos Analytics and analyze live Microsoft Excel Online.
-
Access Live Couchbase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Couchbase from your Excel spreadsheets.
-
Create SSAS Tabular Models from Couchbase Data
How to build a SQL Server Analysis Service Tabular Model from Couchbase using CData drivers.
-
Getting Started with the CData SSIS Components for GetResponse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for GetResponse.
-
Visualize SAP Hybris C4C Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Hybris C4C.
-
How to Work with JSON Services in ETL Validator JDBC
Connect to JSON from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for Quaderno Data using the CData JDBC Driver
Use the Remoting features of the Quaderno JDBC Driver to create a PostgreSQL entry-point for data access.