CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Lakebase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Lakebase.
-
Create SSAS Tabular Models from MarkLogic Data
How to build a SQL Server Analysis Service Tabular Model from MarkLogic using CData drivers.
-
Migrating data from Outlook to Snowflake using CData SSIS Components.
Easily push Outlook to Snowflake using the CData SSIS Tasks for Outlook and Snowflake.
-
Configure the CData JDBC Driver for Zoho Recruit in a Connection Pool in Tomcat
Connect to Zoho Recruit from a connection pool in Tomcat.
-
Automated Continuous Oracle Eloqua Reporting Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to OneLake in Microsoft Fabric.
-
How to Work with Placid Data in AWS Glue Jobs Using JDBC
Connect to Placid from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Stream VWO Data into Apache Kafka Topics
Access and stream VWO in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use JayDeBeApi to access Supabase Data in Python
Use standard Python scripting and the development environment of your choice to access live Supabase.
-
How to integrate ServiceNow with Apache Airflow
Access and process ServiceNow in Apache Airflow using the CData JDBC Driver.
-
Integrate Real-Time Access to Oracle Eloqua Reporting in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Eloqua Reporting in real time.
-
Use the CData ODBC Driver for ShipEngine from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ShipEngine to connect to ShipEngine from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ShipEngine in Excel.
-
Access Live Cosmos DB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Cosmos DB into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Cosmos DB in the Graph Builder and Query Builder.
-
Use the CData Software JDBC Driver for Microsoft Dataverse in MicroStrategy Web
Connect to Microsoft Dataverse (CDS) in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Dataverse.
-
ETL YouTube Analytics in Oracle Data Integrator
This article shows how to transfer YouTube Analytics into a data warehouse using Oracle Data Integrator.
-
Integrate WooCommerce Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to WooCommerce and integrate live WooCommerce into your Power Automate tasks.
-
How to Connect to Live SAP Concur Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP Concur for you.
-
Automated Continuous Figshare Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Figshare replication to Google BigQuery.
-
Connect to SAP Concur Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Concur Data and connect to SAP Concur in Akorbi Digital RunMyProcess.
-
How to Access Live Act CRM Data in Visual Studio Code via Cline
Run CData MCP Server for Act CRM on Windows Subsytem for Linux (WSL) and connect to live Act CRM from the Cline extension in Visual Studio Code.
-
Connect to Clockify Data from PowerBuilder via ADO.NET
This article demonstrates how to access Clockify from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to and Visualize Live Amazon S3 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon S3.
-
Automated Continuous Cloudant Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Cloudant replication to Apache Cassandra.
-
Configure the CData JDBC Driver for Microsoft OneDrive in a Connection Pool in Tomcat
Connect to Microsoft OneDrive from a connection pool in Tomcat.
-
Migrating data from Quickbase to Google BigQuery using CData SSIS Components.
Easily push Quickbase to Google BigQuery using the CData SSIS Tasks for Quickbase and Google BigQuery.
-
Connect to BambooHR Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for BambooHR.
-
Import CouchDB Data Using Azure Data Factory
Use CData Connect AI to connect to CouchDB Data from Azure Data Factory and import live Apache CouchDB.
-
Design BIRT Reports on Zendesk Data
Provide current Zendesk to your embedded analytics.
-
Build Dashboards with Scrapfly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Scrapfly in Dundas BI.
-
Visualize Slack 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 Slack into TIBCO Spotfire.
-
Connect to OData Services from a Connection Pool in Jetty
The OData JDBC Driver supports connection pooling: This article shows how to connect faster to OData from Web apps in Jetty.
-
Automated Continuous Wave Financial Replication to SQLite
Use CData Sync for automated, continuous, customizable Wave Financial replication to SQLite.
-
Integrate with Oracle SCM Data in JReport Designer
Create charts and reports based on Oracle SCM in JReport Designer.
-
Use Databricks Agent Bricks to Talk to Your Google Search Results via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Search for you.
-
Write a Simple Go Application to work with Oracle SCM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle SCM.
-
Choosing the Best Method to Connect Strava to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Strava from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Discord Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Discord replication to Apache Cassandra.
-
How to Work with SQL Server Data in AWS Glue Jobs Using JDBC
Connect to SQL Server from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Slack Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Slack.
-
Build Dashboards with Okta Data in DBxtra
Create dynamic dashboards and perform analytics based on Okta in DBxtra.
-
DataBind Controls to SFTP Data in Delphi
DataBind to SFTP in Delphi with standard data access components and controls.
-
Access Live Amazon Marketplace Data in Excel 365 Online (Excel for the web)
Connect to Amazon Marketplace from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Zoho Projects Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho Projects replication to SQL Server.
-
How to Work with MailerLite Data in AWS Glue Jobs Using JDBC
Connect to MailerLite from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Cursor CLI with Snowflake 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 ZendeskSell Data in NetBeans
Connect to ZendeskSell in NetBeans with the data source configuration wizard.
-
Use Databricks Agent Bricks to Talk to Your Certinia Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Certinia for you.
-
Connect to SQL Analysis Services Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SQL Analysis Services and the SQL Gateway to access SQL Analysis Services from Google Apps Script.
-
Build XML-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to XML Files and build web apps with connectivity to live XML Files.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ConstantContact
Provide connectivity to ConstantContact through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Redshift in MicroStrategy Web
Connect to Amazon Redshift in MicroStrategy Web using the CData Software ODBC Driver for Redshift.
-
Create Power BI Reports on Real-Time ChartMogul Data
Use the CData ODBC Driver for ChartMogul to visualize ChartMogul in Power BI Desktop.
-
LINQ to Attio 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 Attio Data Provider.
-
Build AI/ML Models with Live Instagram Data using Dataiku
Connect Instagram Data with Dataiku using the CData JDBC Driver for Instagram.
-
Connect to FTP Data in DBeaver
Use the CData ODBC Driver to connect to FTP Servers in DBeaver.
-
Access BambooHR Data from MySQL in Amazon QuickSight
Connect to BambooHR and build visualizations of BambooHR using a MySQL Connection in Amazon QuickSight.
-
Create Informatica Mappings From/To an ODBC Data Source for LDAP
Create an ODBC connection to LDAP in Informatica and browse and transfer LDAP.
-
Integrate Testmonitor Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Testmonitor from Informatica Cloud.
-
Connect to Databricks Data from PowerBuilder via JDBC
This article demonstrates how to access Databricks from PowerBuilder using the Databricks JDBC Driver.
-
Access Salesloft Data from MySQL in PHP
Connect to Salesloft through the standard MySQL libraries in PHP.
-
Connecting Pipedream with Odoo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Odoo data in real time.
-
Connect to Quickbase Data in CloverDX (formerly CloverETL)
Transfer Quickbase using the visual workflow in the CloverDX data integration tool.
-
Connect to Contentful Data in HULFT Integrate
Connect to Contentful as a JDBC data source in HULFT Integrate
-
Connect to Retently Data from a Connection Pool in Jetty
The Retently JDBC Driver supports connection pooling: This article shows how to connect faster to Retently from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Timely in MicroStrategy Web
Connect to Timely in MicroStrategy Web using the CData Software ODBC Driver for Timely.
-
Connect to Wrike in SpagoBI
Create reports featuring live Wrike in SpagoBI Studio. Host Wrike reports on SpagoBI Server.
-
HubSpot Reporting in OBIEE with the HubSpot JDBC Driver
Deploy the HubSpot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate MYOB AccountRight Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MYOB AccountRight from PowerShell? This article demonstrates how to utilize the MYOB AccountRight Cmdlets for tasks like connecting to MYOB AccountRight, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for HCL Domino in MicroStrategy Web
Connect to HCL Domino in MicroStrategy Web using the CData Software ODBC Driver for HCL Domino.
-
Create Reports with Avro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Avro.
-
Working with Coda Data in LINQPad
Execute LINQ queries to Coda in LINQPad.
-
Build Semantic Layer Views for CapsuleCRM Data in APOS Live Data Gateway
Use the CData Connector for CapsuleCRM in APOS Live Data Gateway to build Semantic Layer Views for CapsuleCRM.
-
LINQ to Presto 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 Presto Data Provider.
-
Automated Continuous LeadDesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LeadDesk replication to Amazon S3.
-
A PostgreSQL Interface for Sugar CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sugar CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Jira Assets Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Jira Assets replication to Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Procore
Provide connectivity to Procore through an SAP BusinessObjects universe.
-
Getting Started with the CData SSIS Components for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoInvoice.
-
How to Query Oracle Data in MySQL Workbench
Execute MySQL queries against live Oracle Database from MySQL Workbench.
-
Feed Zuora Data into FineReport
How to set Zuora as a JDBC data source in FineReport.
-
Integrating Cursor CLI with Discord 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.
-
Use the CData Software ODBC Driver for Wistia in MicroStrategy Web
Connect to Wistia in MicroStrategy Web using the CData Software ODBC Driver for Wistia.
-
Publish Reports with Figshare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Figshare.
-
Automate Zoho Books Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Books replication to Azure Data Lake.
-
Build Data Flows from Parquet to SQL Server using SSIS
Easily back up Apache Parquet to SQL Server using the SSIS components for Parquet.
-
Automated Continuous EmailOctopus Replication to SQL Server
Use CData Sync for automated, continuous, customizable EmailOctopus replication to SQL Server.
-
Use the CData ODBC Driver for Jira from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Jira to connect to Atlassian Jira from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Atlassian Jira in Excel.
-
Connect to Hive Data in HULFT Integrate
Connect to Hive as a JDBC data source in HULFT Integrate
-
How to create Teamgate federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Teamgate in MySQL .
-
Connecting GenSpark with Impala Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apache Impala without any replication or custom integration required.
-
Add Elorus Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Elorus with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Dash to Build Web Apps on Google Calendar Data via CData Connect AI
Build interactive Dash web apps on live Google Calendar using pandas and the CData Connect AI Python SDK.
-
Use the CData Software ODBC Driver for Instantly in MicroStrategy Desktop
Connect to Instantly in MicroStrategy Desktop using the CData Software ODBC Driver for Instantly.
-
Use Azure AI Foundry to Talk to Your Oracle Eloqua 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 Oracle Eloqua for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Twitter Ads
Create Twitter Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Migrating data from Pinecone to Google BigQuery using CData SSIS Components.
Easily push Pinecone to Google BigQuery using the CData SSIS Tasks for Pinecone and Google BigQuery.
-
Use the CData Software ODBC Driver for Google Analytics in MicroStrategy Desktop
Connect to Google Analytics in MicroStrategy Desktop using the CData Software ODBC Driver for Google Analytics.
-
Migrating data from Google Spanner to Google BigQuery using CData SSIS Components.
Easily push Google Spanner to Google BigQuery using the CData SSIS Tasks for Google Spanner and Google BigQuery.
-
Connect to Sage 200 Data in ACL Analytics
Connect to Sage 200 via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sage 200.
-
Omnisend Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Omnisend facts in real time.
-
Replicate Multiple Procore Accounts
Replicate multiple Procore accounts to one or many databases.