CData Software - Knowledge Base
Recent Articles
-
Build Charts with TigerGraph Data in Clear Analytics
Create dynamic charts and perform analytics based on TigerGraph in Clear Analytics.
-
Integrate Jodoo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jodoo with External Services.
-
Operational Reporting on LDAP Objects from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LDAP.
-
Write a Simple Go Application to work with Pipeliner CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pipeliner CRM.
-
Automated Continuous Snapchat Ads Replication to Vertica
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Vertica.
-
Access Live Tally Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Tally ERP from your Excel spreadsheets.
-
Automate HubDB Data Replication to Azure Synapse
Use CData Sync to customize and automate HubDB replication to Azure Synapse.
-
ETL MailerLite in Oracle Data Integrator
This article shows how to transfer MailerLite into a data warehouse using Oracle Data Integrator.
-
How to connect to Strava Data in DBVisualizer
Integrate Strava with visual data analysis tools and data connection wizards in DBVisualizer
-
View Reports on Real-Time Zendesk Data in Power BI Report Server
Use the CData ODBC Driver for Zendesk to visualize Zendesk in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Jodoo to Snowflake using CData SSIS Components.
Easily push Jodoo to Snowflake using the CData SSIS Tasks for Jodoo and Snowflake.
-
Access SAP HANA XS Advanced Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP HANA XS Advanced from your Oracle system.
-
Visualize Live Rootly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Rootly using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate EmailOctopus Data to Multiple Databases
Replicate EmailOctopus to disparate databases with a point-and-click configuration.
-
Consume MailChimp OData Feeds in PowerBuilder
This article demonstrates how to consume MailChimp as OData feeds from PowerBuilder using the API Server.
-
Analyze Tavily Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Tavily from Power Pivot. You will use the Table Import Wizard to load Tavily. You can visually build the import query or use any SQL supported by the driver.
-
Build AI/ML Models with Live Zoho CRM Data using Dataiku
Connect Zoho CRM Data with Dataiku using the CData JDBC Driver for Zoho CRM.
-
Object-Relational Mapping (ORM) with Figshare 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 Figshare into a Java-based ORM framework, Hibernate.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Campaigner
Provide connectivity to Campaigner through an SAP BusinessObjects universe.
-
Natively Connect to EmailOctopus Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to EmailOctopus. Leverage the native support for ODBC in PHP.
-
Replicate Pipeline CRM Data from PowerShell
Write a quick PowerShell script to query Pipeline CRM. Use connectivity to the live data to replicate Pipeline CRM to SQL Server.
-
Build MVC Applications with Connectivity to SendPulse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SendPulse from an ASP.NET MVC application.
-
How to Visualize Google Cloud Storage Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Cloud Storage in Python.
-
Connect to Databricks Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Databricks and the SQL Gateway to access Databricks from Google Apps Script.
-
Access Live BigCommerce Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BigCommerce from your Google Sheets.
-
Add Oracle Eloqua Reporting Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Eloqua Reporting with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to work with Presto Data in Apache Spark using SQL
Access and process Presto Data in Apache Spark using the CData Software JDBC Driver.
-
How to Build an ETL App for Lakebase Data in Python with CData
Create ETL applications and real-time data pipelines for Lakebase in Python with petl.
-
How to Work with MySQL Data in AWS Glue Jobs Using JDBC
Connect to MySQL from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import Real-Time SAP Hybris C4C Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Hybris C4C in ColdFusion.
-
How to Query Live Zoho CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho CRM data in natural language using Python.
-
Automated Continuous Zoho CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho CRM replication to SQLite.
-
Connect to and Visualize Live Zendesk Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zendesk.
-
How to Connect the Power BI Service to Trello: Complete Guide
Connect to the CData Software Power BI Connector for Trello from PowerBI.com to provide real-time Trello across the organization.
-
Use the CData ODBC Driver for ClickTime in Microsoft Power Query
You can use the CData ClickTime ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ClickTime into Microsoft Power Query.
-
Connect Sendwithus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sendwithus with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData ODBC Driver for Customer.io in Microsoft Power Query
You can use the CData Customer.io ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Customer.io into Microsoft Power Query.
-
Getting Started with the CData Tableau Connector for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for eBay Analytics.
-
Connect Teradata to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Teradata with IBM WebSphere for seamless data integration and connectivity.
-
Connect to CapsuleCRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CapsuleCRM and the SQL Gateway to access CapsuleCRM from Google Apps Script.
-
Use ChatGPT to Talk to Your IBM Cloud Object Storage 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 IBM Cloud Object Storage for you.
-
Create Power BI Reports on Real-Time CircleCI Data
Use the CData ODBC Driver for CircleCI to visualize CircleCI in Power BI Desktop.
-
Connect to Stripe Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Stripe.
-
Connect to Snowflake Data in NetBeans
Connect to Snowflake in NetBeans with the data source configuration wizard.
-
How to Query Live Avro Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache Avro data in natural language using Python.
-
Integrating Kiro CLI with Salesforce Data 360 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.
-
Moving Data from Basecamp to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Basecamp data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Sage 300 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sage 300 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Visualize SAS xpt 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 SAS XPORT into TIBCO Spotfire.
-
Create Marketo-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Marketo Data from OutSystems and build custom enterprise apps using live Marketo.
-
Connect to Airtable Data from Crystal Reports
Use CData Connect AI to connect to and report on live Airtable from Crystal Reports.
-
Access Live Factorial Data in Coginiti Pro
Connect to and query live Factorial from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Standards-Based Access to NoSQL Data Sources
Create a schema to access MongoDB objects from any CData driver technology.
-
A PostgreSQL Interface for Typeform Data (MySQL Remoting via JDBC)
Use the Remoting features of the Typeform JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Google Analytics Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Analytics data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use Dash to Build to Web Apps on Workable Data
Create Python applications that use pandas and Dash to build Workable-connected web apps.
-
Automated Continuous BenchmarkEmail Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Google Cloud SQL.
-
Integrate Freshteam with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshteam with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshteam.
-
Connect Invoiced Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Invoiced using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Power BI Connector for Klaviyo
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Klaviyo.
-
Connect Lakebase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Lakebase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Hugging Face Data in DBArtisan
Use wizards in DBArtisan to configure Hugging Face as a data source.
-
How to Seamlessly Import Amplitude Data into IBM SPSS Modeler
Integrate Amplitude data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
DataBind Charts to MySQL Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MySQL from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build Apps with Live Google BigQuery in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google BigQuery into the Adalo platform and build custom mobile and web applications with real-time Google BigQuery.
-
Query Greenplum Data in ColdFusion
Write standard ColdFusion data access code to connect to Pivotal GreenPlum.
-
Enable the Google Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Ads.
-
How to Build an ETL App for Drift Data in Python with CData
Create ETL applications and real-time data pipelines for Drift in Python with petl.
-
Write a Simple Go Application to work with Snapchat Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Snapchat Ads.
-
Getting Started with the CData Excel Add-In for Cassandra
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cassandra.
-
Automated Continuous TaxJar Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable TaxJar replication to OneLake in Microsoft Fabric.
-
Integrating LlamaIndex with IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on IBM Cloud Object Storage in real time.
-
Build Data Flows from Suadeo to SQL Server using SSIS
Easily back up Suadeo to SQL Server using the SSIS components for Suadeo.
-
Build Cvent-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cvent.
-
Automated Continuous Codat Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Codat replication to Amazon Redshift.
-
Automated Continuous Amazon S3 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Amazon S3 replication to delimited files (CSV/TSV).
-
Create a Data Access Object for Twilio Data using JDBI
A brief overview of creating a SQL Object API for Twilio in JDBI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Planner
Provide connectivity to Microsoft Planner through an SAP BusinessObjects universe.
-
How to Work with Databricks Data in AWS Glue Jobs Using JDBC
Connect to Databricks from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Deploy the ADO.NET Provider for PolarTeamPro on an SSRS Report Server
Connect to PolarTeamPro 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.
-
Deploy the ADO.NET Provider for Gong on an SSRS Report Server
Connect to Gong 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 and Query LinkedIn Data in QlikView over ODBC
Create data visualizations with LinkedIn in QlikView.
-
Connect to Oracle Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Database in Airbyte.
-
Write a Simple Go Application to work with Apify Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apify.
-
Create Informatica Mappings From/To a JDBC Data Source for ScrapingBee
Create ScrapingBee data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous SingleStore Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SingleStore replication to Apache Kafka.
-
Publish Crystal Reports on Zuora Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zuora.
-
Connect to Zoom Data in RapidMiner
Integrate Zoom with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Neo4J Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Neo4J replication to OneLake in Microsoft Fabric.
-
Integrating LangGraph with Acumatica Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Acumatica ERP within automated workflows.
-
Explore Geographical Relationships in Landbot Data with Power Map
Create data visualizations with Landbot in Power Map.
-
Establish a Live Connection with Google Cloud Storage Data using Tableau Bridge
The CData ODBC Driver for Google Cloud Storage enables you to integrate live Google Cloud Storage into Tableau Cloud dashboards using the Tableau Bridge.
-
Build an OLAP Cube in SSAS from SAP Hybris C4C Data
Establish a connection to SAP Hybris C4C data from SQL Server Analysis Services, and use the SAP Hybris C4C Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Google Campaign Manager 360 Data in AWS Lambda
Connect to live Google Campaign Manager 360 in AWS Lambda using the CData JDBC Driver.
-
Build eBay-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for eBay to explore live eBay Data in Claude Code to assist with building eBay-powered applications.
-
Access Gmail Data from MySQL in PHP
Connect to Gmail through the standard MySQL libraries in PHP.
-
Enable the Exa JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Exa.
-
Connect to Real-Time Amplitude Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Amplitude in Power Apps.
-
Build Automated Greenplum-Connected Workflows in Zapier
Use CData Connect AI to connect to live Pivotal GreenPlum and build automated workflows in Zapier.
-
Automated Continuous Teamwork Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Teamwork replication to Apache Cassandra.