CData Software - Knowledge Base
Recent Articles
-
Create Authorize.Net-Connected Dashboards in Grafana
Connect to Authorize.Net Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Authorize.Net.
-
Automated Continuous REST Replication to SQLite
Use CData Sync for automated, continuous, customizable REST replication to SQLite.
-
Visualize Pipeliner CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pipeliner CRM.
-
Connect to Google Calendar Data from AWS Glue
Use CData Connect AI to gain access to live Google Calendar from your AWS Glue jobs.
-
Moving Data from CouchDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CouchDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Zoho Projects Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoho Projects and integrate live Zoho Projects into your Power Automate tasks.
-
Query, Visualize, and Share live SharePoint Data in Redash
Use CData Connect AI to connect to live Microsoft SharePoint in Redash for querying, visualizing, and sharing.
-
Extract, Transform, and Load GetResponse Data in Informatica PowerCenter
Create a simple Workflow for GetResponse in Informatica PowerCenter.
-
Integrate Reckon Accounts Hosted Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Reckon Accounts Hosted and integrate live Reckon Accounts Hosted into your Power Automate tasks.
-
Configure the CData JDBC Driver for Short.io in a Connection Pool in Tomcat
Connect to Short.io from a connection pool in Tomcat.
-
Build Sugar CRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sugar CRM and build visualizations in Tableau.
-
Creating Twilio-Connected Applications in Unqork
You can use CData Connect AI to feed Twilio to Unqork and build custom business apps.
-
How to connect to HDFS Data from IntelliJ
Integrate connectivity to Apache HDFS with wizards in IntelliJ.
-
Integrate Teamwork Data in the Pentaho Report Designer
Publish reports based on Teamwork in the Pentaho BI tool.
-
Add Mailgun Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mailgun with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Dash to Build Web Apps on Square Data via CData Connect AI
Build interactive Dash web apps on live Square using pandas and the CData Connect AI Python SDK.
-
Connect to HDFS Data in HULFT Integrate
Connect to HDFS as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ADO.NET Provider for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zoho Inventory.
-
Natively Connect to Missive Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Missive. Leverage the native support for ODBC in PHP.
-
Replicate HelloSign Data to Multiple Databases
Replicate HelloSign to disparate databases with a point-and-click configuration.
-
Connect Airtable to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Airtable with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for Shopify in MicroStrategy Web
Connect to Shopify in MicroStrategy Web using the CData Software JDBC Driver for Shopify.
-
Automated Continuous Adobe Target Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Adobe Target replication to Amazon S3.
-
Publish Raisers Edge NXT-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Raisers Edge NXT.
-
ETL Timely in Oracle Data Integrator
This article shows how to transfer Timely into a data warehouse using Oracle Data Integrator.
-
Connect to Attio Data in Ruby
Connect to Attio in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Migrating data from Spark to Snowflake using CData SSIS Components.
Easily push Apache Spark SQL to Snowflake using the CData SSIS Tasks for Spark and Snowflake.
-
Write a Simple Go Application to work with Avro Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache Avro.
-
Automated Continuous Autopilot Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Autopilot replication to AlloyDB.
-
Access Live Act CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Act CRM from your Excel spreadsheets.
-
Use the CData ODBC Driver for ShipStation in Microsoft Power Query
You can use the CData ShipStation ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ShipStation into Microsoft Power Query.
-
Connect Snapchat Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Snapchat Ads with IBM WebSphere for seamless data integration and connectivity.
-
Manage Zoho CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho CRM.
-
Use the CData Software JDBC Driver for GitHub in MicroStrategy
Connect to GitHub in MicroStrategy Developer using the CData Software JDBC Driver for GitHub.
-
Use Biml to Build SSIS Tasks to Replicate Shippo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Shippo to SQL Server.
-
Getting Started with the CData Python Connector for ShipEngine
Learn to install and license the CData Python Connector
-
How to Create Power BI Visual Reports with Real-Time Wistia Data
Use CData Power BI Connectors to visualize Wistia in Power BI.
-
Connect to Greenhouse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Greenhouse to connect to Greenhouse and execute queries in PowerBuilder.
-
Provide OData Services of ZohoExpense Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoExpense by developing a WCF Service Application.
-
How to connect to Google Cloud Storage Data from Spring Boot
Connect to Google Cloud Storage in a Spring Boot Application using the CData JDBC Driver for Google Cloud Storage
-
How to Work with SAP Concur Data in ETL Validator JDBC
Connect to SAP Concur from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Perigon in SpagoBI
Create reports featuring live Perigon in SpagoBI Studio. Host Perigon reports on SpagoBI Server.
-
Build Charts with Couchbase Data in Clear Analytics
Create dynamic charts and perform analytics based on Couchbase in Clear Analytics.
-
Stream Zoho Projects Data into Apache Kafka Topics
Access and stream Zoho Projects in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Enable the Quickbase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Quickbase.
-
Create SSAS Tabular Models from Samanage Data
How to build a SQL Server Analysis Service Tabular Model from Samanage using CData drivers.
-
Connect to Cvent Data in DBArtisan
Use wizards in DBArtisan to configure Cvent as a data source.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Hive actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Seamlessly Import GitHub Data into IBM SPSS Modeler
Integrate GitHub data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Dynamics CRM Data in RazorSQL
Connect to Dynamics CRM from wizards and query Microsoft Dynamics CRM from the GUI in the RazorSQL database management tool.
-
Create Power BI Reports on Real-Time SAP Fieldglass Data
Use the CData ODBC Driver for SAP Fieldglass to visualize SAP Fieldglass in Power BI Desktop.
-
Process & Analyze Clio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Clio Data.
-
Visualize Supabase Data in TIBCO Spotfire through ADO.NET
Integrate Supabase into dashboards in TIBCO Spotfire.
-
Natively Connect to Mailjet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mailjet. Leverage the native support for ODBC in PHP.
-
Build DB2 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live IBM DB2 and build visualizations in Tableau Cloud.
-
Connect to Phoenix Data from AWS Glue
Use CData Connect AI to gain access to live Apache Phoenix from your AWS Glue jobs.
-
Getting Started with the CData Power BI Connector for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Perform Batch Operations with Salesforce CRM Analytics Data in Apache NiFi
Connect to Salesforce CRM Analytics and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create a Data Access Object for Google Calendar Data using JDBI
A brief overview of creating a SQL Object API for Google Calendar in JDBI.
-
How to Build an ETL App for Couchbase Data in Python with CData
Create ETL applications and real-time data pipelines for Couchbase in Python with petl.
-
Integrating GitHub Copilot CLI with Google Contacts 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.
-
Import Slack Data Using Azure Data Factory
Use CData Connect AI to connect to Slack Data from Azure Data Factory and import live Slack.
-
How to Connect to SAP SuccessFactors Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP SuccessFactors. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for Authorize.Net in SAS for Real-Time Reporting and Analytics
Connect to real-time Authorize.Net in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Authorize.Net.
-
How to Connect to Supabase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Supabase. Leverage the pyodbc module for ODBC in Python.
-
Explore Geographical Relationships in ShipEngine Data with Power Map
Create data visualizations with ShipEngine in Power Map.
-
DataBind Acumatica Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Acumatica with the DevExpress Windows Forms and Web controls to provide Acumatica ERP to a chart.
-
DataBind Controls to Square Data in C++Builder
DataBind to Square in C++Builder with standard components and controls.
-
Connect to Amazon Athena Data in NetBeans
Connect to Amazon Athena in NetBeans with the data source configuration wizard.
-
Automated Continuous ZohoMarketingHub Replication to Oracle
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Oracle.
-
Access Google Tasks Data from MySQL in PHP
Connect to Google Tasks through the standard MySQL libraries in PHP.
-
Query Live Zoho Creator 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 Zoho Creator directly from the development environment.
-
Use Agno to Talk to Your Presto 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 Presto for you.
-
How to create an RPA flow for Close Data in UiPath Studio
Use the Close ODBC Driver to create workflows that access real-time Close without any coding.
-
Getting Started with the CData JDBC Driver for Quickbase
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Quickbase.
-
Visualize Live Factorial Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Factorial using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Power BI Connector for BigCommerce
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for BigCommerce.
-
Build a Singer.io Tap for Workday With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Workday data using
-
Configure the CData JDBC Driver for Okta in a Connection Pool in Tomcat
Connect to Okta from a connection pool in Tomcat.
-
Build Visualizations of Quickbase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Quickbase in Birst.
-
Create Informatica Mappings From/To an ODBC Data Source for Billsby
Create an ODBC connection to Billsby in Informatica and browse and transfer Billsby.
-
Create SSAS Tabular Models from Pipeliner CRM Data
How to build a SQL Server Analysis Service Tabular Model from Pipeliner CRM using CData drivers.
-
Access Live ChargeOver Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ChargeOver in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build SharePoint-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SharePoint Data and create custom apps in Bubble.
-
Load ServiceDesk Plus Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ServiceDesk Plus to a database.
-
Replicate Unbounce Data in Heroku for Use in Salesforce Connect
Replicate Unbounce to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to MailerSend Data in DBArtisan
Use wizards in DBArtisan to configure MailerSend as a data source.
-
Build MVC Applications with Connectivity to Foursquare Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Foursquare from an ASP.NET MVC application.
-
Integrate with QuickBooks Time Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy QuickBooks Time to a JSON file on disk.
-
Create a Data Access Object for Autopilot Data using JDBI
A brief overview of creating a SQL Object API for Autopilot in JDBI.
-
Connect to Flowlu Data from a Connection Pool in JBoss
Integrate Flowlu into Java servlets: Use the Management Console in JBoss to install the Flowlu JDBC Driver.
-
LINQ to Todoist 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 Todoist Data Provider.
-
DataBind Charts to Sage 200 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sage 200 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.
-
Integrating Gumloop with Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Database within automated workflows.
-
Easily Integrate Aweber Data in Lazarus Pascal IDE
Learn how to easily integrate live Aweber in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Rapidly Develop Todoist-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 Todoist.
-
How to import Jodoo Data into Apache Solr
Use the CData Software JDBC Driver for Jodoo in Data Import Handler and create an automated import of Jodoo to Apache Solr Enterprise Search platform.
-
Migrating data from Postmark to Snowflake using CData SSIS Components.
Easily push Postmark to Snowflake using the CData SSIS Tasks for Postmark and Snowflake.
-
How to Connect to & Open Telegram Data in Microsoft Excel
This article uses the CData ODBC driver for Telegram to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build MySQL-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for MySQL to explore live MySQL Data in Gemini Code Assist to assist with building MySQL-powered applications.