Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Automated Continuous QuickBooks Online Replication to Amazon S3

Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Amazon S3.
Use the CData Software JDBC Driver for Sybase IQ in MicroStrategy Desktop

Connect to Sybase IQ in MicroStrategy Desktop using the CData Software JDBC Driver for Sybase IQ.
Connect to Office 365 from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Office 365, and over 250 other data sources, right inside your Excel and Google spreadsheets!
How to Work with Azure Table in AWS Glue Jobs Using JDBC

Connect to Azure Table from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
How to connect to Klipfolio with Squirrel SQL client

Connect to Klipfolio and execute queries in the Squirrel SQL Client.
Build Impala-Connected Apps in Choreo

Use CData Connect AI to connect to Impala from Choreo and build custom apps using live Apache Impala.
Use the CData SSIS Components to Insert New or Update Existing Klaviyo Records from SQL Server

Easily push SQL Server data to Klaviyo using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Klaviyo or update existing records with data from a SQL Server database.
Automated Highrise Replication to Teradata

Use CData Sync to Customize and automate Highrise CRM replication to Teradata.
Analyze Salesloft in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze Salesloft in Microsoft R Open.
Replicate SAP Business One to Multiple Databases via the CData Sync CLI

Replicate SAP Business One to disparate databases with a single configuration.
DataBind Charts to SAP HANA XS Advanced

Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP HANA XS Advanced 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.
ETL Raisers Edge NXT in Oracle Data Integrator

This article shows how to transfer Raisers Edge NXT into a data warehouse using Oracle Data Integrator.
Use JayDeBeApi to access Reckon in Python

Use standard Python scripting and the development environment of your choice to access live Reckon.
Automated Google Search Results Replication to Teradata

Use CData Sync to Customize and automate Google Search replication to Teradata.
How to Visualize QuickBooks Time Data in Python with pandas

Use pandas and other modules to analyze and visualize live QuickBooks Time in Python.
Create Instagram-Connected Enterprise Applications in OutSystems

Use CData Connect AI to connect to Instagram from OutSystems and build custom enterprise apps using live Instagram.
Query Calendly in DataGrip

Create a Data Source for Calendly in DataGrip and use SQL to query live Calendly.
Connect FTP to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live FTP Servers using the CData Python MCP Server.
How to Visualize Basecamp Data in Python with pandas

Use pandas and other modules to analyze and visualize live Basecamp in Python.
How to Seamlessly Import SAP Business One Data into IBM SPSS Modeler

Integrate SAP Business One data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
Automated Continuous Blackbaud FE NXT Replication to SingleStore

Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to SingleStore.
Import Email into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Email. In this article, you will use the OData format to import Email into Microsoft Power Query.
Perform Batch Operations with Greenplum in Apache NiFi

Connect to Pivotal GreenPlum and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
Automated Continuous SAP Concur Replication to Amazon S3

Use CData Sync for automated, continuous, customizable SAP Concur replication to Amazon S3.
How to Query Live SAP SuccessFactors in Claude Desktop

Connect to and query live SAP SuccessFactors in Claude Desktop using the CData MCP Server.
Visualize Live FTP of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live FTP Servers using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
Build Automated Zoho Inventory-Connected Workflows in Zapier

Use CData Connect AI to connect to live Zoho Inventory and build automated workflows in Zapier.
Connect to Salesforce Pardot from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Salesforce Pardot, and over 250 other data sources, right inside your Excel and Google spreadsheets!
Integrate Coinbase in Pentaho Data Integration

Build ETL pipelines based on Coinbase in the Pentaho Data Integration tool.
How to connect to ADP in DBVisualizer

Integrate ADP with visual data analysis tools and data connection wizards in DBVisualizer
Import Real-Time Oracle SCM via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Oracle SCM in ColdFusion.
Connect to Slack in Google Apps Script via SQL Gateway

Use the ODBC Driver for Slack and the SQL Gateway to access Slack from Google Apps Script.
Use the CData ODBC Driver for EventBrite from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for EventBrite to connect to Eventbrite from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Eventbrite in Excel.
How to connect to Power BI XMLA from IntelliJ

Integrate connectivity to Power BI XMLA with wizards in IntelliJ.
Automated Continuous Active Directory Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Active Directory replication to Amazon S3.
Import Tableau CRM Analytics into the Power BI Service for Visualizations

Use CData Connect AI to connect to Tableau CRM Analytics and provide access to live Tableau CRM Analytics for custom reports in the Power BI Service.
Bridge MarkLogic Connectivity with Apache NiFi

Access and process MarkLogic in Apache NiFi using the CData JDBC Driver.
Integrate Excel Online in Pentaho Data Integration

Build ETL pipelines based on Microsoft Excel Online in the Pentaho Data Integration tool.
Extend Google Sheets with Sage 300

Make calls to the API Server from Google Apps Script.
Create Dashboards and Visualize Live API in Geckoboard

Use CData Connect AI to connect to live API and create dashboards for real-time monitoring and visualization in Geckoboard.
How to connect PolyBase to Twitter Ads

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Twitter Ads.
Automated Continuous Stripe Replication to Databricks

Use CData Sync for automated, continuous, customizable Stripe replication to Databricks.
Access Live Trello in Coginiti Pro

Connect to and query live Trello from the GUI in the Coginiti Pro: SQL Analytics Tool.
How to connect to HBase from Spring Boot

Connect to HBase in a Spring Boot Application using CData JDBC HBase Driver
Publish Crystal Reports on Sage 300

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage 300.
Build Semantic Layer Views for Zoho Inventory in APOS Live Data Gateway

Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho Inventory.
How to connect to Dynamics 365 with Squirrel SQL client

Connect to Microsoft Dynamics 365 and execute queries in the Squirrel SQL Client.
Connect to Amazon DynamoDB in ACL Analytics

Connect to Amazon DynamoDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon DynamoDB.
Automate Google Contacts Replication to SAP HANA

Use CData Sync to customize and automate Google Contacts replication to SAP HANA.
Build AI/ML Models with Live Shopify Data using Dataiku