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
-
Import Microsoft OneDrive into Microsoft Power Query
The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft OneDrive. In this article, you will use the OData format to import Microsoft OneDrive into Microsoft Power Query.
-
Build Automated Workflows with Live WooCommerce in Workato
Use CData Connect Cloud to connect to live WooCommerce and build automated workflows in Workato.
-
Analyze Gmail in R
Use standard R functions and the development environment of your choice to analyze Gmail with the CData JDBC Driver for Gmail.
-
Use JayDeBeApi to access Odoo in Python
Use standard Python scripting and the development environment of your choice to access live Odoo ERP.
-
Use Dash to Build to Web Apps on Stripe
Create Python applications that use pandas and Dash to build Stripe-connected web apps.
-
Build Automated MYOB AccountRight-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live MYOB AccountRight and build automated workflows in Zapier.
-
DataBind Wijmo Grid to DocuSign
Provide real-time DocuSign to interactive controls.
-
Automated Continuous Freshdesk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Freshdesk replication to delimited files (CSV/TSV).
-
Author and Share Power BI Reports on Real-Time SurveyMonkey
Use the CData ODBC Driver for SurveyMonkey to visualize SurveyMonkey in Power BI Desktop and then upload to the Power BI service.
-
Create Reports from SAP SuccessFactors in Looker Studio
Use CData Connect Cloud to gain access to live SAP SuccessFactors and create custom reports in Looker Studio.
-
Build an OLAP Cube in SSAS from Shippo
Establish a connection to Shippo data from SQL Server Analysis Services, and use the Shippo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Slack in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Slack and visualize Slack in SAP Analytics Cloud.
-
How to Connect DBeaver to Google Campaign Manager 360 via a JDBC Driver
Manage Google Campaign Manager 360 with visual tools in DBeaver like the query browser.
-
How to Work with EnterpriseDB in ETL Validator JDBC
Connect to EnterpriseDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Stream Power BI XMLA into Apache Kafka Topics
Access and stream Power BI XMLA in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate SharePoint Excel Services in the Pentaho Report Designer
Publish reports based on SharePoint Excel Services in the Pentaho BI tool.
-
Automated Continuous RSS Replication to Amazon S3
Use CData Sync for automated, continuous, customizable RSS replication to Amazon S3.
-
How to pipe Authorize.Net to CSV in PowerShell
Use standard PowerShell cmdlets to access Authorize.Net tables.
-
Access Jira Service Management from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Atlassian Jira Service Management from HeidiSQL.
-
Visualize Google Data Catalog from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Data Catalog.
-
Write a Simple Go Application to work with Azure Active Directory on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Active Directory.
-
DataBind Controls to Zoho Creator in C++Builder
DataBind to Zoho Creator in C++Builder with standard components and controls.
-
Access Live Microsoft Exchange in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Exchange in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Planner Records from SQL Server
Easily push SQL Server data to Microsoft Planner using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Planner or update existing records with data from a SQL Server database.
-
A PostgreSQL Interface for Cosmos DB
Use the SQL Gateway and Cosmos DB ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect the Power BI Service to Elasticsearch: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Access Live Microsoft Project in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Microsoft Project to create a Microsoft Project source in TIBCO Data Virtualization Studio and gain access to live Microsoft Project from your TDV Server.
-
Publish Reports with Twilio in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twilio.
-
Configure the CData JDBC Driver for Printful in a Connection Pool in Tomcat
Connect to Printful from a connection pool in Tomcat.
-
Connect to Google Search Results in Aqua Data Studio
Access Google Search from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate GraphQL Replication to Azure Synapse
Use CData Sync to customize and automate GraphQL replication to Azure Synapse.
-
ETL Dynamics CRM in Oracle Data Integrator
This article shows how to transfer Microsoft Dynamics CRM into a data warehouse using Oracle Data Integrator.
-
How to connect to Impala from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Impala and work with Apache Impala in Microsoft Excel on Mac OS X.
-
Build ActiveCampaign-Connected Apps in Choreo
Use CData Connect Cloud to connect to ActiveCampaign from Choreo and build custom apps using live ActiveCampaign.
-
Use the CData Software ODBC Driver for HubSpot in MicroStrategy Desktop
Connect to HubSpot in MicroStrategy Desktop using the CData Software ODBC Driver for HubSpot.
-
Build Dashboards with Email in Dundas BI
Create dynamic dashboards and perform analytics based on Email in Dundas BI.
-
Work with Live Amazon Athena in Power Query
Use CData Connect Cloud to connect to Amazon Athena and work with live Amazon Athena in Microsoft Power Query.
-
Build Semantic Layer Views for Greenplum in APOS Live Data Gateway
Use the CData Connector for Greenplum in APOS Live Data Gateway to build Semantic Layer Views for Pivotal GreenPlum.
-
Connect to and Query MySQL in QlikView over ODBC
Create data visualizations with MySQL in QlikView.
-
Automated Continuous SAP Business One Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Business One replication to PostgreSQL.
-
How to update Microsoft Project from Excel
This article explains how to transfer data from Excel to Microsoft Project using the Excel Add-In for Microsoft Project.
-
Use the CData Software JDBC Driver for Amazon S3 in MicroStrategy Desktop
Connect to Amazon S3 in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon S3.
-
Explore Geographical Relationships in SAP Netweaver Gateway with Power Map
Create data visualizations with SAP Netweaver Gateway in Power Map.
-
How to connect and process JotForm from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live JotForm
-
How to Access Azure Table Using Entity Framework
This article shows how to access Azure Table Storage using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query GitHub through ODBC in Node.js
Use node-odbc to execute SQL queries against GitHub from Node.js.
-
Use JayDeBeApi to access Dynamics NAV in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Dynamics NAV.
-
Manage Snapchat Ads in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Snapchat Ads.
-
Create Google Ads Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Google Ads to build custom dashboards in Bold BI.
-
Build an OLAP Cube in SSAS from Xero
Establish a connection to Xero Accounting data from SQL Server Analysis Services, and use the Xero Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Klaviyo in MicroStrategy Web
Connect to Klaviyo in MicroStrategy Web using the CData Software ODBC Driver for Klaviyo.
-
How to Query Live Oracle Eloqua Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Eloqua data in natural language using Python.
-
Import HubSpot Using Azure Data Factory
Use CData Connect Cloud to connect to HubSpot from Azure Data Factory and import live HubSpot.
-
A PostgreSQL Interface for Wave Financial
Use the SQL Gateway and Wave Financial ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Couchbase in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Couchbase in SnapLogic.
-
Automated Continuous Microsoft Planner Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Apache Kafka.
-
Automated Continuous Elasticsearch Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Elasticsearch replication to delimited files (CSV/TSV).
-
How to Work with Oracle SCM in AWS Glue Jobs Using JDBC
Connect to Oracle SCM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize ShipStation in Sisense
Create an ElastiCube in Sisense app with access to ShipStation.
-
Use the CData Software JDBC Driver for Printify in MicroStrategy
Connect to Printify in MicroStrategy Developer using the CData Software JDBC Driver for Printify.
-
Replicate Splunk to Multiple Databases
Replicate Splunk to disparate databases with a point-and-click configuration.
-
How to connect to Monday.com in DBVisualizer
Integrate Monday.com with visual data analysis tools and data connection wizards in DBVisualizer
-
Back Up Apache CouchDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CouchDB. In this article, we will employ an SSIS workflow to populate a database with Apache CouchDB data.
-
Use the CData ODBC Driver for Confluence in Microsoft Power Query
You can use the CData Confluence ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Atlassian Confluence into Microsoft Power Query.
-
Build Apps with Live IBM Cloudant in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live IBM Cloudant into the Adalo platform and build custom mobile and web applications with real-time IBM Cloudant.
-
Create Asana Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Asana data access from reports, embedded analytics, and more.
-
Automated Continuous Zoom Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoom replication to Databricks.
-
Visualize Email in TIBCO Spotfire through ADO.NET
Integrate Email into dashboards in TIBCO Spotfire.
-
Automated Continuous Google Spanner Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Spanner replication to Snowflake.
-
Connect to Klaviyo as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for Klaviyo.
-
Bridge Greenplum Connectivity with Apache NiFi
Access and process Pivotal GreenPlum in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Hive in MicroStrategy Desktop
Connect to Apache Hive in MicroStrategy Desktop using the CData Software JDBC Driver for Hive.
-
Automated Continuous Reckon Accounts Hosted Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Apache Kafka.
-
Connect to Salesloft in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesloft in the Denodo Virtual DataPort Administrator.
-
How to create Visio diagrams from Azure Table
Automatically update Azure Table Storage with the changes you make to Visio master shapes.
-
Connect to BigCommerce from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for BigCommerce to connect to BigCommerce and execute queries in PowerBuilder.
-
Rapidly Develop Epicor Kinetic-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Use the CData Software ODBC Driver for Highrise in MicroStrategy
Connect to Highrise CRM in MicroStrategy Developer using the CData Software ODBC Driver for Highrise.
-
Establish a Live Connection with MarkLogic using Tableau Bridge
The CData ODBC Driver for MarkLogic enables you to integrate live MarkLogic into Tableau Cloud dashboards using the Tableau Bridge.
-
Viewing HubSpot in RAD Studio Data Explorer
How to view HubSpot in RAD Studio Data Explorer using the CData ODBC Driver for HubSpot.
-
Automated Continuous Slack Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Slack replication to delimited files (CSV/TSV).
-
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.
-
Automated Continuous Sugar CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Sugar CRM replication to SQLite.
-
Create SuiteCRM-Connected Visualizations in Klipfolio
Use CData Software Connect Server to connect to SuiteCRM from Klipfolio and build custom visualizations using live SuiteCRM.
-
Provide OData Services of Instagram from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Instagram by developing a WCF Service Application.
-
Add Invoiced to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Invoiced with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Apps with Live SAP Hybris C4C in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live SAP Hybris C4C into the Adalo platform and build custom mobile and web applications with real-time SAP Hybris C4C.
-
A PostgreSQL Interface for MYOB AccountRight
Use the Remoting features of the MYOB AccountRight ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ADP in JRuby
Create a simple JRuby app with access to live ADP.
-
How to Query Live Microsoft Teams Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Teams data in natural language using Python.
-
Connect to Printify from PowerBuilder
This article demonstrates how to access Printify from PowerBuilder using the Printify JDBC Driver.
-
How to Use CData Connect to Access Live Zoom in Power Automate
CData Connect for Zoom enables you to integrate Zoom into workflows built using Microsoft Power Automate Desktop.
-
QuickBooks Remote Connector Certificate Revoked
Update QuickBooks Remote Connector to maintain remote access to QuickBooks Desktop
-
Automated Continuous Jira Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jira replication to Snowflake.
-
A PostgreSQL Interface for Microsoft Exchange
Use the Remoting features of the Microsoft Exchange JDBC Driver to create a PostgreSQL entry-point for data access.
-
Author and Share Power BI Reports on Real-Time Google Data Catalog
Use the CData ODBC Driver for Google Data Catalog to visualize Google Data Catalog in Power BI Desktop and then upload to the Power BI service.
-
How to connect to eBay in DBVisualizer
Integrate eBay with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Power BI XMLA as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Power BI XMLA from your Oracle system.
-
Access CouchDB from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache CouchDB from HeidiSQL.
-
Use the CData Software ODBC Driver for Excel Online in MicroStrategy
Connect to Microsoft Excel Online in MicroStrategy Developer using the CData Software ODBC Driver for Excel Online.