CData Software - Knowledge Base
Recent Articles
-
Visualize Cloudant in Tableau
The CData ODBC driver for Cloudant enables you integrate IBM Cloudant into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for Bing Ads
Create an ODBC connection to Bing Ads in Informatica and browse and transfer Bing Ads.
-
Connect to Redshift from a Connection Pool in WebLogic
Use the CData JDBC Driver for Redshift to connect to Amazon Redshift from Web applications running on WebLogic.
-
Query Pipedrive in ColdFusion
Write standard ColdFusion data access code to connect to Pipedrive.
-
Rapidly Develop Bing Ads-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 Certinia Replication to Databricks
Use CData Sync for automated, continuous, customizable Certinia replication to Databricks.
-
Import LinkedIn Ads Using Azure Data Factory
Use CData Connect AI to connect to LinkedIn Ads from Azure Data Factory and import live LinkedIn Ads.
-
Analyze Google Sheets in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Sheets in Microsoft R Open.
-
Visualize CockroachDB in Tableau
The CData ODBC driver for CockroachDB enables you integrate CockroachDB into Tableau dashboards.
-
Connect to Salesforce Marketing from a Connection Pool in Jetty
The Salesforce Marketing JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce Marketing Cloud from Web apps in Jetty.
-
Automated Continuous Bing Ads Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bing Ads replication to OneLake in Microsoft Fabric.
-
Write a Simple Go Application to work with Typeform on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Typeform.
-
Bidirectional Access to HDFS from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache HDFS in Filemaker Pro for Mac or Windows.
-
Easily Integrate DocuSign in Lazarus Pascal IDE
Learn how to easily integrate live DocuSign in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Publish RSS-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live RSS Feeds.
-
How to integrate Metabase with Paylocity
Use CData Connect AI to connect to live Paylocity and create an interactive dashboard in Metabase from Paylocity.
-
Query Access using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Access entities in PHP by modeling them as objects.
-
How to load PayPal data into Elasticsearch via Logstash
Introducing a simple method to load PayPal data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live SAP Hybris C4C from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP Hybris C4C for you.
-
Enable the Bullhorn CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bullhorn CRM.
-
Visualize Lakebase in Sisense
Create an ElastiCube in Sisense app with access to Lakebase.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SendGrid to Power BI dashboards. Simply drag and drop SendGrid into data visuals on the Power BI canvas.
-
Analyze ClickUp in Infragistics Reveal
Use the CData API Server to create an OData API on top of ClickUp and visualize live ClickUp in Infragistics Reveal.
-
Visualize Airtable in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Airtable into TIBCO Spotfire.
-
Epicor Kinetic Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Epicor Kinetic through CData Connect AI using different applications and tools.
-
How to work with SQL Server in Apache Spark using SQL
Access and process SQL Server in Apache Spark using the CData Software JDBC Driver.
-
Model Tableau CRM Analytics Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Tableau CRM Analytics, enabling the direct import of real-time Tableau CRM Analytics.
-
Integrate with BigCommerce in SnapLogic
Use CData Connect AI to connect to and integrate with live BigCommerce in SnapLogic.
-
How to connect Amazon QuickSight to Xero
Create a connection to Xero Accounting in CData Connect AI and insert Xero Accounting into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Presto in Ruby
Connect to Presto in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build SAP HANA XS Advanced-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP HANA XS Advanced and build web apps with connectivity to live SAP HANA XS Advanced.
-
Write a Simple Go Application to work with Dropbox on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Dropbox.
-
Access Azure Analysis Services from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Analysis Services from HeidiSQL.
-
Replicate Azure Synapse in Heroku for Use in Salesforce Connect
Replicate Azure Synapse to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous MailChimp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MailChimp replication to IBM DB2.
-
Enable the Unbounce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Unbounce.
-
Analyze eBay Analytics with Power Pivot
This article walks you through the process of using the CData ODBC Driver for eBay Analytics from Power Pivot. You will use the Table Import Wizard to load eBay Analytics. You can visually build the import query or use any SQL supported by the driver.
-
Build Dashboards with Active Directory in Dundas BI
Create dynamic dashboards and perform analytics based on Active Directory in Dundas BI.
-
Analyze Zendesk in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zendesk with the CData JDBC Driver for Zendesk.
-
Access Live Jira Service Management in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Atlassian Jira Service Management from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Feed Sugar CRM into FineReport
How to set Sugar CRM as a JDBC data source in FineReport.
-
Integrate with Presto in SnapLogic
Use CData Connect AI to connect to and integrate with live Presto in SnapLogic.
-
Access SAP Ariba Source as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Ariba Source from your Oracle system.
-
Create Reports with LinkedIn in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LinkedIn.
-
Connecting Moonlit Workflow with Reckon via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Reckon in real time.
-
PowerShell Scripting to Replicate Azure Data Lake Storage to MySQL
Write a simple PowerShell script to replicate Azure Data Lake Storage to a MySQL database.
-
Connect to Power BI XMLA as an External Source in Dremio
Use the CData JDBC Driver to connect to Power BI XMLA as an External Source in Dremio.
-
Natively Connect to Oracle Sales in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle Sales. Leverage the native support for ODBC in PHP.
-
Model Zuora Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zuora, enabling the direct import of real-time Zuora.
-
Connect to Freshdesk in Google Apps Script via Connect AI
Use CData Connect AI to access Freshdesk in Google Apps Script.
-
Create Power BI Reports on Real-Time Zendesk
Use the CData ODBC Driver for Zendesk to visualize Zendesk in Power BI Desktop.
-
Explore Geographical Relationships in SharePoint Excel Services with Power Map
Create data visualizations with SharePoint Excel Services in Power Map.
-
Automate Adobe Commerce Replication to Couchbase
Use CData Sync to Customize and automate Adobe Commerce replication to Couchbase.
-
Validate Square with QuerySurge
Access and validate Square in QuerySurge using the CData JDBC Driver.
-
Build NetSuite-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live NetSuite CRM & ERP.
-
Connect to Microsoft Project from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Project from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Project.
-
Migrating data from Asana to Snowflake using CData SSIS Components.
Easily push Asana to Snowflake using the CData SSIS Tasks for Asana and Snowflake.
-
Connect to QuickBooks Time from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from QuickBooks Time, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect and Query Live NetSuite Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live NetSuite CRM & ERP into Databricks
-
Use Dash to Build to Web Apps on BigCommerce
Create Python applications that use pandas and Dash to build BigCommerce-connected web apps.
-
Replicate Facebook Ads from PowerShell
Write a quick PowerShell script to query Facebook Ads. Use connectivity to the live data to replicate Facebook Ads to SQL Server.
-
Configure the CData JDBC Driver for HCL Domino in a Connection Pool in Tomcat
Connect to HCL Domino from a connection pool in Tomcat.
-
Visualize Jira in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Atlassian Jira into TIBCO Spotfire.
-
Connect to Oracle Eloqua in HULFT Integrate
Connect to Oracle Eloqua as a JDBC data source in HULFT Integrate
-
Amazon Marketplace Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amazon Marketplace facts in real time.
-
Build Todoist-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Todoist and build web apps with connectivity to live Todoist.
-
Import NetSuite into the Power BI Service for Visualizations
Use CData Connect AI to connect to NetSuite and provide access to live NetSuite CRM & ERP for custom reports in the Power BI Service.
-
Replicate HCL Domino to Multiple Databases via the CData Sync CLI
Replicate HCL Domino to disparate databases with a single configuration.
-
Build Trello Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Trello and build visualizations in Tableau Cloud.
-
Getting Started with the CData Tableau Connector for Bullhorn CRM
-