CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Xero Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Xero replication to Azure SQL Database.
-
Visualize Live Klipfolio in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Klipfolio.
-
Getting Started with the CData Python Connector for Jira
Learn to install and license the CData Python Connector
-
Create Data Visualizations in Cognos BI with Amazon S3
Access Amazon S3 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create a Data Access Object for IBM Informix using JDBI
A brief overview of creating a SQL Object API for IBM Informix in JDBI.
-
Create a Data Access Object for Oracle Financials Cloud using JDBI
A brief overview of creating a SQL Object API for Oracle Financials Cloud in JDBI.
-
Connect to OneNote from Asprova with CData Software ODBC Driver for OneNote
This article shows how to connect faster to OneNote data from Asprova.
-
How to load eBay data into Elasticsearch via Logstash
Introducing a simple method to load eBay data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData JDBC Driver for FTP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FTP.
-
Connect to ADP from AWS Glue
Use CData Connect AI to gain access to live ADP from your AWS Glue jobs.
-
Visualize Sybase IQ in TIBCO Spotfire through ADO.NET
Integrate Sybase IQ into dashboards in TIBCO Spotfire.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Hive to Power BI dashboards. Simply drag and drop Apache Hive into data visuals on the Power BI canvas.
-
How to Connect to Live Snowflake 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 Snowflake for you.
-
Automated Continuous Google Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Ads replication to Azure SQL Database.
-
How to Query Live Splunk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Splunk data in natural language using Python.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jira Service Management
Provide connectivity to Atlassian Jira Service Management through an SAP BusinessObjects universe.
-
Automate Xero Replication to Azure Synapse
Use CData Sync to customize and automate Xero Accounting replication to Azure Synapse.
-
Visualize Google Data Catalog in Tableau
The CData ODBC driver for Google Data Catalog enables you integrate Google Data Catalog into Tableau dashboards.
-
Build Trello-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Trello from Zoho Analytics and import live Trello.
-
How to connect to Office 365 in DBVisualizer
Integrate Microsoft Office 365 with visual data analysis tools and data connection wizards in DBVisualizer
-
Import Google Directory into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Directory. In this article, you will use the OData format to import Google Directory into Microsoft Power Query.
-
Query Vault CRM in DataGrip
Create a Data Source for Vault CRM in DataGrip and use SQL to query live Veeva Vault & Vault CRM.
-
Migrating data from Todoist to Snowflake using CData SSIS Components.
Easily push Todoist to Snowflake using the CData SSIS Tasks for Todoist and Snowflake.
-
Import GitHub Using Azure Data Factory
Use CData Connect AI to connect to GitHub from Azure Data Factory and import live GitHub.
-
Getting Started with the CData JDBC Driver for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Reckon Accounts Hosted.
-
Use the CData ODBC Driver for Eventbrite in Microsoft Power Query
You can use the CData Eventbrite ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Eventbrite into Microsoft Power Query.
-
How to pipe EnterpriseDB to CSV in PowerShell
Use standard PowerShell cmdlets to access EnterpriseDB tables.
-
Load SAP HANA to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP HANA to a database.
-
Build Charts with Salesforce Marketing in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce Marketing Cloud in Clear Analytics.
-
Access Live PostgreSQL in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PostgreSQL from your Excel spreadsheets.
-
Viewing Sugar CRM in RAD Studio Data Explorer
How to view Sugar CRM in RAD Studio Data Explorer using the CData ODBC Driver for Sugar CRM.
-
Build Microsoft Planner-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Planner.
-
Automated Continuous Sage Cloud Accounting Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to SQL Server.
-
Access Live SAP Concur in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Concur from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Live Dynamics 365 Business Central in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Dynamics 365 Business Central into custom reports in Power BI.
-
Automate SAP Concur Replication to Azure Synapse
Use CData Sync to customize and automate SAP Concur replication to Azure Synapse.
-
Replicate Multiple Airtable Accounts
Replicate multiple Airtable accounts to one or many databases.
-
Build MVC Applications with Connectivity to Salesloft
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesloft from an ASP.NET MVC application.
-
How to Connect to Live GitHub 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 GitHub through natural language.
-
Connect Certinia to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Certinia using the CData Python MCP Server.
-
How to Connect to Live BigCommerce in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your BigCommerce for you.
-
Use the CData Software JDBC Driver for WordPress in MicroStrategy Desktop
Connect to WordPress in MicroStrategy Desktop using the CData Software JDBC Driver for WordPress.
-
Getting Started with the CData ODBC Driver for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Raisers Edge NXT.
-
Connect to Live LinkedIn Ads in PostGresSQL Interface through CData Connect AI
Create a live connection to LinkedIn Ads in CData Connect AI and connect to your LinkedIn Ads from PostgreSQL.
-
Access Live SAP SuccessFactors LMS in AWS Lambda
Connect to live SAP SuccessFactors LMS in AWS Lambda using the CData JDBC Driver.
-
Import Impala into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Impala. In this article, you will use the OData format to import Apache Impala into Microsoft Power Query.
-
Connect to Azure DevOps in NetBeans
Connect to Azure DevOps in NetBeans with the data source configuration wizard.
-
How to create Todoist federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Todoist in MySQL .
-
Automate Drip Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Drip and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Provide OData Services of Zoho CRM from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho CRM by developing a WCF Service Application.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Integrate Neo4J in the Pentaho Report Designer
Publish reports based on Neo4J in the Pentaho BI tool.
-
Use the CData ODBC Driver for Azure Synapse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Synapse to connect to Azure Synapse from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Synapse in Excel.
-
Automated Continuous LinkedIn Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LinkedIn replication to Google BigQuery.
-
Natively Connect to GraphQL in PHP
The CData ODBC driver for GraphQL enables you to create PHP applications with connectivity to GraphQL. Leverage the native support for ODBC in PHP.
-
Natively Connect to eBay Analytics in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to eBay Analytics. Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To an ODBC Data Source for SuiteCRM
Create an ODBC connection to SuiteCRM in Informatica and browse and transfer SuiteCRM.
-
DataBind Controls to Adobe Analytics in C++Builder
DataBind to Adobe Analytics in C++Builder with standard components and controls.
-
Getting Started with the CData ODBC Driver for Calendly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Calendly.
-
How to Access Live Exact Online in Power Automate Desktop via ODBC
The CData ODBC Driver for Exact Online enables you to integrate Exact Online into workflows built using Microsoft Power Automate Desktop.
-
ETL Dynamics 365 Business Central in Oracle Data Integrator
This article shows how to transfer Dynamics 365 Business Central into a data warehouse using Oracle Data Integrator.
-
How to Work with HDFS in ETL Validator JDBC
Connect to HDFS from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Microsoft Dataverse-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Dataverse from Choreo and build custom apps using live Microsoft Dataverse (CDS).
-
Connect to Real-Time Sage 200 Data in Power Apps Using Dataflows to Build Custom Applications
-