CData Software - Knowledge Base
Recent Articles
-
How to Access Live Spotify Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Spotify enables you to integrate Spotify data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Zendesk Replication to SQLite
Use CData Sync for automated, continuous, customizable Zendesk replication to SQLite.
-
Access Cvent Data from MySQL in PHP
Connect to Cvent through the standard MySQL libraries in PHP.
-
Replicate QuickBooks Online Data to Multiple Databases
Replicate QuickBooks Online data to disparate databases with a point-and-click configuration.
-
Automated Continuous SAP Concur Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP Concur replication to IBM DB2.
-
Build a Singer.io Tap for SAP Ariba Source With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Ariba Source data using the CData Python Connector.
-
Integrate Discord Data into Power Automate Desktop using CData Connect
CData Connect for Discord Data enables you to integrate Discord data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Microsoft Planner from Asprova with CData Software ODBC Driver for Microsoft Planner
This article shows how to connect faster to Microsoft Planner data from Asprova.
-
Build Apps with Live AgileCRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live AgileCRM data into the Adalo platform and build custom mobile and web applications with real-time AgileCRM data.
-
Provide OData Services of Float Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Float data by developing a WCF Service Application.
-
Integrating Codex with Omnisend 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.
-
How to Query Live Templated Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Templated data data in natural language using Python.
-
Replicate EnterpriseDB Data in Heroku for Use in Salesforce Connect
Replicate EnterpriseDB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Informatica Mappings From/To an ODBC Data Source for SAS xpt
Create an ODBC connection to SAS xpt in Informatica and browse and transfer SAS xpt data.
-
How to use SQLAlchemy ORM to access Google Tasks Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Tasks data.
-
Extract, Transform, and Load Dynamics CRM Data in Informatica PowerCenter
Create a simple Workflow for Dynamics CRM data in Informatica PowerCenter.
-
Build Data Flows from Dynamics 365 to SQL Server using SSIS
Easily back up Dynamics 365 data to SQL Server using the SSIS components for Dynamics 365.
-
A PostgreSQL Interface for Factorial Data (MySQL Remoting via JDBC)
Use the Remoting features of the Factorial JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind ActiveCampaign Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for ActiveCampaign with the DevExpress Windows Forms and Web controls to provide ActiveCampaign data to a chart.
-
Prepare, Blend, and Analyze Zoho Inventory Data in Alteryx Designer (ODBC)
Build workflows to access live Zoho Inventory data for self-service data analytics.
-
Integrate Google's Vertex AI Agent with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Apollo data within intelligent workflows.
-
Automate CapsuleCRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CapsuleCRM data from PowerShell? This article demonstrates how to utilize the CapsuleCRM Cmdlets for tasks like connecting to CapsuleCRM data, automating operations, downloading data, and more.
-
Automated Continuous Amazon S3 Replication to Vertica
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Vertica.
-
Use JayDeBeApi to access Moosend Data in Python
Use standard Python scripting and the development environment of your choice to access live Moosend data.
-
Build Dashboards with Slack Data in DBxtra
Create dynamic dashboards and perform analytics based on Slack data in DBxtra.
-
Access MongoDB Data from MySQL in PHP
Connect to MongoDB through the standard MySQL libraries in PHP.
-
Create Informatica Mappings From/To a JDBC Data Source for Xero
Create Xero data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to and Visualize Live Humanity Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Humanity data.
-
Moving Data from SAP ByDesign to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP ByDesign data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create SSAS Tabular Models from ElevenLabs Data
How to build a SQL Server Analysis Service Tabular Model from ElevenLabs data using CData drivers.
-
Query Google Contacts Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Contacts entities in PHP by modeling them as objects.
-
Use JayDeBeApi to access Adobe Experience Manager Data in Python
Use standard Python scripting and the development environment of your choice to access live Adobe Experience Manager data.
-
Automate Helpscout Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Helpscout data from PowerShell? This article demonstrates how to utilize the Helpscout Cmdlets for tasks like connecting to Helpscout data, automating operations, downloading data, and more.
-
Build ActiveCampaign-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ActiveCampaign data.
-
How to work with Omnisend Data in Apache Spark using SQL
Access and process Omnisend Data in Apache Spark using the CData Software JDBC Driver.
-
Build an OLAP Cube in SSAS from Copper Data
Establish a connection to Copper data data from SQL Server Analysis Services, and use the Copper Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Amazon S3-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amazon S3 data.
-
Build an OLAP Cube in SSAS from Salesforce Data 360 Data
Establish a connection to Salesforce Data 360 data data from SQL Server Analysis Services, and use the Salesforce Data 360 Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Access Live PDFMonkey Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PDFMonkey enables you to integrate PDFMonkey data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Cursor with Retently 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.
-
Integrating Antigravity CLI with MongoDB data via CData CLI
Connect MongoDB data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a Simple VCL Application for Teamgate Data
How to build a simple VCL Application to view Teamgate data in RAD Studio using the CData ODBC Driver for Teamgate.
-
Connect to Live Microsoft Exchange Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft Exchange in CData Connect AI and connect to your Microsoft Exchange data from PostgreSQL.
-
Visualize PayPal Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load PayPal data into TIBCO Spotfire.
-
Automated Continuous Toggl Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Toggl replication to delimited files (CSV/TSV).
-
View Reports on Real-Time PingOne Data in Power BI Report Server
Use the CData ODBC Driver for PingOne to visualize PingOne data in Power BI Desktop and then publish them to Power BI Report Server.
-
Search External Twitter Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Twitter Ads data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Twitter Ads Data objects that you can access from apps and the dashboard.
-
A PostgreSQL Interface for Facebook Data using the CData ODBC Driver
Use the SQL Gateway and Facebook ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Charts with BambooHR Data in Clear Analytics
Create dynamic charts and perform analytics based on BambooHR data in Clear Analytics.
-
How to Access Sage 200 Data Using Entity Framework
This article shows how to access Sage 200 data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect DBeaver to Brex via a JDBC Driver
Manage Brex data with visual tools in DBeaver like the query browser.
-
How to Connect the Power BI Service to Greenplum: Complete Guide
Connect to the CData Software Power BI Connector for Greenplum from PowerBI.com to provide real-time Greenplum data across the organization.
-
Connect to RSS from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from RSS feeds, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Freshsales Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Freshsales and the SQL Gateway to access Freshsales data from Google Apps Script.
-
Validate SFTP Data with QuerySurge
Access and validate SFTP data in QuerySurge using the CData JDBC Driver.
-
How to Easily Query Strava Data in OpenOffice Base
Connect to Strava data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect to Power BI XMLA Data from Spring Boot
Connect to Power BI XMLA in a Spring Boot Application using the CData JDBC Driver for Power BI XMLA
-
Use the CData Software JDBC Driver for SharePoint Excel Services in MicroStrategy Desktop
Connect to SharePoint Excel Services data in MicroStrategy Desktop using the CData Software JDBC Driver for SharePoint Excel Services.
-
How to connect to Greenplum Data from Spring Boot
Connect to Greenplum in a Spring Boot Application using the CData JDBC Driver for Greenplum
-
How to publish and share Sage Intacct Data dashboards with Tableau Server
The CData ODBC driver for Sage Intacct enables you integrate Sage Intacct data into Tableau dashboards.
-
Connect to Azure Data Lake Storage Data in ACL Analytics
Connect to Azure Data Lake Storage data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure Data Lake Storage data.
-
Connect to Webflow Data from a Connection Pool in JBoss
Integrate Webflow data into Java servlets: Use the Management Console in JBoss to install the Webflow JDBC Driver.
-
Migrating data from SAP Hybris C4C to Databricks using CData SSIS Components.
Easily push SAP Hybris C4C data to Databricks using the CData SSIS Tasks for SAP Hybris C4C and Databricks.
-
Migrating data from Impala to Databricks using CData SSIS Components.
Easily push Impala data to Databricks using the CData SSIS Tasks for Impala and Databricks.
-
Bridge Intercom Connectivity with Apache NiFi
Access and process Intercom data in Apache NiFi using the CData JDBC Driver.
-
Automate LinkedIn Ads Data Replication to Couchbase
Use CData Sync to Customize and automate LinkedIn Ads data replication to Couchbase.
-
Analyze Live DocuSign Data in SAS Viya
Use CData Connect AI to connect to DocuSign data from SAS Viya and deploy self-service analytics using live DocuSign data.
-
Integrate OpenCode with Live Salesforce Marketing Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Salesforce Marketing data from within your AI coding agent.
-
How to Connect to Live AfterShip Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your AfterShip data through natural language.
-
Build a Simple VCL Application for Power BI XMLA Data
How to build a simple VCL Application to view Power BI XMLA data in RAD Studio using the CData ODBC Driver for Power BI XMLA.
-
Build Pipelines with Live Square Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Square from Google Cloud Data Fusion, enabling the integration of live Square data into the building and management of effective data pipelines.
-
Visualize Live Sugar CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sugar CRM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Choosing the Best Method to Connect SAP HANA to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP HANA data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Import and Visualize Nethunt Data in Power View
Create data visualizations based on Nethunt data in Excel.
-
Use Dash to Build to Web Apps on SendInBlue Data
Create Python applications that use pandas and Dash to build SendInBlue-connected web apps.
-
Build MVC Applications with Connectivity to Discord Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Discord from an ASP.NET MVC application.
-
Connect to Trello Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Trello as an External Source in Dremio.
-
Access Live Adobe Analytics Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Adobe Analytics data from your Google Sheets.
-
Excel Spreadsheet Automation on Amplitude Data with the QUERY Formula
Pull data from Amplitude, automate spreadsheets, and more with the QUERY formula.
-
Use JayDeBeApi to access Avro Data in Python
Use standard Python scripting and the development environment of your choice to access live Avro data.
-
Access Live Zoho Recruit Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho Recruit data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to & Open SAP Hybris C4C Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Hybris C4C to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Biml to Build SSIS Tasks to Replicate Mouseflow Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mouseflow data to SQL Server.
-
How to Connect to Live Greenplum Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Greenplum data securely in real time.
-
Integrating Cursor with ZarMoney 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.
-
Create Data Visualizations in Cognos BI with EmailOctopus Data
Access EmailOctopus data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Charts to PabblySubscriptions Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PabblySubscriptions data 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.
-
Access Live Snowflake Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Snowflake data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Drip-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Drip data and build web apps with connectivity to live Drip data.
-
Replicate Multiple PhantomBuster Accounts via the CData Sync CLI
Replicate multiple PhantomBuster accounts to one or many databases.
-
Connect to Live Paylocity Data in MicroStrategy through CData Connect AI
Create a live connection to Paylocity Data in CData Connect AI and connect to your Paylocity data from MicroStrategy.
-
Build Pushbullet-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Pushbullet data and build web apps with connectivity to live Pushbullet data.
-
Connect to EmailOctopus Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to EmailOctopus and work with EmailOctopus data in your FileMaker application.
-
Integrating Antigravity CLI with Mailjet data via CData CLI
Connect Mailjet data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Shopify Data from HeidiSQL
Use CData Connect AI to connect to and query live Shopify data from HeidiSQL.
-
Integrate SendInBlue Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SendInBlue data from Informatica Cloud.
-
Analyze Live Yelp Data in SAS Viya
Use CData Connect AI to connect to Yelp data from SAS Viya and deploy self-service analytics using live Yelp data.
-
Automated Continuous Kafka Replication to MySQL
Use CData Sync for automated, continuous, customizable Kafka replication to MySQL.
-
Analyze Google Calendar Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Calendar from Power Pivot. You will use the Table Import Wizard to load Google Calendar data. You can visually build the import query or use any SQL supported by the driver.
-
Create Datasets from Azure Synapse in Domo Workbench and Build Visualizations of Azure Synapse Data in Domo
Use the CData Software ODBC Driver for Azure Synapse to create datasets from Azure Synapse data in Domo Workbench and then build visualizations in the Domo service.