CData Software - Knowledge Base
Recent Articles
-
Connect to SAS Data Sets from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAS Data Sets to connect to SAS Data Sets from Web applications running on WebLogic.
-
DataBind Controls to Beeminder Data in C++Builder
DataBind to Beeminder in C++Builder with standard components and controls.
-
How to connect PolyBase to Microsoft Teams
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Teams.
-
Migrating data from EnterpriseDB to Snowflake using CData SSIS Components.
Easily push EnterpriseDB to Snowflake using the CData SSIS Tasks for EnterpriseDB and Snowflake.
-
Automate Sugar CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sugar CRM from PowerShell? This article demonstrates how to utilize the Sugar CRM Cmdlets for tasks like connecting to Sugar CRM, automating operations, downloading data, and more.
-
Build Adobe Commerce-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Adobe Commerce to explore live Adobe Commerce Data in GitHub Copilot to assist with building Adobe Commerce-powered applications.
-
Back Up Egnyte to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Egnyte data.
-
How to Seamlessly Import ChargeOver Data into IBM SPSS Modeler
Integrate ChargeOver data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with Live Sybase IQ Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sybase IQ from the MuleSoft Anypoint Platform to integrate live Sybase IQ into custom reports and dashboards.
-
Connect to Teamwork Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Teamwork.
-
Integrate with Zoho Projects Data in JReport Designer
Create charts and reports based on Zoho Projects in JReport Designer.
-
Build Apps with Live iContact Data Using the Low-Code Development Platform of Mendix
Connect iContact with Mendix to build apps using the CData API Driver for JDBC.
-
Validate MYOB AccountRight Data with QuerySurge
Access and validate MYOB AccountRight in QuerySurge using the CData JDBC Driver.
-
Automate DB2 Data Replication to Couchbase
Use CData Sync to Customize and automate IBM DB2 replication to Couchbase.
-
How to work with Jumpseller Data in Apache Spark using SQL
Access and process Jumpseller Data in Apache Spark using the CData Software JDBC Driver.
-
Seamlessly Bring Highrise Data into Retool Using CData Connect AI
Integrate Highrise data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Analyze Instagram Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Instagram from Power Pivot. You will use the Table Import Wizard to load Instagram. You can visually build the import query or use any SQL supported by the driver.
-
Working with Intercom Data in LINQPad
Execute LINQ queries to Intercom in LINQPad.
-
Create Reckon Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Reckon data access from reports, embedded analytics, and more.
-
How to Connect to & Open Google Spanner Data in Microsoft Excel
This article uses the CData ODBC driver for Google Spanner to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build an OLAP Cube in SSAS from Oracle Eloqua Reporting Data
Establish a connection to Oracle Eloqua Reporting data from SQL Server Analysis Services, and use the Oracle Eloqua Reporting Data Provider to build OLAP cubes for use in analytics and reporting.
-
Consume SparkPost OData Feeds in PowerBuilder
This article demonstrates how to consume SparkPost as OData feeds from PowerBuilder using the API Server.
-
Connect to Salesforce Data 360 Data in CloverDX (formerly CloverETL)
Transfer Salesforce Data 360 using the visual workflow in the CloverDX data integration tool.
-
How to Visualize Reply.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Reply.io in Python.
-
Replicate Vertica Data in Heroku for Use in Salesforce Connect
Replicate Vertica to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import Real-Time Drift Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Drift in ColdFusion.
-
Connect Gmail Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Gmail using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Informatica Mappings From/To an ODBC Data Source for Pingdom
Create an ODBC connection to Pingdom in Informatica and browse and transfer Pingdom.
-
Connect to MYOB AccountRight Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MYOB AccountRight as an External Source in Dremio.
-
Integrate with Certinia Data in JReport Designer
Create charts and reports based on Certinia in JReport Designer.
-
Use Manus AI to Talk to Your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Zoho CRM.
-
Automate Instagram Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Instagram from PowerShell? This article demonstrates how to utilize the Instagram Cmdlets for tasks like connecting to Instagram, automating operations, downloading data, and more.
-
Connect to Paylocity Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Paylocity and the Script function in FileMaker Pro to connect to Paylocity and work with Paylocity in your FileMaker application.
-
Using the CData Software ODBC Driver for Invoiced in PyCharm
Connect to Invoiced as an ODBC data source in PyCharm using the CData Software ODBC Driver for Invoiced.
-
DataBind Controls to Grafana Data in C++Builder
DataBind to Grafana in C++Builder with standard components and controls.
-
Automated Continuous Calendly Replication to SQLite
Use CData Sync for automated, continuous, customizable Calendly replication to SQLite.
-
Integrate Wistia with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Wistia with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Wistia.
-
Connect to HBase Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apache HBase in Airbyte.
-
Integrate IBM Informix Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to IBM Informix and integrate live IBM Informix into your Power Automate tasks.
-
Build Pipelines with Live Google Calendar Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Calendar from Google Cloud Data Fusion, enabling the integration of live Google Calendar into the building and management of effective data pipelines.
-
Connect and Query Live Facebook Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Facebook into Databricks
-
Replicate Reckon Accounts Hosted Data in Heroku for Use in Salesforce Connect
Replicate Reckon Accounts Hosted to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating GitHub Copilot CLI with Pipeline CRM via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Access Jodoo Data from MySQL in Amazon QuickSight
Connect to Jodoo and build visualizations of Jodoo using a MySQL Connection in Amazon QuickSight.
-
Automate Apify Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apify from PowerShell? This article demonstrates how to utilize the Apify Cmdlets for tasks like connecting to Apify, automating operations, downloading data, and more.
-
Analyze GitLab Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GitLab in Microsoft R Open.
-
Explore Geographical Relationships in Datadog Data with Power Map
Create data visualizations with Datadog in Power Map.
-
Seamlessly Bring Dynamics 365 Data into Retool Using CData Connect AI
Integrate Dynamics 365 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connecting Moonlit Workflow with Google Ads Data 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 Google Ads in real time.
-
Automated Continuous SAP Ariba Procurement Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Vertica.
-
Connect to Bullhorn CRM Data in Jaspersoft Studio
Execute SQL to remote Bullhorn CRM in Jaspersoft Studio.
-
Automated Continuous ZohoSubscriptions Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to delimited files (CSV/TSV).
-
Integrating Claude Code with Azure Table Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Azure Table Storage within assisted coding and automated development workflows.
-
Automated SpaceX Data Replication to Teradata
Use CData Sync to Customize and automate SpaceX replication to Teradata.
-
Use the CData Software JDBC Driver for EnterpriseDB in MicroStrategy Web
Connect to EnterpriseDB in MicroStrategy Web using the CData Software JDBC Driver for EnterpriseDB.
-
Connect to Google Campaign Manager 360 Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Campaign Manager 360 in Google Apps Script.
-
Access Google Search Results from MySQL in PHP
Connect to Google Search through the standard MySQL libraries in PHP.
-
Visualize Live FHIR Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FHIR.
-
Establish a Live Connection with TaxJar Data using Tableau Bridge
The CData ODBC Driver for TaxJar enables you to integrate live TaxJar into Tableau Cloud dashboards using the Tableau Bridge.
-
Snowflake Reporting in OBIEE with the Snowflake JDBC Driver
Deploy the Snowflake JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Dash to Build to Web Apps on Highrise Data
Create Python applications that use pandas and Dash to build Highrise-connected web apps.
-
Connecting Agentforce with QuickBooks Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your QuickBooks Online for you.
-
Working with Google Search Results in LINQPad
Execute LINQ queries to Google Search in LINQPad.
-
Connect to Greenplum Data in NetBeans
Connect to Pivotal GreenPlum in NetBeans with the data source configuration wizard.
-
Rapidly Develop Customer.io-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Customer.io.
-
Connect to Postmark in SpagoBI
Create reports featuring live Postmark in SpagoBI Studio. Host Postmark reports on SpagoBI Server.
-
Automate Active Directory Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Active Directory from PowerShell? This article demonstrates how to utilize the Active Directory Cmdlets for tasks like connecting to Active Directory, automating operations, downloading data, and more.
-
Analyze Salesforce Pardot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce Pardot from Power Pivot. You will use the Table Import Wizard to load Salesforce Pardot. You can visually build the import query or use any SQL supported by the driver.
-
Establish a Live Connection with Bullhorn CRM Data using Tableau Bridge
The CData ODBC Driver for Bullhorn CRM enables you to integrate live Bullhorn CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to GetResponse Data in DBVisualizer
Integrate GetResponse with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Semantic Layer Views for Cloudflare Data in APOS Live Data Gateway
Use the CData Connector for Cloudflare in APOS Live Data Gateway to build Semantic Layer Views for Cloudflare.
-
How to Seamlessly Import Clio Data into IBM SPSS Modeler
Integrate Clio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Edit and Search External WooCommerce Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of WooCommerce to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create WooCommerce Data objects that you can access from apps and the dashboard.
-
Create Informatica Mappings From/To a JDBC Data Source for Impala
Create Impala data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software JDBC Driver for MailerSend in MicroStrategy
Connect to MailerSend in MicroStrategy Developer using the CData Software JDBC Driver for MailerSend.
-
Connect to Asana Data in JRuby
Create a simple JRuby app with access to live Asana.
-
Getting Started with the CData ADO.NET Provider for Bannerbear
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build NetSuite-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to NetSuite CRM & ERP and build web apps with connectivity to live NetSuite CRM & ERP.
-
Build Pipelines with Live ShipStation Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ShipStation from Google Cloud Data Fusion, enabling the integration of live ShipStation into the building and management of effective data pipelines.
-
Automated Continuous Bitbucket Replication to SQLite
Use CData Sync for automated, continuous, customizable Bitbucket replication to SQLite.
-
Import Real-Time Zoho Recruit Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Recruit in ColdFusion.
-
Build Amazon Athena-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amazon Athena and build web apps with connectivity to live Amazon Athena.
-
Automate Instagram Data Replication to SAP HANA
Use CData Sync to customize and automate Instagram replication to SAP HANA.
-
Using the CData Software ODBC Driver for Foursquare in PyCharm
Connect to Foursquare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Foursquare.
-
Write a Simple Go Application to work with Telegram Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Telegram.
-
Use the CData Software ODBC Driver for Shopify in MicroStrategy Web
Connect to Shopify in MicroStrategy Web using the CData Software ODBC Driver for Shopify.
-
Analyze Flowlu Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Flowlu and visualize live Flowlu in Infragistics Reveal.
-
Use Biml to Build SSIS Tasks to Replicate Qualaroo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Qualaroo to SQL Server.
-
Connect to Oracle Financials Cloud Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle Financials Cloud from Crystal Reports.
-
How to Build an ETL App for Guru Data in Python with CData
Create ETL applications and real-time data pipelines for Guru in Python with petl.
-
Automated Continuous Reckon Accounts Hosted Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Google Cloud SQL.
-
Use Biml to Build SSIS Tasks to Replicate Monday.com Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Monday.com to SQL Server.
-
Connect to Salesforce from Asprova with CData Software ODBC Driver for Salesforce
This article shows how to connect faster to Salesforce data from Asprova.
-
Analyze ClickUp Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of ClickUp and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Google Ads Data in NetBeans
Connect to Google Ads in NetBeans with the data source configuration wizard.
-
Connect to Superchat Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Superchat and work with Superchat in your FileMaker applications.
-
Create SAP HANA XS Advanced Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP HANA XS Advanced from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous MailerLite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MailerLite replication to Apache Cassandra.
-
Work with Live Airtable Data in Power Query
Use CData Connect AI to connect to Airtable and work with live Airtable in Microsoft Power Query.
-
Publish Crystal Reports on Gumroad Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Gumroad.