Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →CData Software - Knowledge Base
Recent Articles
-
Build Couchbase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Couchbase.
-
Access Live Bullhorn CRM in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Bullhorn CRM to create a Bullhorn CRM source in TIBCO Data Virtualization Studio and gain access to live Bullhorn CRM from your TDV Server.
-
Automate Odoo Replication to Couchbase
Use CData Sync to Customize and automate Odoo ERP replication to Couchbase.
-
Visualize Teradata in TIBCO Spotfire through OData
Integrate Teradata into dashboards in TIBCO Spotfire.
-
Create OData-Connected Nintex Workflows
Use CData Connect Cloud to connect to OData Services from Nintex Workflow Cloud and build custom workflows using live OData.
-
Build Excel-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for Microsoft Excel and build visualizations and dashbaords from Microsoft Excel in Redash.
-
Build a Simple VCL Application for SharePoint Excel Services
How to build a simple VCL Application to view SharePoint Excel Services in RAD Studio using the CData ODBC Driver for SharePoint Excel Services.
-
How to Connect DBeaver to LDAP via a JDBC Driver
Manage LDAP with visual tools in DBeaver like the query browser.
-
How to Use CData Connect to Access Live EventBrite in Power Automate
CData Connect for EventBrite enables you to integrate Eventbrite into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Bing Ads in C++Builder
DataBind to Bing Ads in C++Builder with standard components and controls.
-
Visualize Google Campaign Manager 360 in Sisense
Create an ElastiCube in Sisense app with access to Google Campaign Manager 360.
-
Integrate with eBay in SnapLogic
Use CData Connect Cloud to connect to and integrate with live eBay in SnapLogic.
-
How to connect to Greenhouse with Squirrel SQL client
Connect to Greenhouse and execute queries in the Squirrel SQL Client.
-
Access Live Elasticsearch in Excel 365 Online (Excel for the web)
Connect to Elasticsearch from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
How to connect and process Kintone from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Kintone
-
DataBind Controls to SuiteCRM in Delphi
DataBind to SuiteCRM in Delphi with standard data access components and controls.
-
Automated Continuous Power BI XMLA Replication to Azure SQL
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Azure SQL.
-
Feed SingleStore into FineReport
How to set SingleStore as a JDBC data source in FineReport.
-
Build Wave Financial Visualizations in Tableau Cloud
Use CData Software Connect Server to create a virtual SQL Server Database for Wave Financial and build visualizations in Tableau Cloud.
-
How to create Klaviyo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Klaviyo in MySQL .
-
Connect to GraphQL in Ruby
Connect to GraphQL in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Reports with Adobe Commerce in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Commerce.
-
Add SAP Hybris C4C to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Hybris C4C with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Amazon DynamoDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to MongoDB.
-
Automated Continuous Shippo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Shippo replication to delimited files (CSV/TSV).
-
How to connect PolyBase to Microsoft Teams
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Teams.
-
How to Connect to & Open Parquet in Microsoft Excel
This article uses the CData ODBC driver for Parquet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Pinterest in SAP Analytics Cloud
Use the CData Connect Server to create an OData API on top of Pinterest and visualize Pinterest in SAP Analytics Cloud.
-
Connect to Microsoft Dataverse in SpagoBI
Create reports featuring live Microsoft Dataverse (CDS) in SpagoBI Studio. Host Microsoft Dataverse reports on SpagoBI Server.
-
Feed Redis into FineReport
How to set Redis as a JDBC data source in FineReport.
-
Integrate Monday.com with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Monday.com with External Services.
-
Replicate Pinterest for Use in Salesforce Connect
Replicate Pinterest to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Load Snowflake to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Snowflake to a database.
-
Connect to ClickUp in as an External Source in Dremio
Use the CData JDBC Driver to connect to ClickUp as an External Source in Dremio.
-
Create Informatica Mappings From/To an ODBC Data Source for Pipedrive
Create an ODBC connection to Pipedrive in Informatica and browse and transfer Pipedrive.
-
Use the CData Software ODBC Driver for Jira Service Management in MicroStrategy Desktop
Connect to Atlassian Jira Service Management in MicroStrategy Desktop using the CData Software ODBC Driver for Jira Service Management.
-
Use the CData SSIS Components to Insert New or Update Existing Marketo Records from SQL Server
Easily push SQL Server data to Marketo using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Marketo or update existing records with data from a SQL Server database.
-
Design BIRT Reports on Phoenix
Provide current Apache Phoenix to your embedded analytics.
-
Automated Continuous Oracle Service Cloud Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to PostgreSQL.
-
Access Live SAS xpt in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for SAS xpt to create a SAS XPORT source in TIBCO Data Virtualization Studio and gain access to live SAS XPORT from your TDV Server.
-
How to integrate Metabase with Redshift
Use CData Connect Cloud to connect to live Amazon Redshift and create an interactive dashboard in Metabase from Amazon Redshift.
-
Add Gmail to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Gmail with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Azure Synapse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Apache Kafka.
-
Automated Continuous LinkedIn Ads Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Apache Cassandra.
-
Integrate with Adobe Analytics in JReport Designer
Create charts and reports based on Adobe Analytics in JReport Designer.
-
Use the CData ODBC Driver for Amazon S3 in Microsoft Power Query
You can use the CData Amazon S3 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon S3 into Microsoft Power Query.
-
Connect to Xero in Google Apps Script
Use the ODBC Driver for Xero and the SQL Gateway to access Xero Accounting from Google Apps Script.
-
Build SAP ByDesign-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Business ByDesign.
-
Use CData Connect Cloud to Access Microsoft Dataverse in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Microsoft Dataverse (CDS) in the Power Pivot business intelligence tool.
-
Connect to Todoist from PowerBuilder
This article demonstrates how to access Todoist from Appeon PowerBuilder using the CData ADO.NET Provider for Todoist.
-
Use the CData Software JDBC Driver for Veeva in MicroStrategy
Connect to Veeva Vault in MicroStrategy Developer using the CData Software JDBC Driver for Veeva.
-
Access Live YouTube Analytics in Google Sheets
Use CData Connect Cloud to gain access to live YouTube Analytics from your Google Sheets.
-
Visualize QuickBooks from Tableau
Use the Tableau Desktop business intelligence tool to connect to QuickBooks Desktop.
-
Model Marketo Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Marketo, enabling the direct import of real-time Marketo.
-
Query, Visualize, and Share live Xero in Redash
Use CData Connect Cloud to connect to live Xero Accounting in Redash for querying, visualizing, and sharing.
-
How to Connect to & Open HBase in Microsoft Excel
This article uses the CData ODBC driver for HBase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Bing Search Results from a Connection Pool in JBoss
Integrate Bing Search into Java servlets: Use the Management Console in JBoss to install the Bing Search JDBC Driver.
-
Write a Simple Go Application to work with Clio on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Clio.
-
Analyze Marketo in Looker
Use CData Connect Cloud to connect to Marketo from Looker and build custom apps using live Marketo.
-
Automated Continuous QuickBooks Replication to MySQL
Use CData Sync for automated, continuous, customizable QuickBooks replication to MySQL.
-
Automated Continuous Dynamics 365 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Google BigQuery.
-
Use the CData Software JDBC Driver for MySQL in MicroStrategy
Connect to MySQL in MicroStrategy Developer using the CData Software JDBC Driver for MySQL.
-
How to Connect to & Open LinkedIn Ads in Microsoft Excel
This article uses the CData ODBC driver for LinkedIn Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Monday.com-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Monday.com and create custom apps in Mendix.
-
Access Live Invoiced in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Invoiced to create a Invoiced source in TIBCO Data Virtualization Studio and gain access to live Invoiced from your TDV Server.
-
Automated Continuous WordPress Replication to SingleStore
Use CData Sync for automated, continuous, customizable WordPress replication to SingleStore.
-
DataBind Controls to ServiceNow in Delphi
DataBind to ServiceNow in Delphi with standard data access components and controls.
-
Visualize Instagram from Tableau
Use the Tableau Desktop business intelligence tool to connect to Instagram.
-
DataBind Controls to Google Spanner in C++Builder
DataBind to Google Spanner in C++Builder with standard components and controls.
-
Connect to eBay from a Connection Pool in WebLogic
Use the CData JDBC Driver for eBay to connect to eBay from Web applications running on WebLogic.
-
Integrate Google Spanner into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Google Spanner and integrate live Google Spanner into your Power Automate tasks.
-
Build Semantic Layer Views for Slack in APOS Live Data Gateway
Use the CData Connector for Slack in APOS Live Data Gateway to build Semantic Layer Views for Slack.
-
Create Dynamic Azure DevOps Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure DevOps to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Impala in Sisense
Create an ElastiCube in Sisense app with access to Apache Impala.
-
Analyze TigerGraph with Power Pivot
This article walks you through the process of using the CData ODBC Driver for TigerGraph from Power Pivot. You will use the Table Import Wizard to load TigerGraph. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Cassandra as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Apache Cassandra.
-
Extract, Transform, and Load Twitter in Informatica PowerCenter
Create a simple Workflow for Twitter in Informatica PowerCenter.
-
Connect to Live SAP HANA in MicroStrategy through CData Connect Cloud
Create a live connection to SAP HANA in CData Connect Cloud and connect to your SAP HANA from MicroStrategy.
-
Monday.com Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Monday.com through CData Connect Cloud using different applications and tools.
-
Import CSV into the Power BI Service for Visualizations
Use CData Software Connect Server to create an OData feed for CSV and create custom reports in the Power BI Service.
-
Access Amazon S3 as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon S3 from your Oracle system.
-
Publish Reports with SAP Ariba Procurement in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Procurement.
-
Build an OLAP Cube in SSAS from Klipfolio
Establish a connection to Klipfolio data from SQL Server Analysis Services, and use the Klipfolio Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Pinterest in Google Apps Script
Use the ODBC Driver for Pinterest and the SQL Gateway to access Pinterest from Google Apps Script.
-
How to Access Excel Online Using Entity Framework
This article shows how to access Microsoft Excel Online using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Choosing the Best Method to Connect Sage 200 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage 200 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Natively Connect to Twitter Ads in PHP
The CData ODBC driver for Twitter Ads enables you to create PHP applications with connectivity to Twitter Ads. Leverage the native support for ODBC in PHP.
-
Operational Reporting on Avalara AvaTax from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Avalara AvaTax.
-
How to load SFTP data into Elasticsearch via Logstash
Introducing a simple method to load SFTP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Work with Dynamics 365 Business Central in AWS Glue Jobs Using JDBC
Connect to Dynamics 365 Business Central from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate Multiple AlloyDB Accounts
Replicate multiple AlloyDB accounts to one or many databases.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live Bing Search Results in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Bing Search into custom reports in Power BI.
-
Access Live Adobe Analytics in Google Sheets
Use CData Connect Cloud to gain access to live Adobe Analytics from your Google Sheets.
-
Automated Continuous SharePoint Excel Services Replication to Oracle
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Oracle.
-
Integrate Real-Time Access to QuickBooks in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to QuickBooks Desktop in real time.
-
Automated Continuous Oracle Service Cloud Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Microsoft Access.
-
Visualize Unbounce in TIBCO Spotfire through OData
Integrate Unbounce into dashboards in TIBCO Spotfire.
-
Build Semantic Layer Views for Odoo in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Odoo ERP.