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
-
Connect to Azure Data Catalog in DBArtisan
Use wizards in DBArtisan to configure Azure Data Catalog as a data source.
-
Connect to Live LinkedIn Ads in PostGresSQL Interface through CData Connect Cloud
Create a live connection to LinkedIn Ads in CData Connect Cloud and connect to your LinkedIn Ads from PostgreSQL.
-
Create Avalara AvaTax Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Avalara AvaTax to build custom dashboards in Bold BI.
-
Load Redshift to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Redshift to a database.
-
Access Live Snapchat Ads in Excel 365 Online (Excel for the web)
Connect to Snapchat Ads from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Work with eBay in FoxPro
Load eBay into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Klipfolio in JReport Designer
Create charts and reports based on Klipfolio in JReport Designer.
-
A PostgreSQL Interface for Sybase IQ
Use the SQL Gateway and Sybase IQ ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Kintone in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Kintone in ColdFusion.
-
Use the CData Software JDBC Driver for Confluence in MicroStrategy Web
Connect to Atlassian Confluence in MicroStrategy Web using the CData Software JDBC Driver for Confluence.
-
Import Real-Time CouchDB in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache CouchDB in ColdFusion.
-
Integrate Splunk into Power Automate Desktop using CData Connect
CData Connect for Splunk enables you to integrate Splunk into workflows built using Microsoft Power Automate Desktop.
-
Build DocuSign-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live DocuSign and build DocuSign-connected web apps with Axios.
-
How to Work with Act CRM in ETL Validator JDBC
Connect to Act CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Create SSAS Tabular Models from Certinia
How to build a SQL Server Analysis Service Tabular Model from Certinia using CData drivers.
-
Write a Simple Go Application to work with WooCommerce on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to WooCommerce.
-
Automated Continuous HCL Domino Replication to SQLite
Use CData Sync for automated, continuous, customizable HCL Domino replication to SQLite.
-
Automated Continuous Bing Search Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Bing Search replication to Amazon S3.
-
Build Azure Table-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Azure Table Storage.
-
Automate Certinia Replication to Azure Data Lake
Use CData Sync to customize and automate Certinia replication to Azure Data Lake.
-
Automated Continuous Monday.com Replication to SQL Server
Use CData Sync for automated, continuous, customizable Monday.com replication to SQL Server.
-
Build MVC Applications with Connectivity to Bing Search Results
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bing Search from an ASP.NET MVC application.
-
Connect to Azure Data Lake Storage in as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure Data Lake Storage as an External Source in Dremio.
-
Connect to and Visualize Live WooCommerce in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live WooCommerce.
-
Query Neo4J in MySQL Workbench
Create a virtual MySQL database for Neo4J in CData Software Connect (or Connect Server) and work with live Neo4J in MySQL Workbench.
-
Connect to Live ServiceNow in MicroStrategy through CData Connect Cloud
Create a live connection to ServiceNow in CData Connect Cloud and connect to your ServiceNow from MicroStrategy.
-
Access Live MYOB AccountRight in Excel 365 Online (Excel for the web)
Connect to MYOB AccountRight from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Automated Continuous Sage Cloud Accounting Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to delimited files (CSV/TSV).
-
Integrate with Twitter Ads using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Twitter Ads to a JSON file on disk.
-
Natively Connect to SAP HANA in PHP
The CData ODBC driver for SAP HANA enables you to create PHP applications with connectivity to SAP HANA. Leverage the native support for ODBC in PHP.
-
Use Dash to Build to Web Apps on DocuSign
Create Python applications that use pandas and Dash to build DocuSign-connected web apps.
-
How to Query Live SAP Netweaver Gateway Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Netweaver Gateway data in natural language using Python.
-
Create Datasets from Azure Synapse in Domo Workbench and Build Visualizations of Azure Synapse in Domo
Use the CData Software ODBC Driver for Azure Synapse to create datasets from Azure Synapse in Domo Workbench and then build visualizations in the Domo service.
-
Automate LDAP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LDAP from PowerShell? This article demonstrates how to utilize the LDAP Cmdlets for tasks like connecting to LDAP, automating operations, downloading data, and more.
-
Automated Continuous PayPal Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PayPal replication to Amazon S3.
-
Connect to JSON Services in as an External Source in Dremio
Use the CData JDBC Driver to connect to JSON as an External Source in Dremio.
-
Visualize Live Hive in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Apache Hive into custom reports in Power BI.
-
Extract, Transform, and Load Trello in Informatica PowerCenter
Create a simple Workflow for Trello in Informatica PowerCenter.
-
How to use SQLAlchemy ORM to access Dynamics NAV in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dynamics NAV.
-
Connect to Gmail in HULFT Integrate
Connect to Gmail as a JDBC data source in HULFT Integrate
-
How to Use CData Connect to Access Live Drift in Power Automate
CData Connect for Drift enables you to integrate Drift into workflows built using Microsoft Power Automate Desktop.
-
Prepare, Blend, and Analyze Salesforce Marketing in Alteryx Designer
Build workflows to access live Salesforce Marketing Cloud for self-service data analytics.
-
Extract, Transform, and Load EventBrite in Informatica PowerCenter
Create a simple Workflow for Eventbrite in Informatica PowerCenter.
-
View Reports on Real-Time Certinia in Power BI Report Server
Use the CData ODBC Driver for Certinia to visualize Certinia in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Data Visualizations Based On Workday in Mode
Use CData Connect Cloud to connect to Workday from Mode and build visualizations using live
-
Validate Tableau CRM Analytics with QuerySurge
Access and validate Tableau CRM Analytics in QuerySurge using the CData JDBC Driver.
-
Visualize Live Outreach.io in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Outreach.io.
-
Access Live Freshdesk in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Freshdesk to create a Freshdesk source in TIBCO Data Virtualization Studio and gain access to live Freshdesk from your TDV Server.
-
LINQ to Microsoft Dataverse
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 Microsoft Dataverse Data Provider.
-
Use the CData Software JDBC Driver for QuickBooks in MicroStrategy Web
Connect to QuickBooks Desktop in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks.
-
Analyze Printful with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Printful from Power Pivot. You will use the Table Import Wizard to load Printful. You can visually build the import query or use any SQL supported by the driver.
-
Create Data Visualizations in Cognos BI with Marketo
Access Marketo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Dash to Build to Web Apps on SuiteCRM
Create Python applications that use pandas and Dash to build SuiteCRM-connected web apps.
-
Connect to Okta in the Denodo Platform
Use CData driver technologies to create a virtual data source for Okta in the Denodo Virtual DataPort Administrator.
-
DataBind Controls to Zoho CRM in C++Builder
DataBind to Zoho CRM in C++Builder with standard components and controls.
-
View Reports on Real-Time BambooHR in Power BI Report Server
Use the CData ODBC Driver for BambooHR to visualize BambooHR in Power BI Desktop and then publish them to Power BI Report Server.
-
Create SSAS Tabular Models from ClickUp
How to build a SQL Server Analysis Service Tabular Model from ClickUp using CData drivers.
-
Build SurveyMonkey-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for SurveyMonkey and create custom apps in Mendix.
-
Replicate Printify to Multiple Databases
Replicate Printify to disparate databases with a single configuration.
-
Connect to SAP Netweaver Gateway from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Netweaver Gateway to connect to SAP Netweaver Gateway from Web applications running on WebLogic.
-
Enable the Raisers Edge NXT JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Raisers Edge NXT.
-
Publish ADP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ADP.
-
Create SendGrid-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to SendGrid from OutSystems and build custom enterprise apps using live SendGrid.
-
Create Instagram-Connected Business Apps in AppSheet
Connect to Instagram via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Instagram.
-
How to Build Dynamic React Apps with Google Cloud Storage
Use the CData Connect and React to Build Dynamic Web Apps with Live Google Cloud Storage .
-
Configure the CData JDBC Driver for Instagram in a Connection Pool in Tomcat
Connect to Instagram from a connection pool in Tomcat.
-
Automate HubSpot Replication to Azure Data Lake
Use CData Sync to customize and automate HubSpot replication to Azure Data Lake.
-
Automated Continuous Dynamics 365 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Google Cloud SQL.
-
Visualize Asana in TIBCO Spotfire through OData
Integrate Asana into dashboards in TIBCO Spotfire.
-
Connect to Oracle in RazorSQL
Connect to Oracle from wizards and query Oracle Database from the GUI in the RazorSQL database management tool.
-
Validate Acumatica with QuerySurge
Access and validate Acumatica ERP in QuerySurge using the CData JDBC Driver.
-
Integrate Live Salesforce Marketing into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to Salesforce Marketing Cloud and integrate live Salesforce Marketing Cloud into apps built in Microsoft Power Apps.
-
How to load Monday.com data into Elasticsearch via Logstash
Introducing a simple method to load Monday.com 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.
-
Access Live Twilio in Coginiti Pro
Connect to and query live Twilio from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
PowerShell Scripting to Replicate Xero to MySQL
Write a simple PowerShell script to replicate Xero Accounting to a MySQL database.
-
Query Acumatica in MySQL Workbench
Create a virtual MySQL database for Acumatica ERP in CData Software Connect (or Connect Server) and work with live Acumatica ERP in MySQL Workbench.
-
Build Outreach.io Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Outreach.io and build visualizations in Tableau Cloud.
-
Import Real-Time Sage Cloud Accounting in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage Business Cloud Accounting in ColdFusion.
-
Load SAP Hybris C4C to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Hybris C4C to a database.
-
Connect to Printful in Google Apps Script
Use the ODBC Driver for Printful and the SQL Gateway to access Printful from Google Apps Script.
-
Integrate MarkLogic into Automated Tasks with Power Automate
Use CData Software Connect Server to create a virtual SQL Server database for MarkLogic and integrate live MarkLogic into your Power Automate (Microsoft Flow) tasks.
-
Automated Continuous Box Replication to Databricks
Use CData Sync for automated, continuous, customizable Box replication to Databricks.
-
Build Workday-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Workday and create custom apps in Mendix.
-
Replicate Multiple Dynamics CRM Accounts
Replicate multiple Dynamics CRM accounts to one or many databases.
-
Integrate Live Marketo into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to Marketo and integrate live Marketo into apps built in Microsoft Power Apps.
-
Integrate Wave Financial with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Wave Financial with External Services.
-
Bidirectional Access to Sybase IQ from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sybase IQ in Filemaker Pro for Mac or Windows.
-
How to Work with PayPal in AWS Glue Jobs Using JDBC
Connect to PayPal from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HCL Domino
Provide connectivity to HCL Domino through an SAP BusinessObjects universe.
-
DataBind Controls to YouTube Analytics in Delphi
DataBind to YouTube Analytics in Delphi with standard data access components and controls.
-
Natively Connect to Dynamics 365 Business Central in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Dynamics 365 Business Central. Leverage the native support for ODBC in PHP.
-
Integrate Invoiced in the Pentaho Report Designer
Publish reports based on Invoiced in the Pentaho BI tool.
-
Create Pipedrive-Connected Business Apps in AppSheet
Use CData Software Connect Server to connect to Pipedrive from AppSheet and build custom business apps using live Pipedrive.
-
Access Live Okta in AWS Lambda
Connect to live Okta in AWS Lambda using the CData JDBC Driver.
-
Access Live SAP in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP ERP/NetWeaver in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Email in Aqua Data Studio
Access Email from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Rapidly Develop Shopify-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 SharePoint Replication to Databricks
Use CData Sync for automated, continuous, customizable SharePoint replication to Databricks.
-
Connect to SAP Concur through External Services in Salesforce
Use CData Connect Cloud to securely provide OData feeds of SAP Concur to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Concur objects that you can access from apps and the dashboard.