CData Software - Knowledge Base
Recent Articles
-
How to Seamlessly Import Twilio Data into IBM SPSS Modeler
Integrate Twilio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Quaderno
Provide connectivity to Quaderno data through an SAP BusinessObjects universe.
-
Analyze Anaplan Data in Cognos Analytics
Use CData Connect AI to connect to Anaplan Data from Cognos Analytics and analyze live Anaplan data.
-
Build Data Flows from SQL Server to Impala through SSIS
Easily push SQL Server data to Impala using the CData SSIS Tasks for Impala.
-
Replicate Attio Data to Multiple Databases via the CData Sync CLI
Replicate Attio data to disparate databases with a single configuration.
-
Build Acumatica-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Acumatica data and build Acumatica-connected web apps with Axios.
-
Deploy the ADO.NET Provider for WordPress on an SSRS Report Server
Connect to WordPress data 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.
-
Connect to Grafana from a Connection Pool in WebLogic
Use the CData JDBC Driver for Grafana to connect to Grafana data from Web applications running on WebLogic.
-
How to create SAP Hybris C4C federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Hybris C4C data in MySQL .
-
Build Dashboards with Email Data in Dundas BI
Create dynamic dashboards and perform analytics based on Email data in Dundas BI.
-
Automated Continuous Google Cloud Storage Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Oracle.
-
Visualize xBase Data in TIBCO Spotfire through ADO.NET
Integrate xBase data into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Hive
Create an ODBC connection to Hive in Informatica and browse and transfer Hive data.
-
Access Rebilly Data from MySQL in Amazon QuickSight
Connect to Rebilly and build visualizations of Rebilly data using a MySQL Connection in Amazon QuickSight.
-
Integrate with Live Klipfolio Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Klipfolio from the MuleSoft Anypoint Platform to integrate live Klipfolio data into custom reports and dashboards.
-
Build Visualizations of DB2 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of DB2 data in Birst.
-
Use Dash to Build to Web Apps on SAP Ariba Procurement Data
Create Python applications that use pandas and Dash to build SAP Ariba Procurement-connected web apps.
-
Creating Lakebase-Connected Applications in Unqork
You can use CData Connect AI to feed Lakebase data to Unqork and build custom business apps.
-
Use ChatGPT to Talk to Your Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Spark data for you.
-
Use the CData Software ODBC Driver for Wave Financial in MicroStrategy Web
Connect to Wave Financial data in MicroStrategy Web using the CData Software ODBC Driver for Wave Financial.
-
Import HubSpot Data Using Azure Data Factory
Use CData Connect AI to connect to HubSpot Data from Azure Data Factory and import live HubSpot data.
-
Access Live YouTube Analytics Data in TIBCO Data Virtualization
Use the YouTube Analytics Tibco DV Adapter to create a YouTube Analytics data data source in TIBCO Data Virtualization Studio and gain access to live YouTube Analytics data from your TDV Server.
-
Integrating GitHub Copilot with Avalara AvaTax 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.
-
Integrating Cursor with Shippo 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.
-
Integrating Cursor with Cvent 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 update CockroachDB from Excel
This article explains how to transfer data from Excel to CockroachDB using the Excel Add-In for CockroachDB.
-
How to Query Salesforce Data in MySQL Workbench
Execute MySQL queries against live Salesforce data from MySQL Workbench.
-
Automated Continuous Typeform Replication to Snowflake
Use CData Sync for automated, continuous, customizable Typeform replication to Snowflake.
-
Use the CData Software ODBC Driver for Asana in MicroStrategy Desktop
Connect to Asana data in MicroStrategy Desktop using the CData Software ODBC Driver for Asana.
-
Build AI/ML Models with Live Spark Data using Dataiku
Connect Spark Data with Dataiku using the CData JDBC Driver for Spark.
-
Connect to Notion Data from PowerBuilder via JDBC
This article demonstrates how to access Notion data from PowerBuilder using the Notion JDBC Driver.
-
Extending QuickBooks Online Reporting
The CData Data Providers for QuickBooks Online make it easy for you to create new reports and customize existing ones. This article demonstrates how to create a new Item Profitability Report. Using the ADO.NET provider, you can then retrieve it directly from Server Explorer in Visual Studio.
-
Integrate with Live Microsoft Planner Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Planner from the MuleSoft Anypoint Platform to integrate live Microsoft Planner data into custom reports and dashboards.
-
Connect xBase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect xBase with IBM WebSphere for seamless data integration and connectivity.
-
Deploy the ADO.NET Provider for Reckon Accounts Hosted on an SSRS Report Server
Connect to Reckon Accounts Hosted data 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.
-
Access Live LDAP Objects in TIBCO Data Virtualization
Use the LDAP Tibco DV Adapter to create a LDAP objects data source in TIBCO Data Virtualization Studio and gain access to live LDAP objects from your TDV Server.
-
How to Query Simplesat Data in MySQL Workbench
Execute MySQL queries against live Simplesat data from MySQL Workbench.
-
LINQ to EmailOctopus 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 EmailOctopus Data Provider.
-
Build Semantic Layer Views for Microsoft Ads Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Ads data.
-
Connect to Certinia Data from Crystal Reports
Use CData Connect AI to connect to and report on live Certinia data from Crystal Reports.
-
Integrating Kiro with ServiceDesk Plus 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.
-
Automated Continuous Strava Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Strava replication to Amazon Redshift.
-
Automated Continuous Parallel Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Parallel replication to Apache Cassandra.
-
Import and Visualize Spotify Data in Power View
Create data visualizations based on Spotify data in Excel.
-
Connect to Azure Analysis Services Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Analysis Services data.
-
Automated Continuous SAP HANA Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP HANA data replication to OneLake in Microsoft Fabric.
-
Integrate Cline with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Instagram data from within your IDE.
-
Query, Visualize, and Share live JSON Services in Redash
Use CData Connect AI to connect to live JSON services in Redash for querying, visualizing, and sharing.
-
Use the CData ODBC Driver for Amazon S3 in Microsoft Power Query
You can use the CData Amazon S3 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon S3 data into Microsoft Power Query.
-
Provide OData Services of PostgreSQL Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PostgreSQL data by developing a WCF Service Application.
-
Integrate DocuSign Data in the Pentaho Report Designer
Publish reports based on DocuSign data in the Pentaho BI tool.
-
Prepare, Blend, and Analyze Facebook Data in Alteryx Designer (Connect AI)
Build workflows to access live Facebook data for self-service data analytics.
-
How to Connect to Live Adobe Experience Manager Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Adobe Experience Manager data through natural language.
-
How to Connect Flowise AI Agents to Live Google Campaign Manager 360 Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Campaign Manager 360 data without replication.
-
Build Authorize.Net-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Authorize.Net Data from Zoho Analytics and import live Authorize.Net data.
-
Build Visualizations of Google Spanner Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Spanner data in Birst.
-
Connect to Adobe Target Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Target data in the Denodo Virtual DataPort Administrator.
-
Connect to Harvest Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Harvest and work with Harvest data in your FileMaker applications.
-
Automated Continuous SAS xpt Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAS xpt replication to SQL Server.
-
Create a Data Access Object for Certinia Data using JDBI
A brief overview of creating a SQL Object API for Certinia data in JDBI.
-
Build an OLAP Cube in SSAS from BigCommerce Data
Establish a connection to BigCommerce data data from SQL Server Analysis Services, and use the BigCommerce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Apollo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apollo data and build Apollo-connected web apps with Axios.
-
Access Live SendInBlue Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SendInBlue data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Apps from ZohoMarketingHub Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoMarketingHub Data and build apps from live ZohoMarketingHub data in Qlik Sense Cloud.
-
Replicate ZohoMarketingHub Data in Heroku for Use in Salesforce Connect
Replicate ZohoMarketingHub data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automate RabbitMQ Data Replication to SAP HANA
Use CData Sync to customize and automate RabbitMQ data replication to SAP HANA.
-
Connect to Zoho CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho CRM data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Suadeo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Suadeo Data and connect to Suadeo data in Akorbi Digital RunMyProcess.
-
Automated Continuous Xero Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Xero data replication to OneLake in Microsoft Fabric.
-
Query Email Data in DataGrip
Create a Data Source for Email in DataGrip and use SQL to query live Email data.
-
Getting Started with the CData Connect AI Python SDK for Splunk
Install the CData Connect AI Python SDK to read and write live Splunk data with standard DB-API 2.0 Python code.
-
Connecting Moonlit Workflow with Neo4J 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 Neo4J data in real time.
-
Automated Continuous Placid Replication to SQLite
Use CData Sync for automated, continuous, customizable Placid replication to SQLite.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for FTP
Provide connectivity to FTP data through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Gong Data
Use the CData ODBC Driver for Gong to visualize Gong data in Power BI Desktop.
-
How to integrate Metabase with Gmail Data
Use CData Connect AI to connect to live Gmail data and create an interactive dashboard in Metabase from Gmail data.
-
Integrating GitHub Copilot with Clio 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.
-
Connect to Sage 200 Data from a Connection Pool in Jetty
The Sage 200 JDBC Driver supports connection pooling: This article shows how to connect faster to Sage 200 data from Web apps in Jetty.
-
Integrate Theia IDE with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Google Sheets data from within the development environment.
-
How to load NetSuite data into Elasticsearch via Logstash
Introducing a simple method to load NetSuite data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live Google Analytics 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 Analytics data for you.
-
Connect to SparkPost from a Connection Pool in WebLogic
Use the CData JDBC Driver for SparkPost to connect to SparkPost data from Web applications running on WebLogic.
-
Process & Analyze LeadDesk Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LeadDesk Data.
-
Connect to Quaderno Data in Ruby
Connect to Quaderno data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Gumloop with Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Tally data within automated workflows.
-
Automated Continuous Excel Online Replication to SQL Server
Use CData Sync for automated, continuous, customizable Excel Online replication to SQL Server.
-
Connect to YouTube Analytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for YouTube Analytics data in Airbyte.
-
Connect QuickBooks Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your QuickBooks data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize ConstantContact Data in TIBCO Spotfire through ADO.NET
Integrate ConstantContact data into dashboards in TIBCO Spotfire.
-
How to connect and process SAP ByDesign data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP ByDesign data.
-
Integrating Codex with Cloudflare 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 WordPress Data in the Pentaho Report Designer
Publish reports based on WordPress data in the Pentaho BI tool.
-
Connect to Klipfolio Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Klipfolio and work with Klipfolio data in your FileMaker applications.
-
Connect to Apollo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Apollo and the SQL Gateway to access Apollo data from Google Apps Script.
-
How to Work with JobNimbus Data in ETL Validator JDBC
Connect to JobNimbus from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Azure Data Lake Storage-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Data Lake Storage data and build Azure Data Lake Storage-connected web apps with Axios.
-
Build Raisers Edge NXT-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Raisers Edge NXT data without replication.
-
Connect to Stack Exchange from a Connection Pool in WebLogic
Use the CData JDBC Driver for Stack Exchange to connect to Stack Exchange data from Web applications running on WebLogic.
-
Enable the Box JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Box data.
-
A PostgreSQL Interface for TaxJar Data (MySQL Remoting via JDBC)
Use the Remoting features of the TaxJar JDBC Driver to create a PostgreSQL entry-point for data access.