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
-
Stream Zoom into Apache Kafka Topics
Access and stream Zoom in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query TaxJar in MySQL Workbench
Create a virtual MySQL database for TaxJar in CData Software Connect (or Connect Server) and work with live TaxJar in MySQL Workbench.
-
Automated Continuous Unbounce Replication to SQLite
Use CData Sync for automated, continuous, customizable Unbounce replication to SQLite.
-
DataBind Charts to Spark
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Spark SQL 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.
-
Work with Live Microsoft Exchange in Power Query
Use CData Connect Cloud to connect to Microsoft Exchange and work with live Microsoft Exchange in Microsoft Power Query.
-
Create MYOB AccountRight Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access eBay from MySQL in PHP
Connect to eBay through the standard MySQL libraries in PHP.
-
Add Sage 50 UK to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sage 50 UK with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize Wave Financial in Tableau
The CData ODBC driver for Wave Financial enables you integrate Wave Financial into Tableau dashboards.
-
Publish Crystal Reports on Phoenix
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Phoenix.
-
Automated BigCommerce Replication to Teradata
Use CData Sync to Customize and automate BigCommerce replication to Teradata.
-
Use CData Connect Cloud to Access Azure Analysis Services in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Azure Analysis Services in the Power Pivot business intelligence tool.
-
Choosing the Best Method to Connect Couchbase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Couchbase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build OneNote Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Microsoft OneNote and build visualizations in Tableau.
-
How to Access Reckon Accounts Hosted Using Entity Framework
This article shows how to access Reckon Accounts Hosted using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Author and Share Power BI Reports on Real-Time Twitter
Use the CData ODBC Driver for Twitter to visualize Twitter in Power BI Desktop and then upload to the Power BI service.
-
Build Dynamics 365 Business Central Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Dynamics 365 Business Central and build visualizations in Tableau.
-
Build Dashboards with HCL Domino in DBxtra
Create dynamic dashboards and perform analytics based on HCL Domino in DBxtra.
-
Build Microsoft Project-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Microsoft Project and create custom apps in Mendix.
-
Write a Simple Go Application to work with Oracle SCM on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle SCM.
-
Use Dash to Build to Web Apps on SAP Netweaver Gateway
Create Python applications that use pandas and Dash to build SAP Netweaver Gateway-connected web apps.
-
Automated Continuous YouTube Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Vertica.
-
A PostgreSQL Interface for Sage 300
Use the Remoting features of the Sage 300 JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Wave Financial in Python with CData
Create ETL applications and real-time data pipelines for Wave Financial in Python with petl.
-
Import ClickUp into Microsoft Power Query
The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access ClickUp. In this article, you will use the OData format to import ClickUp into Microsoft Power Query.
-
Build Automated Workflows with Live Oracle Service Cloud in Workato
Use CData Connect Cloud to connect to live Oracle Service Cloud and build automated workflows in Workato.
-
Write a Simple Go Application to work with Highrise on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Highrise CRM.
-
How to connect to Microsoft Exchange in DBVisualizer
Integrate Microsoft Exchange with visual data analysis tools and data connection wizards in DBVisualizer
-
ETL Oracle Service Cloud in Oracle Data Integrator
This article shows how to transfer Oracle Service Cloud into a data warehouse using Oracle Data Integrator.
-
How to connect to Google Data Catalog from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Google Data Catalog and work with Google Data Catalog in Microsoft Excel on Mac OS X.
-
Automate MongoDB Replication to Azure Data Lake
Use CData Sync to customize and automate MongoDB replication to Azure Data Lake.
-
Model Azure Table Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Azure Table, enabling the direct import of real-time Azure Table Storage.
-
How to connect to Jira from IntelliJ
Integrate connectivity to Atlassian Jira with wizards in IntelliJ.
-
Publish Reports with Zoho CRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho CRM.
-
ETL Kafka in Oracle Data Integrator
This article shows how to transfer Apache Kafka into a data warehouse using Oracle Data Integrator.
-
Create Data Visualizations in Cognos BI with Avalara AvaTax
Access Avalara AvaTax as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Google Directory Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Directory replication to AlloyDB.
-
Automated Continuous Cosmos DB Replication to SQLite
Use CData Sync for automated, continuous, customizable Cosmos DB replication to SQLite.
-
Publish Reports with Act CRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act CRM.
-
Automate Cloudant Replication to SAP HANA
Use CData Sync to customize and automate IBM Cloudant replication to SAP HANA.
-
LINQ to Facebook
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Facebook Data Provider.
-
Replicate Multiple IBM Cloud Object Storage Accounts
Replicate multiple IBM Cloud Object Storage accounts to one or many databases.
-
How to pipe Odoo to CSV in PowerShell
Use standard PowerShell cmdlets to access Odoo tables.
-
Rapidly Develop EnterpriseDB-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.
-
Automated Continuous HBase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HBase replication to Google BigQuery.
-
Integrate with Google Campaign Manager 360 in JReport Designer
Create charts and reports based on Google Campaign Manager 360 in JReport Designer.
-
Import PayPal into FileMaker Pro
Create reports that integrate PayPal in Filemaker Pro.
-
Create Amazon Athena Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Quickbase-Connected Apps in Choreo
Use CData Connect Cloud to connect to Quickbase from Choreo and build custom apps using live Quickbase.
-
Author and Share Power BI Reports on Real-Time Printful
Use the CData ODBC Driver for Printful to visualize Printful in Power BI Desktop and then upload to the Power BI service.
-
Access Amazon S3 in PHP through Connect Server
Connect to Amazon S3 through the standard SQL Server libraries in PHP.
-
Use the CData SSIS Components to Insert New or Update Existing EnterpriseDB Records from SQL Server
Easily push SQL Server data to EnterpriseDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into EnterpriseDB or update existing records with data from a SQL Server database.
-
Prepare, Blend, and Analyze Oracle Service Cloud in Alteryx Designer
Build workflows to access live Oracle Service Cloud for self-service data analytics.
-
How to Use a Microsoft Access Database to Update Zendesk in Real Time
Update Zendesk data by creating a linked table in Microsoft Access with the CData Zendesk ODBC Driver.
-
A PostgreSQL Interface for Stripe
Use the SQL Gateway and Stripe ODBC Driver to create a PostgreSQL entry-point for data access.
-
Process & Analyze LDAP Objects in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LDAP Objects.
-
Visualize Live Cosmos DB in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Azure Cosmos DB into custom reports in Power BI.
-
How to Access Live Zendesk in Power Automate Desktop via ODBC
The CData ODBC Driver for Zendesk enables you to integrate Zendesk into workflows built using Microsoft Power Automate Desktop.
-
Analyze Dynamics 365 Business Central in Looker
Use CData Connect Cloud to connect to Dynamics 365 Business Central from Looker and build custom apps using live Dynamics 365 Business Central.
-
Connect to Klaviyo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Klaviyo to connect to Klaviyo from Web applications running on WebLogic.
-
Viewing Snowflake in RAD Studio Data Explorer
How to view Snowflake in RAD Studio Data Explorer using the CData ODBC Driver for Snowflake.
-
Query HubSpot as a SQL Server Database in Node.js
Execute SQL Server queries against HubSpot from Node.js.
-
How to connect PolyBase to Splunk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Splunk.
-
Deploy the ADO.NET Provider for Drift on an SSRS Report Server
Connect to Drift from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Analyze Google Cloud Storage in Infragistics Reveal
Use the CData Connect Server to create an OData API on top of Google Cloud Storage and visualize live Google Cloud Storage in Ingragistics Reveal.
-
Connect to and Query GitHub in QlikView over ODBC
Create data visualizations with GitHub in QlikView.
-
Work with REST in FoxPro
Load REST into a FoxPro database. This article includes full code and a walk-through of the process.
-
Author and Share Power BI Reports on Real-Time IBM Cloud Object Storage
Use the CData ODBC Driver for IBM Cloud Object Storage to visualize IBM Cloud Object Storage in Power BI Desktop and then upload to the Power BI service.
-
Automated Continuous MYOB AccountRight Replication to Azure SQL
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Azure SQL.
-
How to Connect to Epicor Kinetic in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Epicor Kinetic. Leverage the pyodbc module for ODBC in Python.
-
Connect to Outreach.io as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for Outreach.io.
-
How to use SQLAlchemy ORM to access IBM Informix in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM Informix.
-
How to Connect to & Open Procore in Microsoft Excel
This article uses the CData ODBC driver for Procore to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
HubDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HubDB facts in real time.
-
Build Automated Google Analytics-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Google Analytics and build automated workflows in Zapier.
-
Connect to PayPal in NetBeans
Connect to PayPal in NetBeans with the data source configuration wizard.
-
Connect to SAP from a Connection Pool in JBoss
Integrate SAP ERP/NetWeaver into Java servlets: Use the Management Console in JBoss to install the SAP JDBC Driver.
-
Create SSAS Tabular Models from BigCommerce
How to build a SQL Server Analysis Service Tabular Model from BigCommerce using CData drivers.
-
Connect to eBay Analytics in NetBeans
Connect to eBay Analytics in NetBeans with the data source configuration wizard.
-
Extract, Transform, and Load Printify in Informatica PowerCenter
Create a simple Workflow for Printify in Informatica PowerCenter.
-
Displaying Data from Related Tables Using Angular with the API Server
Use the API Server and Angular to build a Web App to dynamically display related tables.
-
Connect to Microsoft OneDrive in as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft OneDrive as an External Source in Dremio.
-
Access NetSuite Saved Searches as Views
You can use CData NetSuite Data Providers to access saved searches from third-party tools.
-
How to Import Dynamics CRM into SQL Server using SSIS
Easily back up Microsoft Dynamics CRM to SQL Server using the SSIS components for Dynamics CRM.
-
FTP Reporting in OBIEE with the FTP JDBC Driver
Deploy the FTP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Amazon S3 in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect to Sage Intacct from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Sage Intacct and work with Sage Intacct in Microsoft Excel on Mac OS X.
-
Connect to Workday from PowerBuilder
This article demonstrates how to access Workday from Appeon PowerBuilder using the CData ADO.NET Provider for Workday.
-
How to pipe Drip to CSV in PowerShell
Use standard PowerShell cmdlets to access Drip tables.
-
Connect to IBM Cloud Object Storage from PowerBuilder
This article demonstrates how to access IBM Cloud Object Storage from PowerBuilder using the IBM Cloud Object Storage JDBC Driver.
-
Connect to Neo4J in NetBeans
Connect to Neo4J in NetBeans with the data source configuration wizard.
-
Connect to and Query Azure Analysis Services in QlikView over ODBC
Create data visualizations with Azure Analysis Services in QlikView.
-
Google Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Ads facts in real time.
-
Connect to and Query Airtable in QlikView over ODBC
Create data visualizations with Airtable in QlikView.
-
Build Sybase IQ-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for Sybase IQ and build visualizations and dashbaords from Sybase IQ in Redash.
-
PowerShell Scripting to Replicate MongoDB to MySQL
Write a simple PowerShell script to replicate MongoDB to a MySQL database.
-
Visualize Google Directory in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Directory into TIBCO Spotfire.
-
Connect to Jira from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for Jira to connect to Atlassian Jira and execute queries in PowerBuilder.
-
Import Real-Time Oracle Service Cloud in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Service Cloud in ColdFusion.
-
Connect to BigCommerce in HULFT Integrate
Connect to BigCommerce as a JDBC data source in HULFT Integrate