CData Software - Knowledge Base
Recent Articles
-
Visualize Live Salesforce CRM Analytics Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce CRM Analytics data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to ShipStation Data in Claris FileMaker Pro
Use the CData ODBC Driver for ShipStation in FileMaker Pro to connect to ShipStation and work with ShipStation data in your FileMaker applications.
-
Load Parallel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Parallel data to a database.
-
Feed Paylocity Data into FineReport
How to set Paylocity data as a JDBC data source in FineReport.
-
How to Access Live Aha! Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Aha! enables you to integrate Aha! data into workflows built using Microsoft Power Automate Desktop.
-
Build a Singer.io Tap for Brex With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Brex data using the CData Python Connector.
-
Automated Continuous Databricks Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Databricks replication to Azure SQL Database.
-
Connect to Placid from a Connection Pool in WebLogic
Use the CData JDBC Driver for Placid to connect to Placid data from Web applications running on WebLogic.
-
Use Azure AI Foundry to Talk to Your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your ActiveCampaign data for you.
-
Automated Continuous MySQL Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MySQL replication to Azure SQL Database.
-
Integrate Tickspot with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Tickspot with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Tickspot data.
-
Query Typeform Data in DataGrip
Create a Data Source for Typeform in DataGrip and use SQL to query live Typeform data.
-
How to Connect SAP Concur Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAP Concur data in real time using natural language.
-
Explore Geographical Relationships in Superchat Data with Power Map
Create data visualizations with Superchat data in Power Map.
-
Query BambooHR Data in ColdFusion
Write standard ColdFusion data access code to connect to BambooHR data.
-
How to Connect to Live Google Ad Manager Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Ad Manager data for you.
-
View Reports on Real-Time xBase Data in Power BI Report Server
Use the CData ODBC Driver for xBase to visualize xBase data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy Web
Connect to Harvest data in MicroStrategy Web using the CData Software ODBC Driver for Harvest.
-
Automated Continuous ZohoExpense Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Google BigQuery.
-
Create Power BI Reports on Real-Time CouchDB Data
Use the CData ODBC Driver for CouchDB to visualize CouchDB data in Power BI Desktop.
-
Connect to ZendeskSell Data in DBArtisan
Use wizards in DBArtisan to configure ZendeskSell data as a data source.
-
Connect to Zoho Creator Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Creator data from your AWS Glue jobs.
-
Use Azure AI Foundry to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Salesforce Pardot data for you.
-
Prepare, Blend, and Analyze Vimeo Data in Alteryx Designer (ODBC)
Build workflows to access live Vimeo data for self-service data analytics.
-
Stream Bright Data Data into Apache Kafka Topics
Access and stream Bright Data data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query LinkedIn Ads Data in DataGrip
Create a Data Source for LinkedIn Ads in DataGrip and use SQL to query live LinkedIn Ads data.
-
Validate Demio Data with QuerySurge
Access and validate Demio data in QuerySurge using the CData JDBC Driver.
-
Build Apps with Live Odoo data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Odoo data into the Adalo platform and build custom mobile and web applications with real-time Odoo data.
-
Create Reports from SQL Analysis Services Data in Looker Studio
Use CData Connect AI to gain access to live SQL Analysis Services data and create custom reports in Looker Studio.
-
Automated Continuous Access Replication to Oracle
Use CData Sync for automated, continuous, customizable Access replication to Oracle.
-
Build Cosmos DB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cosmos DB data.
-
How to Visualize ClickUp Data in Python with pandas
Use pandas and other modules to analyze and visualize live ClickUp data in Python.
-
Automated Continuous Typeform Replication to Vertica
Use CData Sync for automated, continuous, customizable Typeform replication to Vertica.
-
Connect to ClickTime Data from a Connection Pool in JBoss
Integrate ClickTime data into Java servlets: Use the Management Console in JBoss to install the ClickTime JDBC Driver.
-
Automated Continuous SAP Netweaver Gateway Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to SQL Server.
-
Access Live Office 365 Data in TIBCO Data Virtualization
Use the Office 365 Tibco DV Adapter to create a Office 365 data data source in TIBCO Data Virtualization Studio and gain access to live Office 365 data from your TDV Server.
-
How to Create Power BI Visual Reports with Real-Time FreshBooks Data
Use CData Power BI Connectors to visualize FreshBooks data in Power BI.
-
Connect to ZohoMarketingHub Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoMarketingHub to connect to ZohoMarketingHub data and execute queries in PowerBuilder.
-
Publish Crystal Reports on CampaignMonitor Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CampaignMonitor data.
-
Integrating Oracle Data in Talend Cloud Data Management Platform
Connect Oracle Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle.
-
Automated Continuous Flowlu Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Flowlu replication to Google Cloud SQL.
-
ETL ConvertKit in Oracle Data Integrator
This article shows how to transfer ConvertKit data into a data warehouse using Oracle Data Integrator.
-
Connect to Highrise Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Highrise.
-
Automated Continuous Factorial Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Factorial replication to IBM DB2.
-
Visualize Stripe Data in Sisense
Create an ElastiCube in Sisense app with access to Stripe data.
-
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.
-
Query Live Twilio Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Twilio data directly from the development environment.
-
Access Live Cosmos DB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cosmos DB data from your Google Sheets.
-
Access Live Kafka Data in Excel 365 Online (Excel for the web)
Connect to Kafka data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use Manus AI to Talk to Your SAP HANA 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 SAP HANA data.
-
Connect to Aweber Data from Crystal Reports
Use CData Connect AI to connect to and report on live Aweber data from Crystal Reports.
-
Use the CData Software ODBC Driver for CircleCI in MicroStrategy Web
Connect to CircleCI data in MicroStrategy Web using the CData Software ODBC Driver for CircleCI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for NASA
Provide connectivity to NASA data through an SAP BusinessObjects universe.
-
Replicate Grafana Data in Heroku for Use in Salesforce Connect
Replicate Grafana data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP SuccessFactors LMS data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
Create SSAS Tabular Models from Clio Data
How to build a SQL Server Analysis Service Tabular Model from Clio data using CData drivers.
-
Getting Started with the CData Power BI Connector for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Amazon Marketplace.
-
Integrate Live Zoho Creator Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Creator from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Creator data.
-
Build Visualizations of Amazon Athena Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon Athena data in Birst.
-
Automated Continuous Klaviyo Replication to Databricks
Use CData Sync for automated, continuous, customizable Klaviyo replication to Databricks.
-
How to connect Amazon QuickSight to Microsoft Dataverse Data
Create a connection to Microsoft Dataverse data in CData Connect AI and insert Microsoft Dataverse data into Amazon QuickSight SPICE to build interactive dashboards.
-
Configure the CData JDBC Driver for Salesforce in a Connection Pool in Tomcat
Connect to Salesforce data from a connection pool in Tomcat.
-
Publish Reports with OData Services in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OData services.
-
Rapidly Develop Mocean-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 Mocean.
-
Connect to Discord Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Discord data in Airbyte.
-
Create Power BI Reports on Real-Time ZohoInvoice Data
Use the CData ODBC Driver for ZohoInvoice to visualize ZohoInvoice data in Power BI Desktop.
-
Publish Crystal Reports on Telegram Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Telegram data.
-
How to Easily Query Instantly Data in OpenOffice Base
Connect to Instantly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Google's Antigravity Agent with Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live BigQuery data using the Model Context Protocol.
-
How to Visualize AlloyDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live AlloyDB data in Python.
-
How to connect PolyBase to Marketo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Marketo data.
-
Build Bannerbear-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Bannerbear data.
-
Import and Visualize Redshift Data in Power View
Create data visualizations based on Redshift data in Excel.
-
Integrating OpenCode with Act CRM 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 Dynamics 365 with Apache Airflow
Access and process Dynamics 365 data in Apache Airflow using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Asana
Create an ODBC connection to Asana in Informatica and browse and transfer Asana data.
-
Access Live BenchmarkEmail Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BenchmarkEmail data from your Google Sheets.
-
Automated Continuous Act-On Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Act-On replication to Apache Cassandra.
-
Create Data Visualizations in Cognos BI with Lakebase Data
Access Lakebase data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Migrating data from Factorial to Google BigQuery using CData SSIS Components.
Easily push Factorial data to Google BigQuery using the CData SSIS Tasks for Factorial and Google BigQuery.
-
Use Databricks Agent Bricks to Talk to Your Oracle HCM Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Oracle HCM Cloud data for you.
-
Query Spark Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Spark data from Node.js.
-
How to Access Live JSON Services in Power Automate Desktop via ODBC
The CData ODBC Driver for JSON enables you to integrate JSON services into workflows built using Microsoft Power Automate Desktop.
-
Moving Data from SageHR to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SageHR data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Stream Zoom Data into Apache Kafka Topics
Access and stream Zoom data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Natively Connect to SAP Fieldglass Data in PHP
The CData ODBC driver for SAP Fieldglass enables you to create PHP applications with connectivity to SAP Fieldglass data. Leverage the native support for ODBC in PHP.
-
How to create Visio diagrams from Vault CRM Data
Automatically update Vault CRM data with the changes you make to Visio master shapes.
-
How to Access Auth0 Data Using Entity Framework
This article shows how to access Auth0 data 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 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Prepare, Blend, and Analyze SharePoint Data in Alteryx Designer (Connect AI)
Build workflows to access live SharePoint data for self-service data analytics.
-
Sugar CRM Reporting in OBIEE with the Sugar CRM JDBC Driver
Deploy the Sugar CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Chargebee Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Chargebee and work with Chargebee data in your FileMaker applications.
-
Visualize Live BigCommerce Data in the Power BI Service
Use CData Connect AI to connect to live BigCommerce data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Yelp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Yelp replication to AlloyDB.
-
How to integrate Metabase with Phoenix Data
Use CData Connect AI to connect to live Phoenix data and create an interactive dashboard in Metabase from Phoenix data.
-
Connect to Adobe Target Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Target and the SQL Gateway to access Adobe Target data from Google Apps Script.
-
Apify Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apify data through CData Connect AI using different applications and tools.
-
Access Adobe Analytics Data from MySQL in Amazon QuickSight
Connect to Adobe Analytics and build visualizations of Adobe Analytics data using a MySQL Connection in Amazon QuickSight.
-
Connect and Visualize Live Oracle HCM Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle HCM Cloud data into the Databricks platform and create visualization dashboards with real-time Oracle HCM Cloud data.