CData Software - Knowledge Base
Recent Articles
-
Connect and Visualize Live GraphQL Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live GraphQL into the Databricks platform and create visualization dashboards with real-time GraphQL.
-
Integrating Cursor CLI with Instagram Data 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.
-
Connect to and Visualize Live CircleCI Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CircleCI.
-
Import SAP ByDesign Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Business ByDesign. In this article, you will use the OData format to import SAP Business ByDesign into Microsoft Power Query.
-
Visualize SQL Analysis Services Data in TIBCO Spotfire through OData
Integrate SQL Analysis Services into dashboards in TIBCO Spotfire.
-
Automated Continuous Accelo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Accelo replication to AlloyDB.
-
Edit and Search External Microsoft Exchange Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Exchange to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Exchange Data objects that you can access from apps and the dashboard.
-
Connect to Amazon S3 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amazon S3 to connect to Amazon S3 from Web applications running on WebLogic.
-
How to publish and share Scrapfly Data dashboards with Tableau Server
The CData ODBC driver for Scrapfly enables you integrate Scrapfly into Tableau dashboards.
-
Use the CData Software ODBC Driver for Wrike in MicroStrategy Web
Connect to Wrike in MicroStrategy Web using the CData Software ODBC Driver for Wrike.
-
Design BIRT Reports on Vercel Data
Provide current Vercel to your embedded analytics.
-
Prepare, Blend, and Analyze LightSpeedRetail Data in Alteryx Designer (ODBC)
Build workflows to access live LightSpeedRetail for self-service data analytics.
-
Integrating Kiro CLI with SparkPost Data 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.
-
Build Semantic Layer Views for Jira Assets Data in APOS Live Data Gateway
Use the CData Connector for Jira Assets in APOS Live Data Gateway to build Semantic Layer Views for Jira Assets.
-
Automated Continuous MailChimp Replication to Vertica
Use CData Sync for automated, continuous, customizable MailChimp replication to Vertica.
-
Import Paylocity Data Using Azure Data Factory
Use CData Connect AI to connect to Paylocity Data from Azure Data Factory and import live Paylocity.
-
Migrating data from Pipeliner CRM to Snowflake using CData SSIS Components.
Easily push Pipeliner CRM to Snowflake using the CData SSIS Tasks for Pipeliner CRM and Snowflake.
-
Create Salesforce Pardot-Connected Dashboards in Grafana
Connect to Salesforce Pardot Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Salesforce Pardot.
-
Connect to Azure Table Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Azure Table and the SQL Gateway to access Azure Table Storage from Google Apps Script.
-
Seamlessly Bring Greenplum Data into Retool Using CData Connect AI
Integrate Greenplum data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Analyze ZohoSubscriptions Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoSubscriptions in Microsoft R Open.
-
Connect to Live Cassandra Data in MicroStrategy through CData Connect AI
Create a live connection to Cassandra Data in CData Connect AI and connect to your Apache Cassandra from MicroStrategy.
-
How to create LinkedIn federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LinkedIn in MySQL .
-
Connect to Impala Data in CloverDX (formerly CloverETL)
Transfer Apache Impala using the visual workflow in the CloverDX data integration tool.
-
Build MailChimp-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for MailChimp to explore live MailChimp Data in Gemini Code Assist to assist with building MailChimp-powered applications.
-
Connect to Snapchat Ads Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Snapchat Ads and the Script function in FileMaker Pro to connect to Snapchat Ads and work with Snapchat Ads in your FileMaker application.
-
Easily Integrate Mistral AI Data in Lazarus Pascal IDE
Learn how to easily integrate live Mistral AI in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Publish Redshift-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon Redshift.
-
Query Bugsnag Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bugsnag from Node.js.
-
Integrating Kiro CLI with PDFMonkey Data 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.
-
Getting Started with the CData ODBC Driver for Twilio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Twilio.
-
Use Dash to Build to Web Apps on Landbot Data
Create Python applications that use pandas and Dash to build Landbot-connected web apps.
-
DataBind Controls to Google Cloud Storage Data in C++Builder
DataBind to Google Cloud Storage in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for Spark in MicroStrategy
Connect to Apache Spark SQL in MicroStrategy Developer using the CData Software ODBC Driver for Spark.
-
Connect to Tally Data in DBArtisan
Use wizards in DBArtisan to configure Tally ERP as a data source.
-
Build Charts with eBay Data in Clear Analytics
Create dynamic charts and perform analytics based on eBay in Clear Analytics.
-
Integrate with ActiveCampaign Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ActiveCampaign in SnapLogic.
-
Build a Simple VCL Application for Webflow Data
How to build a simple VCL Application to view Webflow in RAD Studio using the CData ODBC Driver for Webflow.
-
Rapidly Develop Outreach.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 Outreach.io.
-
DataBind Charts to Teamgate Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Teamgate 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.
-
Build Apps with Live Google Sheets Data Using the Low-Code Development Platform of Mendix
Connect Google Sheets with Mendix to build apps using the CData JDBC Driver for Google Sheets.
-
Getting Started with the CData Tableau Connector for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Dynamics 365.
-
How to connect SharePoint with Amazon DynamoDB Data through external lists
Provide Amazon DynamoDB to SharePoint users as an external list.
-
Build a Singer.io Tap for ConvertKit With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ConvertKit data using
-
Connect to Instagram in SpagoBI
Create reports featuring live Instagram in SpagoBI Studio. Host Instagram reports on SpagoBI Server.
-
Build Semantic Layer Views for Gong Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Gong.
-
Natively Connect to Gong Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Gong. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for SFTP in MicroStrategy Desktop
Connect to SFTP in MicroStrategy Desktop using the CData Software JDBC Driver for SFTP.
-
Replicate Highrise Data to Multiple Databases via the CData Sync CLI
Replicate Highrise CRM to disparate databases with a single configuration.
-
Connect to Oracle Financials Cloud Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle Financials Cloud Data and connect to Oracle Financials Cloud in Akorbi Digital RunMyProcess.
-
Automate Aweber Data Replication to Couchbase
Use CData Sync to Customize and automate Aweber replication to Couchbase.
-
Viewing ElevenLabs Data in RAD Studio Data Explorer
How to view ElevenLabs in RAD Studio Data Explorer using the CData ODBC Driver for ElevenLabs.
-
Manage Attio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Attio.
-
Use the CData Software JDBC Driver for Front in MicroStrategy Desktop
Connect to Front in MicroStrategy Desktop using the CData Software JDBC Driver for Front.
-
Use the CData ODBC Driver for Salesloft in Microsoft Power Query
You can use the CData Salesloft ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesloft into Microsoft Power Query.
-
Access Live BigCommerce Data in Excel 365 Online (Excel for the web)
Connect to BigCommerce from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Dotmailer Data Replication to Teradata
Use CData Sync to Customize and automate Dotmailer replication to Teradata.
-
How to import Odoo Data into Apache Solr
Use the CData Software JDBC Driver for Odoo in Data Import Handler and create an automated import of Odoo ERP to Apache Solr Enterprise Search platform.
-
Work with Google Tasks Data in FoxPro
Load Google Tasks into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Build an ETL App for Square Data in Python with CData Connect AI
Build ETL pipelines that read and write live Square in Python with petl and the CData Connect AI Python SDK.
-
Create Informatica Mappings From/To a JDBC Data Source for Drip
Create Drip data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Choosing the Best Method to Connect OnePageCrm to SQL Server: 5 Options Explained
Discover multiple ways to connect and use OnePageCrm from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Sendwithus-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sendwithus and build web apps with connectivity to live Sendwithus.
-
Model, Search, and Visualize Live Zoho Inventory Data in ThoughtSpot
Use CData Connect AI to connect to live Zoho Inventory for modeling, searching, and visualizing.
-
Integrate Strava with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Strava with External Services.
-
Connect to EnterpriseDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live EnterpriseDB.
-
Query Act CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Act CRM from Node.js.
-
Deploy the ADO.NET Provider for Slack on an SSRS Report Server
Connect to Slack 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.
-
Access Live Amazon Marketplace Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Marketplace from your Excel spreadsheets.
-
How to Seamlessly Import Amazon S3 Data into IBM SPSS Modeler
Integrate Amazon S3 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish Crystal Reports on Sentry Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sentry.
-
Integrate Raisers Edge NXT Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Raisers Edge NXT and integrate live Raisers Edge NXT into your Power Automate tasks.
-
Create Amazon DynamoDB-Connected Business Apps in AppSheet
Connect to Amazon DynamoDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon DynamoDB.
-
Using the CData Software ODBC Driver for Outlook in PyCharm
Connect to Outlook as an ODBC data source in PyCharm using the CData Software ODBC Driver for Outlook.
-
Extract, Transform, and Load Humanity Data in Informatica PowerCenter
Create a simple Workflow for Humanity in Informatica PowerCenter.
-
Automated Continuous Oracle SCM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle SCM replication to SingleStore.
-
Connect to Cvent Data from Crystal Reports
Use CData Connect AI to connect to and report on live Cvent from Crystal Reports.
-
Connect to ScrapingBee in SpagoBI
Create reports featuring live ScrapingBee in SpagoBI Studio. Host ScrapingBee reports on SpagoBI Server.
-
Automated Continuous Eventbrite Replication to Vertica
Use CData Sync for automated, continuous, customizable Eventbrite replication to Vertica.
-
Visualize Live EmailOctopus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live EmailOctopus.
-
Create Informatica Mappings From/To a JDBC Data Source for Tally
Create Tally data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Moving Data from Drip to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Drip data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Google Sheets Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Sheets from HeidiSQL.
-
Use JayDeBeApi to access Gumroad Data in Python
Use standard Python scripting and the development environment of your choice to access live Gumroad.
-
How to Work with HCL Domino Data in AWS Glue Jobs Using JDBC
Connect to HCL Domino from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Informatica Mappings From/To an ODBC Data Source for Avro
Create an ODBC connection to Avro in Informatica and browse and transfer Apache Avro.
-
DataBind Controls to SAP Business One Data in C++Builder
DataBind to SAP Business One in C++Builder with standard components and controls.
-
Connect to Monday.com Data in ACL Analytics
Connect to Monday.com via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Monday.com.
-
Connect to Billsby Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Billsby as an External Source in Dremio.
-
Use the CData Software ODBC Driver for Hacker News in SAS for Real-Time Reporting and Analytics
Connect to real-time Hacker News in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Hacker News.
-
Use the CData Software JDBC Driver for Mixpanel in MicroStrategy
Connect to Mixpanel in MicroStrategy Developer using the CData Software JDBC Driver for Mixpanel.
-
Automate Teamwork Data Replication to Couchbase
Use CData Sync to Customize and automate Teamwork replication to Couchbase.
-
Use Dash to Build to Web Apps on Microsoft OneDrive Data
Create Python applications that use pandas and Dash to build Microsoft OneDrive-connected web apps.
-
Automated Continuous Sendwithus Replication to Oracle
Use CData Sync for automated, continuous, customizable Sendwithus replication to Oracle.
-
ETL Humanity in Oracle Data Integrator
This article shows how to transfer Humanity into a data warehouse using Oracle Data Integrator.
-
How to Seamlessly Import SAP HANA XS Advanced Data into IBM SPSS Modeler
Integrate SAP HANA XS Advanced data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Prepare, Blend, and Analyze MongoDB Data in Alteryx Designer (Connect AI)
Build workflows to access live MongoDB for self-service data analytics.
-
Analyze Square Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Square and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous VWO Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable VWO replication to PostgreSQL.
-
Integrating Dataiku with Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Authorize.Net.