CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for YouTube Analytics in MicroStrategy
Connect to YouTube Analytics in MicroStrategy Developer using the CData Software ODBC Driver for YouTube Analytics.
-
Integrating LangGraph with SAP BusinessObjects BI Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP BusinessObjects BI within automated workflows.
-
Replicate HDFS Data to Multiple Databases via the CData Sync CLI
Replicate Apache HDFS to disparate databases with a single configuration.
-
Automated Continuous Rebilly Replication to MongoDB
Use CData Sync for automated, continuous, customizable Rebilly replication to MongoDB.
-
Build Redshift-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Redshift Data and create custom apps in Mendix.
-
Create Airtable-Connected Applications in Appsmith
Connect to Airtable Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Airtable.
-
Build Data Flows from Act CRM to SQL Server using SSIS
Easily back up Act CRM to SQL Server using the SSIS components for Act CRM.
-
Connect to Freshsales Data in DBArtisan
Use wizards in DBArtisan to configure Freshsales as a data source.
-
Getting Started with the CData Python Connector for Twilio
Learn to install and license the CData Python Connector
-
How to create an RPA flow for Google Ad Manager Data in UiPath Studio
Use the Google Ad Manager ODBC Driver to create workflows that access real-time Google Ad Manager without any coding.
-
Getting Started with the CData Excel Add-In for SAP HANA
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP HANA.
-
Integrate Workable Data in the Pentaho Report Designer
Publish reports based on Workable in the Pentaho BI tool.
-
Integrate with Live SurveyMonkey Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SurveyMonkey from the MuleSoft Anypoint Platform to integrate live SurveyMonkey into custom reports and dashboards.
-
How to Query Live Missive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Missive data in natural language using Python.
-
Publish Google Campaign Manager 360-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Campaign Manager 360.
-
Integrate Theia IDE with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Dynamics CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to IBM DB2.
-
Connect to Google Cloud Storage Data from PowerBuilder via JDBC
This article demonstrates how to access Google Cloud Storage from PowerBuilder using the Google Cloud Storage JDBC Driver.
-
Create Datasets from Freshservice in Domo Workbench and Build Visualizations of Freshservice Data in Domo
Use the CData Software ODBC Driver for Freshservice to create datasets from Freshservice in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Quickbase Data in Claris FileMaker Pro
Use the CData ODBC Driver for Quickbase in FileMaker Pro to connect to Quickbase and work with Quickbase in your FileMaker applications.
-
Build Charts with Snowflake Data in Clear Analytics
Create dynamic charts and perform analytics based on Snowflake in Clear Analytics.
-
Connect to FTP Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for FTP Data and connect to FTP Servers in Akorbi Digital RunMyProcess.
-
Automate Bitbucket Data Replication to Azure Synapse
Use CData Sync to customize and automate Bitbucket replication to Azure Synapse.
-
How to Work with Google Drive Data in ETL Validator JDBC
Connect to Google Drive from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Asana Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Asana from your Oracle system.
-
Integrating Moosend Data in Talend Cloud Data Management Platform
Connect Moosend Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Dynamics 365 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Dynamics 365 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import SAP Concur Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Concur. In this article, you will use the OData format to import SAP Concur into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Presto in MicroStrategy
Connect to Presto in MicroStrategy Developer using the CData Software ODBC Driver for Presto.
-
Extend Google Sheets with BigCommerce Data
Make calls to BigCommerce from Google Apps Script via the API Server.
-
Automated Continuous Cassandra Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Cassandra replication to PostgreSQL.
-
Extract, Transform, and Load Keap Data in Informatica PowerCenter
Create a simple Workflow for Keap in Informatica PowerCenter.
-
Connect to Clockify Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Clockify.
-
Build Azure Synapse-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Synapse.
-
Getting Started with the CData Power BI Connector for Opsgenie
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Oracle HCM Cloud-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle HCM Cloud Data from Zoho Analytics and import live Oracle HCM Cloud.
-
How to integrate Datadog with Apache Airflow
Access and process Datadog in Apache Airflow using the CData JDBC Driver.
-
Trigger Salesforce Pardot IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesforce Pardot with standard wizards in Logic Apps.
-
Building Dynamic Web Pages with Jira Assets Data Using AngularJS
Create single-page applications with live connectivity to Jira Assets using the CData API Server.
-
How to create Odoo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Odoo ERP in MySQL .
-
Automated Continuous AlloyDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable AlloyDB replication to Apache Cassandra.
-
Use Dash to Build to Web Apps on Coinbase Data
Create Python applications that use pandas and Dash to build Coinbase-connected web apps.
-
Getting Started with the CData Power BI Connector for Pipedrive
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Pipedrive.
-
Prepare, Blend, and Analyze Wrike Data in Alteryx Designer (ODBC)
Build workflows to access live Wrike for self-service data analytics.
-
Replicate Amazon S3 Data in Heroku for Use in Salesforce Connect
Replicate Amazon S3 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
SQL Gateway: Superior SQL Linked Server Integration through SQL TDS
Using a TDS remoting service is superior to the OLE DB Provider when working with ODBC data in SQL Server.
-
Use Agno to Talk to Your Active Directory 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 Active Directory for you.
-
Automated Continuous Supabase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Supabase replication to Google Cloud SQL.
-
Migrating data from Presto to Databricks using CData SSIS Components.
Easily push Presto to Databricks using the CData SSIS Tasks for Presto and Databricks.
-
Integrating Kiro CLI with Gorgias 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.
-
Back Up ZohoExpense to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoExpense data.
-
How to Access Live Aircall Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Aircall enables you to integrate Aircall into workflows built using Microsoft Power Automate Desktop.
-
Back Up Eventbrite to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Eventbrite data.
-
Drip Reporting in OBIEE with the Drip JDBC Driver
Deploy the Drip JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Natively Connect to Redshift Data in PHP
The CData ODBC driver for Redshift enables you to create PHP applications with connectivity to Amazon Redshift. Leverage the native support for ODBC in PHP.
-
Automated Continuous ActiveCampaign Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Amazon Redshift.
-
Automated Continuous Avaza Replication to Snowflake
Use CData Sync for automated, continuous, customizable Avaza replication to Snowflake.
-
Integrating Antigravity CLI with Freshdesk via CData CLI
Connect Freshdesk to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Python Connector for Close
Learn to install and license the CData Python Connector
-
Access Deel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Deel from your Oracle system.
-
How to Access Amplitude Data Using Entity Framework
This article shows how to access Amplitude using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Webex Data in JReport Designer
Create charts and reports based on Webex in JReport Designer.
-
Build Charts with CampaignMonitor Data in Clear Analytics
Create dynamic charts and perform analytics based on CampaignMonitor in Clear Analytics.
-
Visualize Live Brex Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Brex using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Access
Provide connectivity to Microsoft Access through an SAP BusinessObjects universe.
-
Connect to SpaceX Data in JRuby
Create a simple JRuby app with access to live SpaceX.
-
DataBind Charts to SAP HANA Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP HANA 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.
-
Connect to OnePageCrm Data in HULFT Integrate
Connect to OnePageCrm as a JDBC data source in HULFT Integrate
-
Integrating Dataiku with Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Cvent.
-
Build a PostgreSQL Interface for BigQuery Data using the CData JDBC Driver
Use the Remoting features of the BigQuery JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create ShipEngine federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ShipEngine in MySQL .
-
Using the CData Software ODBC Driver for Google Ad Manager in PyCharm
Connect to Google Ad Manager as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Ad Manager.
-
Connect to Tally Data from AWS Glue
Use CData Connect AI to gain access to live Tally ERP from your AWS Glue jobs.
-
Automated Continuous PivotalTracker Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PivotalTracker replication to PostgreSQL.
-
How to Connect the Power BI Service to Microsoft Ads: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft Ads from PowerBI.com to provide real-time Microsoft Ads across the organization.
-
Connect to Float Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Float as an External Source in Dremio.
-
Use the CData Software ODBC Driver for ZohoSubscriptions in MicroStrategy Web
Connect to ZohoSubscriptions in MicroStrategy Web using the CData Software ODBC Driver for ZohoSubscriptions.
-
Automated Continuous Clari Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Clari replication to AlloyDB.
-
Access Live Azure Data Catalog Data in Coginiti Pro
Connect to and query live Azure Data Catalog from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Jumpseller Data in Pentaho Data Integration
Build ETL pipelines based on Jumpseller in the Pentaho Data Integration tool.
-
Connect to Google Campaign Manager 360 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Campaign Manager 360, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Enable the Freshsales JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Freshsales.
-
Connect to and Visualize Live SageHR Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SageHR.
-
Connect and Query Live Exact Online Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Exact Online into Databricks
-
How to Access Live SQL Analysis Services Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SQL Analysis Services enables you to integrate SQL Analysis Services into workflows built using Microsoft Power Automate Desktop.
-
ChargeOver Reporting in OBIEE with the ChargeOver JDBC Driver
Deploy the ChargeOver JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Greenhouse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Greenhouse replication to SingleStore.
-
How to Access Live Google Cloud Storage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Cloud Storage enables you to integrate Google Cloud Storage into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to Microsoft Planner Data in PHP
The CData ODBC driver for Microsoft Planner enables you to create PHP applications with connectivity to Microsoft Planner. Leverage the native support for ODBC in PHP.
-
Automated Continuous CouchDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CouchDB replication to IBM DB2.
-
Access Nethunt Data from MySQL in Amazon QuickSight
Connect to Nethunt and build visualizations of Nethunt using a MySQL Connection in Amazon QuickSight.
-
Visualize Wrike 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 Wrike into TIBCO Spotfire.
-
Connect to Sybase IQ Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Foursquare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Foursquare from Informatica Cloud.
-
Create Apps from Facebook Data in Qlik Sense Cloud
Use CData Connect AI to connect to Facebook Data and build apps from live Facebook in Qlik Sense Cloud.
-
Build AI/ML Models with Live Access Data using Dataiku
Connect Access Data with Dataiku using the CData JDBC Driver for Access.
-
Use JayDeBeApi to access Kintone Data in Python
Use standard Python scripting and the development environment of your choice to access live Kintone.
-
Create SSAS Tabular Models from LinkedIn Data
How to build a SQL Server Analysis Service Tabular Model from LinkedIn using CData drivers.
-
Migrating data from Strava to Snowflake using CData SSIS Components.
Easily push Strava to Snowflake using the CData SSIS Tasks for Strava and Snowflake.
-
Using the CData Software ODBC Driver for Amazon DynamoDB in PyCharm
Connect to Amazon DynamoDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon DynamoDB.