CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Unbounce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Unbounce replication to Amazon Redshift.
-
Access Live ShipStation in AWS Lambda
Connect to live ShipStation in AWS Lambda using the CData JDBC Driver.
-
Import Databricks into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Databricks. In this article, you will use the OData format to import Databricks into Microsoft Power Query.
-
Build a Singer.io Tap for Aha With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Aha data using
-
Automated Continuous Confluence Replication to Snowflake
Use CData Sync for automated, continuous, customizable Confluence replication to Snowflake.
-
Connect to Microsoft Teams in JRuby
Create a simple JRuby app with access to live Microsoft Teams.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Act-On within intelligent workflows.
-
Integrate Live SAP ByDesign into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP ByDesign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Business ByDesign.
-
Model Epicor Kinetic Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Epicor Kinetic, enabling the direct import of real-time Epicor Kinetic.
-
Automated Continuous Zoho Creator Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Azure SQL Database.
-
How to Connect the Power BI Service to Drift: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Analyze Instagram in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Instagram in Microsoft R Open.
-
How to publish and share ActiveCampaign dashboards with Tableau Server
The CData ODBC driver for ActiveCampaign enables you integrate ActiveCampaign into Tableau dashboards.
-
Build Data Flows from Certinia to SQL Server using SSIS
Easily back up Certinia to SQL Server using the SSIS components for Certinia.
-
How to integrate JSON with Apache Airflow
Access and process JSON in Apache Airflow using the CData JDBC Driver.
-
Build Data Flows from SQL Server to Azure Active Directory through SSIS
Easily push SQL Server data to Azure Active Directory using the CData SSIS Tasks for Azure Active Directory.
-
Object-Relational Mapping (ORM) with Excel 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 Microsoft Excel into a Java-based ORM framework, Hibernate.
-
Use the CData Software JDBC Driver for SharePoint in MicroStrategy Web
Connect to Microsoft SharePoint in MicroStrategy Web using the CData Software JDBC Driver for SharePoint.
-
Create Reports with Epicor Kinetic in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Epicor Kinetic.
-
Access RSS Feeds from MySQL in PHP
Connect to RSS through the standard MySQL libraries in PHP.
-
How to connect to IBM Cloud Object Storage from Spring Boot
Connect to IBM Cloud Object Storage in a Spring Boot Application using CData JDBC IBM Cloud Object Storage Driver
-
Visualize Greenplum from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pivotal GreenPlum.
-
Establish a Live Connection with Office 365 using Tableau Bridge
The CData ODBC Driver for Office 365 enables you to integrate live Microsoft Office 365 into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Snowflake using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Snowflake to a JSON file on disk.
-
Build OData-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to OData Services from Zoho Analytics and import live OData.
-
A PostgreSQL Interface for Shippo using the CData ODBC Driver
Use the SQL Gateway and Shippo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to HarperDB in the Denodo Platform
Use CData driver technologies to create a virtual data source for HarperDB in the Denodo Virtual DataPort Administrator.
-
Back Up EnterpriseDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for EnterpriseDB. In this article, we will employ an SSIS workflow to populate a database with EnterpriseDB data.
-
Connect to Twitter Ads in NetBeans
Connect to Twitter Ads in NetBeans with the data source configuration wizard.
-
Use the CData ODBC Driver for Google Contacts from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Contacts to connect to Google Contacts from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Contacts in Excel.
-
Use Biml to Build SSIS Tasks to Replicate Azure DevOps to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure DevOps to SQL Server.
-
Creating DocuSign-Connected Applications in Unqork
You can use CData Connect AI to feed DocuSign to Unqork and build custom business apps.
-
Build Microsoft Project-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Project and build Microsoft Project-connected web apps with Axios.
-
Automated Continuous Airtable Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Airtable replication to IBM DB2.
-
Connect to Oracle in HULFT Integrate
Connect to Oracle as a JDBC data source in HULFT Integrate
-
How to Connect the Power BI Service to Sage 300: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous OData Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable OData replication to Microsoft Access.
-
Build SAP Ariba Source-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Ariba Source and create custom apps in Mendix.
-
Automated Continuous Sage Cloud Accounting Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to PostgreSQL.
-
Visualize Live CSV of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CSV/TSV Files using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use ChatGPT to Talk to Your Jira Service Management via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Atlassian Jira Service Management for you.
-
Integrate Impala in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Impala from Informatica Cloud.
-
Migrating data from xBase to Snowflake using CData SSIS Components.
Easily push xBase to Snowflake using the CData SSIS Tasks for xBase and Snowflake.
-
Access Live SharePoint in Excel 365 Online (Excel for the web)
Connect to Microsoft SharePoint from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Import Real-Time Dynamics 365 via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Dynamics 365 in ColdFusion.
-
Automate SAS xpt Replication to Azure Data Lake
Use CData Sync to customize and automate SAS XPORT replication to Azure Data Lake.
-
Use the CData SSIS Components to Insert New or Update Existing JSON Records from SQL Server
Easily push SQL Server data to JSON using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into JSON or update existing records with data from a SQL Server database.
-
Analyze ActiveCampaign in Looker
Use CData Connect AI to connect to ActiveCampaign from Looker and build custom apps using live ActiveCampaign.
-
Automated Continuous Splunk Replication to SingleStore
Use CData Sync for automated, continuous, customizable Splunk replication to SingleStore.
-
How to load DB2 data into Elasticsearch via Logstash
Introducing a simple method to load DB2 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to BigQuery from IntelliJ
Integrate connectivity to Google BigQuery with wizards in IntelliJ.
-
Publish Crystal Reports on Basecamp
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Basecamp.
-
PowerShell Scripting to Replicate Microsoft Dataverse to MySQL
Write a simple PowerShell script to replicate Microsoft Dataverse (CDS) to a MySQL database.
-
Access Live Zoho CRM in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho CRM from your Excel spreadsheets.
-
Build Zoho Inventory-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Inventory.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Atlassian Confluence to Power BI dashboards. Simply drag and drop Atlassian Confluence into data visuals on the Power BI canvas.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics NAV
Provide connectivity to Microsoft Dynamics NAV through an SAP BusinessObjects universe.
-
Integrating LangGraph with Tableau CRM Analytics via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Tableau CRM Analytics within automated workflows.
-
Easily Integrate Oracle Eloqua in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Eloqua in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Real-Time Twilio Data in Power Apps Using Dataflows to Build Custom Applications
-