CData Software - Knowledge Base
Recent Articles
-
Connect to Beeminder Data from a Connection Pool in JBoss
Integrate Beeminder into Java servlets: Use the Management Console in JBoss to install the Beeminder JDBC Driver.
-
Integrate with EnterpriseDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy EnterpriseDB to a JSON file on disk.
-
View Reports on Real-Time Sage Intacct Data in Power BI Report Server
Use the CData ODBC Driver for Sage Intacct to visualize Sage Intacct in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query SageHR Data in MySQL Workbench
Execute MySQL queries against live SageHR from MySQL Workbench.
-
Seamlessly Bring Shopify Data into Retool Using CData Connect AI
Integrate Shopify data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Viewing ActiveCampaign Data in RAD Studio Data Explorer
How to view ActiveCampaign in RAD Studio Data Explorer using the CData ODBC Driver for ActiveCampaign.
-
Using the CData Software ODBC Driver for Power BI XMLA in PyCharm
Connect to Power BI XMLA as an ODBC data source in PyCharm using the CData Software ODBC Driver for Power BI XMLA.
-
Automate Avalara AvaTax Data Replication to SAP HANA
Use CData Sync to customize and automate Avalara AvaTax replication to SAP HANA.
-
Query Apify Data in ColdFusion
Write standard ColdFusion data access code to connect to Apify.
-
Connect to Nuclia Data in CloverDX (formerly CloverETL)
Transfer Nuclia using the visual workflow in the CloverDX data integration tool.
-
Connect and Visualize Live Pipedrive Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Pipedrive into the Databricks platform and create visualization dashboards with real-time Pipedrive.
-
Feed FormSite Data into FineReport
How to set FormSite as a JDBC data source in FineReport.
-
Build a Simple VCL Application for Printify Data
How to build a simple VCL Application to view Printify in RAD Studio using the CData ODBC Driver for Printify.
-
Migrating data from Reckon to Snowflake using CData SSIS Components.
Easily push Reckon to Snowflake using the CData SSIS Tasks for Reckon and Snowflake.
-
Connect to Kintone Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Kintone.
-
Back Up IBM Cloudant to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cloudant. In this article, we will employ an SSIS workflow to populate a database with IBM Cloudant data.
-
Automated Continuous Certinia Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Certinia replication to PostgreSQL.
-
Edit and Search External Facebook Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Facebook Ads to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Facebook Ads Data objects that you can access from apps and the dashboard.
-
Phoenix Reporting in OBIEE with the Phoenix JDBC Driver
Deploy the Phoenix JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Tally Data in ColdFusion
Write standard ColdFusion data access code to connect to Tally ERP.
-
Use the CData Software JDBC Driver for Clockify in MicroStrategy Desktop
Connect to Clockify in MicroStrategy Desktop using the CData Software JDBC Driver for Clockify.
-
Connect to Typeform Data in Aqua Data Studio
Access Typeform from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query Google Translate Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Translate.
-
Connect to Pushbullet Data in HULFT Integrate
Connect to Pushbullet as a JDBC data source in HULFT Integrate
-
Access Salesforce Pardot Data from MySQL in Amazon QuickSight
Connect to Salesforce Pardot and build visualizations of Salesforce Pardot using a MySQL Connection in Amazon QuickSight.
-
Establish a Live Connection with Twitter Ads Data using Tableau Bridge
The CData ODBC Driver for Twitter Ads enables you to integrate live Twitter Ads into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Shopify Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Shopify from your Google Sheets.
-
Bridge WooCommerce Connectivity with Apache NiFi
Access and process WooCommerce in Apache NiFi using the CData JDBC Driver.
-
How to connect SharePoint with Snapchat Ads Data through external lists
Provide Snapchat Ads to SharePoint users as an external list.
-
Process & Analyze SAP SuccessFactors LMS Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP SuccessFactors LMS Data.
-
Query QuickBooks Online Data in DataGrip
Create a Data Source for QuickBooks Online in DataGrip and use SQL to query live QuickBooks Online.
-
How to connect to Wrike Data from IntelliJ
Integrate connectivity to Wrike with wizards in IntelliJ.
-
Publish SAP SuccessFactors-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP SuccessFactors.
-
Build Spark-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Spark SQL.
-
Stream ZohoDesk Data into Apache Kafka Topics
Access and stream ZohoDesk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Front Data in JRuby
Create a simple JRuby app with access to live Front.
-
Integrate Perplexity with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Perplexity with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Perplexity.
-
Build a PostgreSQL Interface for PostgreSQL Data using the CData JDBC Driver
Use the Remoting features of the PostgreSQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Oracle Financials Cloud Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Financials Cloud with the CData JDBC Driver for Oracle Financials Cloud.
-
Automated Continuous Sage Cloud Accounting Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to MongoDB.
-
Migrating data from Superchat to Snowflake using CData SSIS Components.
Easily push Superchat to Snowflake using the CData SSIS Tasks for Superchat and Snowflake.
-
Create Printify Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Printify from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software JDBC Driver for Testmonitor in MicroStrategy Web
Connect to Testmonitor in MicroStrategy Web using the CData Software JDBC Driver for Testmonitor.
-
Access QuickBooks Time Data from MySQL in PHP
Connect to QuickBooks Time through the standard MySQL libraries in PHP.
-
Automated SAP ByDesign Data Replication to Teradata
Use CData Sync to Customize and automate SAP Business ByDesign replication to Teradata.
-
How to Connect the Power BI Service to Xero: Complete Guide
Connect to the CData Software Power BI Connector for Xero from PowerBI.com to provide real-time Xero Accounting across the organization.
-
How to connect and process Wrike from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Wrike.
-
Getting Started with the CData Excel Add-In for Copper
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Copper.
-
Replicate Microsoft Entra ID Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Entra ID to disparate databases with a single configuration.
-
Connect to Live Google Contacts Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Contacts in CData Connect AI and connect to your Google Contacts from PostgreSQL.
-
Extend Google Sheets with Oracle Sales Data
Make calls to Oracle Sales from Google Apps Script via the API Server.
-
Publish Crystal Reports on Klaviyo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Klaviyo.
-
Automated Continuous Oracle Eloqua Reporting Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to MongoDB.
-
How to Connect to Parallel Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Parallel. Leverage the pyodbc module for ODBC in Python.
-
Connect to SAP Hybris C4C Data in CloverDX (formerly CloverETL)
Transfer SAP Hybris C4C using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous CSV Replication to SQL Server
Use CData Sync for automated, continuous, customizable CSV replication to SQL Server.
-
Viewing Teamwork Data in RAD Studio Data Explorer
How to view Teamwork in RAD Studio Data Explorer using the CData ODBC Driver for Teamwork.
-
Visualize Coda Data in TIBCO Spotfire through ADO.NET
Integrate Coda into dashboards in TIBCO Spotfire.
-
Replicate Adobe Target Data to Multiple Databases via the CData Sync CLI
Replicate Adobe Target to disparate databases with a single configuration.
-
LINQ to Printify Data
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 Printify Data Provider.
-
Connect to GitHub Data in RapidMiner
Integrate GitHub with standard components and data source configuration wizards in RapidMiner Studio.
-
Moving Data from SharePoint to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SharePoint data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query ServiceDesk Plus Data in ColdFusion
Write standard ColdFusion data access code to connect to ServiceDesk Plus.
-
Use the CData Software ODBC Driver for Gumroad in MicroStrategy Desktop
Connect to Gumroad in MicroStrategy Desktop using the CData Software ODBC Driver for Gumroad.
-
Build SQL Analysis Services-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SQL Analysis Services to explore live SQL Analysis Services Data in Claude Code to assist with building SQL Analysis Services-powered applications.
-
Use the CData Software ODBC Driver for FHIR in MicroStrategy Web
Connect to FHIR in MicroStrategy Web using the CData Software ODBC Driver for FHIR.
-
Create Informatica Mappings From/To an ODBC Data Source for Customer.io
Create an ODBC connection to Customer.io in Informatica and browse and transfer Customer.io.
-
Use Agno to Talk to Your SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP BusinessObjects BI for you.
-
Migrating data from Deel to Google BigQuery using CData SSIS Components.
Easily push Deel to Google BigQuery using the CData SSIS Tasks for Deel and Google BigQuery.
-
Bind Live Email Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Email data
-
Establish a Live Connection with SuiteCRM Data using Tableau Bridge
The CData ODBC Driver for SuiteCRM enables you to integrate live SuiteCRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Epicor Kinetic Data in JReport Designer
Create charts and reports based on Epicor Kinetic in JReport Designer.
-
Integrating Boomi Agentstudio with Salesforce Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Salesforce & Force.com, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Invoiced Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Invoiced.
-
Build Data Flows from SQL Server to Avalara AvaTax through SSIS
Easily push SQL Server data to Avalara AvaTax using the CData SSIS Tasks for Avalara AvaTax.
-
Connect to Bitly Data in Ruby
Connect to Bitly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Beeminder Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Beeminder and the SQL Gateway to access Beeminder from Google Apps Script.
-
How to Query SAP HANA Data in MySQL Workbench
Execute MySQL queries against live SAP HANA from MySQL Workbench.
-
How to Work with BigCommerce Data in AWS Glue Jobs Using JDBC
Connect to BigCommerce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Real-Time Nuclia Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Nuclia in Power Apps.
-
Connect to Adobe Commerce Data in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Commerce in FileMaker Pro to connect to Adobe Commerce and work with Adobe Commerce in your FileMaker applications.
-
Visualize Stack Exchange Data in TIBCO Spotfire through ADO.NET
Integrate Stack Exchange into dashboards in TIBCO Spotfire.
-
Integrate with Attio Data in JReport Designer
Create charts and reports based on Attio in JReport Designer.
-
Query Zoho Books Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho Books entities in PHP by modeling them as objects.
-
Connect to AlloyDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google AlloyDB, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import Real-Time SurveyMonkey Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SurveyMonkey in ColdFusion.
-
Connect to Impala Data in JRuby
Create a simple JRuby app with access to live Apache Impala.
-
View Reports on Real-Time Google Campaign Manager 360 Data in Power BI Report Server
Use the CData ODBC Driver for Google Campaign Manager 360 to visualize Google Campaign Manager 360 in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Grok to Talk to Your FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your FHIR for you.
-
Query Bitbucket Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Bitbucket and perform CRUD operations on Bitbucket from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for Apify
Create Apify data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Nuclia Data in Jaspersoft Studio
Execute SQL to remote Nuclia in Jaspersoft Studio.
-
Connect to Phoenix Data in HULFT Integrate
Connect to Phoenix as a JDBC data source in HULFT Integrate
-
Analyze Live SAP ByDesign Data in SAS Viya
Use CData Connect AI to connect to SAP Business ByDesign from SAS Viya and deploy self-service analytics using live SAP Business ByDesign.
-
Automated Continuous AfterShip Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable AfterShip replication to Amazon Redshift.
-
Automated Continuous VWO Replication to Vertica
Use CData Sync for automated, continuous, customizable VWO replication to Vertica.
-
How to connect to Brex Data with Squirrel SQL client
Connect to Brex and execute queries in the Squirrel SQL Client.
-
Create Factorial Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Factorial data access from reports, embedded analytics, and more.
-
Connect to Aircall Data in NetBeans
Connect to Aircall in NetBeans with the data source configuration wizard.
-
Integrate Real-Time Access to SAP Concur in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Concur in real time.