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

CData Software - Knowledge Base

Recent Articles

Replicate Quickbase to Multiple Databases

Replicate Quickbase to disparate databases with a point-and-click configuration.
Create Reports with PayPal in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date PayPal.
How to create Zoho Books federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Books in MySQL .
Automated Continuous YouTube Analytics Replication to Amazon S3

Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Amazon S3.
Create Dynamic Tableau CRM Analytics Grids Using the Infragistics XamDataGrid

Learn how you can connect Tableau CRM Analytics to Infragistics XamDataGrid to build dynamic grids.
Validate GraphQL with QuerySurge

Access and validate GraphQL in QuerySurge using the CData JDBC Driver.
Import Real-Time ServiceNow via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use ServiceNow in ColdFusion.
Build SurveyMonkey-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to SurveyMonkey from Zoho Analytics and import live SurveyMonkey.
Automated Redshift Replication to Teradata

Use CData Sync to Customize and automate Amazon Redshift replication to Teradata.
Databind Charts to Salesforce Data

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce data 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.
Build MariaDB Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live MariaDB and build visualizations in Tableau Cloud.
PowerShell Scripting to Replicate Acumatica to MySQL

Write a simple PowerShell script to replicate Acumatica ERP to a MySQL database.
Integrate Act-On in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Act-On from Informatica Cloud.
Automated Continuous Procore Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Procore replication to Azure SQL.
How to Work with Teradata in AWS Glue Jobs Using JDBC

Connect to Teradata from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Automated Continuous YouTube Analytics Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable YouTube Analytics replication to PostgreSQL.
Publish Reports with HubDB in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date HubDB.
How to update QuickBooks Online from Excel

This article explains how to transfer data from Excel to QuickBooks Online using the Excel Add-In for QuickBooks Online.
Create Data Visualizations in Cognos BI with Hive

Access Apache Hive as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
Create Dashboards and Visualize Live Odoo in Geckoboard

Use CData Connect Cloud to connect to live Odoo ERP and create dashboards for real-time monitoring and visualization in Geckoboard.
How to Work with Oracle Eloqua in AWS Glue Jobs Using JDBC

Connect to Oracle Eloqua from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Access Dropbox from MySQL in PHP

Connect to Dropbox through the standard MySQL libraries in PHP.
Create LinkedIn Ads-Connected Applications in Appsmith

Connect to LinkedIn Ads via CData Connect Cloud in Appsmith and create custom business applications with real-time access to LinkedIn Ads.
Import Real-Time Amazon Athena via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Amazon Athena in ColdFusion.
Build Interactive Dashboards from IBM Cloud Object Storage in Amazon QuickSight

Create a virtual SQL Server database for IBM Cloud Object Storage in CData Software Connect Server and import IBM Cloud Object Storage into Amazon QuickSight SPICE to build interactive dashboards.
Analyze Oracle HCM Cloud in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Oracle HCM Cloud and visualize Oracle HCM Cloud in SAP Analytics Cloud.
Explore Geographical Relationships in Facebook with Power Map

Create data visualizations with Facebook in Power Map.
Import FTP into FileMaker Pro

Create reports that integrate FTP Servers in Filemaker Pro.
Connect to Jira Service Management in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Atlassian Jira Service Management in Airbyte.
Create Informatica Mappings From/To a JDBC Data Source for SAP

Create SAP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
Bidirectional Access to Paylocity from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Paylocity in Filemaker Pro for Mac or Windows.
Connect to MongoDB from Asprova with CData Software ODBC Driver for MongoDB

This article shows how to connect faster to MongoDB data from Asprova.
Query Sugar CRM in DataGrip

Create a Data Source for Sugar CRM in DataGrip and use SQL to query live Sugar CRM.
How to create an RPA flow for Dynamics CRM in UiPath Studio

Use the Dynamics CRM ODBC Driver to create workflows that access real-time Microsoft Dynamics CRM without any coding.
Replicate Salesforce Marketing to Multiple Databases

Replicate Salesforce Marketing Cloud to disparate databases with a point-and-click configuration.
Connect to Azure Synapse in SpagoBI

Create reports featuring live Azure Synapse in SpagoBI Studio. Host Azure Synapse reports on SpagoBI Server.
Connect to Tableau CRM Analytics in CloverDX (formerly CloverETL)

Transfer Tableau CRM Analytics using the visual workflow in the CloverDX data integration tool.
Integrate with CSV using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CSV/TSV Files to a JSON file on disk.
Import Smaregi Using Azure Data Factory

Use CData Connect Cloud to connect to Smaregi from Azure Data Factory and import live Smaregi.
Integrate Live SAP Hybris C4C into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to SAP Hybris C4C and integrate live SAP Hybris C4C into apps built in Microsoft Power Apps.
How to import Microsoft Project into Apache Solr

Use the CData Software JDBC Driver for Microsoft Project in Data Import Handler and create an automated import of Microsoft Project to Apache Solr Enterprise Search platform.
Automated Continuous GitHub Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable GitHub replication to Apache Cassandra.
Connect to Todoist in HULFT Integrate

Connect to Todoist as a JDBC data source in HULFT Integrate
Use the CData SSIS Components to Insert New or Update Existing Cloudant Records from SQL Server

Easily push SQL Server data to Cloudant using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cloudant or update existing records with data from a SQL Server database.
Analyze Bullhorn CRM in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze Bullhorn CRM in Microsoft R Open.
Design BIRT Reports on Dynamics CRM

Provide current Microsoft Dynamics CRM to your embedded analytics.
Creating Avalara AvaTax-Connected Applications in Unqork

You can use CData Connect Cloud to feed Avalara AvaTax to Unqork and build custom business apps.
Connect to Greenhouse in HULFT Integrate

Connect to Greenhouse as a JDBC data source in HULFT Integrate
Build MySQL-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MySQL.
Import Real-Time CouchDB via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Apache CouchDB in ColdFusion.
xBase Reporting in OBIEE with the xBase JDBC Driver

Deploy the xBase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
Use the CData Software ODBC Driver for MailChimp in MicroStrategy Web

Connect to MailChimp in MicroStrategy Web using the CData Software ODBC Driver for MailChimp.
How to Work with Todoist in AWS Glue Jobs Using JDBC

Connect to Todoist from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Acumatica Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Acumatica ERP through CData Connect Cloud using different applications and tools.
How to connect PolyBase to Sybase

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sybase.
How to import Salesforce Pardot into Apache Solr

Use the CData Software JDBC Driver for Salesforce Pardot in Data Import Handler and create an automated import of Salesforce Pardot to Apache Solr Enterprise Search platform.
How to Connect the Power BI Service to Sybase IQ: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
Integrate Bitbucket in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Bitbucket from Informatica Cloud.
Import Real-Time SAP via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use SAP ERP/NetWeaver in ColdFusion.
Write a Simple Go Application to work with Sybase IQ on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sybase IQ.
Extract, Transform, and Load SAS xpt in Informatica PowerCenter

Create a simple Workflow for SAS XPORT in Informatica PowerCenter.
PowerShell Scripting to Replicate Pinterest to MySQL

Write a simple PowerShell script to replicate Pinterest to a MySQL database.
Import MySQL into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to MySQL and provide access to live MySQL for custom reports in the Power BI Service.
Use the CData Software ODBC Driver for Excel in MicroStrategy Web

Connect to Microsoft Excel in MicroStrategy Web using the CData Software ODBC Driver for Excel.
Choosing the Best Method to Connect SQL Server to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Microsoft SQL Server from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
Visualize Pipedrive in Sisense

Create an ElastiCube in Sisense app with access to Pipedrive.
Use Dash to Build to Web Apps on Oracle Sales

Create Python applications that use pandas and Dash to build Oracle Sales-connected web apps.
Connect to Cosmos DB in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Azure Cosmos DB in Airbyte.
How to work with LinkedIn Ads in Apache Spark using SQL

Access and process LinkedIn Ads in Apache Spark using the CData Software JDBC Driver.
Automated Continuous Google Spanner Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Google Spanner replication to Google Cloud SQL.
Excel Spreadsheet Automation on Blackbaud FE NXT with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Use the CData Software JDBC Driver for Dynamics CRM in MicroStrategy Web

Connect to Microsoft Dynamics CRM in MicroStrategy Web using the CData Software JDBC Driver for Dynamics CRM.
Prepare, Blend, and Analyze Dropbox in Alteryx Designer (ODBC)

Build workflows to access live Dropbox for self-service data analytics.
Integrate AlloyDB into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Google AlloyDB and integrate live Google AlloyDB into your Power Automate tasks.
Bridge OData Connectivity with Apache NiFi

Access and process OData in Apache NiFi using the CData JDBC Driver.
Use Biml to Build SSIS Tasks to Replicate Highrise to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Highrise CRM to SQL Server.
Load Zuora to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zuora to a database.
How to work with Tableau CRM Analytics in Apache Spark using SQL

Access and process Tableau CRM Analytics in Apache Spark using the CData Software JDBC Driver.
Connect to Reckon Accounts Hosted from Crystal Reports

Use CData Connect Cloud to connect to and report on live Reckon Accounts Hosted from Crystal Reports.
Viewing SAP ByDesign in RAD Studio Data Explorer

How to view SAP Business ByDesign in RAD Studio Data Explorer using the CData ODBC Driver for SAP ByDesign.
How to pipe QuickBooks Online to CSV in PowerShell

Use standard PowerShell cmdlets to access QuickBooks Online tables.
Access Google Search Results in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Search.
How to Work with LDAP Objects in ETL Validator JDBC

Connect to LDAP from ETL Validator jobs using the CData Software JDBC Driver.
How to Query Live Bing Search Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Bing Search data in natural language using Python.
Build Charts with SingleStore in Clear Analytics

Create dynamic charts and perform analytics based on SingleStore in Clear Analytics.
Analyze PayPal in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze PayPal in Microsoft R Open.
Prepare, Blend, and Analyze Email in Alteryx Designer (ODBC)

Build workflows to access live Email for self-service data analytics.
Automated Shippo Replication to Teradata

Use CData Sync to Customize and automate Shippo replication to Teradata.
Operational Reporting on SAP ByDesign from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business ByDesign.
How to create Reckon federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Reckon in MySQL .
Access Live Redshift in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live Amazon Redshift from your Excel spreadsheets.
Use the CData Software JDBC Driver for Outreach.io in MicroStrategy

Connect to Outreach.io in MicroStrategy Developer using the CData Software JDBC Driver for Outreach.io.
Integrate HBase in the Pentaho Report Designer

Publish reports based on Apache HBase in the Pentaho BI tool.
Feed Azure Table into FineReport

How to set Azure Table Storage as a JDBC data source in FineReport.
Publish Smartsheet-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Smartsheet.
Connect to Splunk in CloverDX (formerly CloverETL)

Transfer Splunk using the visual workflow in the CloverDX data integration tool.
Use Biml to Build SSIS Tasks to Replicate Excel Online to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Excel Online to SQL Server.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ConstantContact

Provide connectivity to ConstantContact through an SAP BusinessObjects universe.
Build Square-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Square.
How to Visualize MailChimp Data in Python with pandas

Use pandas and other modules to analyze and visualize live MailChimp in Python.