CData Software - Knowledge Base
Recent Articles
-
Automated Calendly Data Replication to Teradata
Use CData Sync to Customize and automate Calendly data replication to Teradata.
-
Access Live Gmail Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Gmail data from your Excel spreadsheets.
-
Visualize Live Excel Online Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Excel Online data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a Simple VCL Application for Wistia Data
How to build a simple VCL Application to view Wistia data in RAD Studio using the CData ODBC Driver for Wistia.
-
Integrating Gumloop with SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SQL Analysis Services data within automated workflows.
-
Configure the CData JDBC Driver for Teamwork in a Connection Pool in Tomcat
Connect to Teamwork data from a connection pool in Tomcat.
-
Migrating data from Salesforce Pardot to Snowflake using CData SSIS Components.
Easily push Salesforce Pardot data to Snowflake using the CData SSIS Tasks for Salesforce Pardot and Snowflake.
-
How to Connect to Live GraphQL Data 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 GraphQL data for you.
-
Integrating Antigravity CLI with MarkLogic data via CData CLI
Connect MarkLogic data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Automated Workflows with Live Snowflake Data in Workato
Use CData Connect AI to connect to live Snowflake data and build automated workflows in Workato.
-
Build Shopify Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Shopify data and build visualizations in Tableau Cloud.
-
Replicate Paymo Data in Heroku for Use in Salesforce Connect
Replicate Paymo data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Seamlessly Import PhantomBuster Data into IBM SPSS Modeler
Integrate PhantomBuster data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Manage Tally Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Tally.
-
Excel Spreadsheet Automation on Dynamics 365 Data with the QUERY Formula
Pull data from Dynamics 365, automate spreadsheets, and more with the QUERY formula.
-
Connect to Dynamics 365 Business Central Data in HULFT Integrate
Connect to Dynamics 365 Business Central as a JDBC data source in HULFT Integrate
-
Connect to and Visualize Live Impala Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Impala data.
-
Connecting Moonlit Workflow with Certinia 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 Certinia data in real time.
-
ETL Hubstaff in Oracle Data Integrator
This article shows how to transfer Hubstaff data into a data warehouse using Oracle Data Integrator.
-
Visualize Microsoft Teams Data in TIBCO Spotfire through OData
Integrate Microsoft Teams data into dashboards in TIBCO Spotfire.
-
ETL Mocean in Oracle Data Integrator
This article shows how to transfer Mocean data into a data warehouse using Oracle Data Integrator.
-
Connect to Microsoft Entra ID Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Entra ID data.
-
Use the CData Software ODBC Driver for ActiveCampaign in MicroStrategy
Connect to ActiveCampaign data in MicroStrategy Developer using the CData Software ODBC Driver for ActiveCampaign.
-
Automate FreeAgent Integration Tasks from PowerShell
Are you in search of a quick and easy way to access FreeAgent data from PowerShell? This article demonstrates how to utilize the FreeAgent Cmdlets for tasks like connecting to FreeAgent data, automating operations, downloading data, and more.
-
Publish Aha!-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Aha! data.
-
Create Datasets from ChargeOver in Domo Workbench and Build Visualizations of ChargeOver Data in Domo
Use the CData Software ODBC Driver for ChargeOver to create datasets from ChargeOver data in Domo Workbench and then build visualizations in the Domo service.
-
Use Dash to Build to Web Apps on Cloudant Data
Create Python applications that use pandas and Dash to build Cloudant-connected web apps.
-
How to integrate Metabase with GetResponse Data
Use CData Connect AI to connect to live GetResponse data and create an interactive dashboard in Metabase from GetResponse data.
-
Build Dashboards with PolarTeamPro Data in Dundas BI
Create dynamic dashboards and perform analytics based on PolarTeamPro data in Dundas BI.
-
LINQ to Testmonitor 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 Testmonitor Data Provider.
-
Automated Continuous ChartMogul Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ChartMogul data replication to OneLake in Microsoft Fabric.
-
Model Neo4J Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Neo4J, enabling the direct import of real-time Neo4J data.
-
Create Klaviyo-Connected Nintex Workflows
Use CData Connect AI to connect to Klaviyo Data from Nintex Workflow Cloud and build custom workflows using live Klaviyo data.
-
Use Dash to Build to Web Apps on PhantomBuster Data
Create Python applications that use pandas and Dash to build PhantomBuster-connected web apps.
-
Integrating Boomi Agentstudio with Authorize.Net Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Authorize.Net data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Active Directory Replication to Databricks
Use CData Sync for automated, continuous, customizable Active Directory replication to Databricks.
-
Excel Spreadsheet Automation on PayPal Data with the QUERY Formula
Pull data from PayPal, automate spreadsheets, and more with the QUERY formula.
-
Validate Sage Cloud Accounting Data with QuerySurge
Access and validate Sage Cloud Accounting data in QuerySurge using the CData JDBC Driver.
-
Automate Greenplum Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Greenplum data from PowerShell? This article demonstrates how to utilize the Greenplum Cmdlets for tasks like connecting to Greenplum data, automating operations, downloading data, and more.
-
How to Connect to Live SageHR Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SageHR data securely in real time.
-
Integrate Devin with Live Zoom Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Zoom data.
-
Create Informatica Mappings From/To an ODBC Data Source for ServiceNow
Create an ODBC connection to ServiceNow in Informatica and browse and transfer ServiceNow data.
-
Create Data Visualizations Based On Jira Assets Data in Mode
Use CData Connect AI to connect to Jira Assets Data from Mode and build visualizations using live Jira Assets data.
-
Integrate Theia IDE with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Microsoft Entra ID data from within the development environment.
-
Enable the Recurly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Recurly data.
-
Create Microsoft Planner-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Planner Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Planner data.
-
Automated Continuous SAS xpt Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAS xpt replication to MongoDB.
-
Connect to Landbot Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Landbot and the SQL Gateway to access Landbot data from Google Apps Script.
-
Connecting Mastra with Google Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Ads data, no replication required.
-
Automated Continuous Sage Intacct Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage Intacct replication to PostgreSQL.
-
Create SSAS Tabular Models from Zoho Recruit Data
How to build a SQL Server Analysis Service Tabular Model from Zoho Recruit data using CData drivers.
-
Integrating Antigravity CLI with FormSite data via CData CLI
Connect FormSite data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Import Real-Time Email Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Email data in ColdFusion.
-
Configure the CData JDBC Driver for LaunchDarkly in a Connection Pool in Tomcat
Connect to LaunchDarkly data from a connection pool in Tomcat.
-
Create Power BI Reports on Real-Time LinkedIn Data
Use the CData ODBC Driver for LinkedIn to visualize LinkedIn data in Power BI Desktop.
-
Access PhantomBuster Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for PhantomBuster data.
-
Build Automated Workflows with Live Wave Financial Data in Workato
Use CData Connect AI to connect to live Wave Financial data and build automated workflows in Workato.
-
Bidirectional Access to Snowflake Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Snowflake data in Filemaker Pro for Mac or Windows.
-
Integrating Boomi Agentstudio with Twitter Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Twitter Ads data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Oracle Eloqua Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Oracle Eloqua.
-
Integrate Real-Time Access to SuiteCRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SuiteCRM data in real time.
-
Integrate BenchmarkEmail with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BenchmarkEmail with External Services.
-
Connect to PolarTeamPro Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PolarTeamPro and work with PolarTeamPro data in your FileMaker applications.
-
How to connect to Stack Exchange Data from Spring Boot
Connect to Stack Exchange in a Spring Boot Application using the CData API Driver for JDBC
-
Operational Reporting on Pushbullet Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pushbullet data.
-
Build Data Flows from ClickTime to SQL Server using SSIS
Easily back up ClickTime data to SQL Server using the SSIS components for ClickTime.
-
A PostgreSQL Interface for Wistia Data using the CData ODBC Driver
Use the SQL Gateway and Wistia ODBC Driver to create a PostgreSQL entry-point for data access.
-
Edit and Search External Zoho Inventory Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zoho Inventory data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zoho Inventory Data objects that you can access from apps and the dashboard.
-
Integrating Zoho Projects Data in Talend Cloud Data Management Platform
Connect Zoho Projects Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zoho Projects.
-
How to Connect to Azure Data Lake Storage Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Azure Data Lake Storage data. Leverage the pyodbc module for ODBC in Python.
-
A PostgreSQL Interface for Brex Data using the CData ODBC Driver
Use the SQL Gateway and Brex ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Datasets from Samanage in Domo Workbench and Build Visualizations of Samanage Data in Domo
Use the CData Software ODBC Driver for Samanage to create datasets from Samanage data in Domo Workbench and then build visualizations in the Domo service.
-
Seamlessly Bring Pinterest Data into Retool Using CData Connect AI
Integrate Pinterest data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Apollo Data in DataGrip
Create a Data Source for Apollo in DataGrip and use SQL to query live Apollo data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Rebilly
Provide connectivity to Rebilly data through an SAP BusinessObjects universe.
-
Create Reports with Redshift Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redshift data.
-
Easily Integrate Facebook Data in Lazarus Pascal IDE
Learn how to easily integrate live Facebook data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous DB2 for i Replication to Amazon S3
Use CData Sync for automated, continuous, customizable DB2 for i replication to Amazon S3.
-
Adobe Target Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Adobe Target facts in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for Bright Data
Create Bright Data data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Informatica Mappings From/To an ODBC Data Source for SendGrid
Create an ODBC connection to SendGrid in Informatica and browse and transfer SendGrid data.
-
Connect and Visualize Live Salesforce Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce data into the Databricks platform and create visualization dashboards with real-time Salesforce data.
-
How to Connect to Live Email Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Email data for you.
-
How to use SQLAlchemy ORM to access LinkedIn Ads Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LinkedIn Ads data.
-
Rapidly Develop Asana-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 Asana.
-
Use the CData Software ODBC Driver for OneNote in MicroStrategy Desktop
Connect to OneNote data in MicroStrategy Desktop using the CData Software ODBC Driver for OneNote.
-
Trigger CockroachDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for CockroachDB with standard wizards in Logic Apps.
-
How to connect to Bitly Data with Squirrel SQL client
Connect to Bitly data and execute queries in the Squirrel SQL Client.
-
Integrate MarkLogic Data in the Pentaho Report Designer
Publish reports based on MarkLogic data in the Pentaho BI tool.
-
Use Agno to Talk to Your Google Calendar 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 Google Calendar data for you.
-
Access Epicor Kinetic Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Epicor Kinetic data from HeidiSQL.
-
Work with Azure Synapse Data in FoxPro
Load Azure Synapse data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Insightly Data in JReport Designer
Create charts and reports based on Insightly data in JReport Designer.
-
Access Live BenchmarkEmail Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live BenchmarkEmail data through MCP integration.
-
Create Superchat Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Superchat data access from reports, embedded analytics, and more.
-
Create Figshare-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Figshare Data from Klipfolio and build custom visualizations using live Figshare data.
-
Visualize MySQL Data in TIBCO Spotfire through OData
Integrate MySQL data into dashboards in TIBCO Spotfire.
-
Create Data Visualizations Based On Google Directory Data in Mode
Use CData Connect AI to connect to Google Directory Data from Mode and build visualizations using live Google Directory data.
-
Build a Simple VCL Application for Guru Data
How to build a simple VCL Application to view Guru data in RAD Studio using the CData ODBC Driver for Guru.
-
How to Access Live Ontraport Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Ontraport enables you to integrate Ontraport data into workflows built using Microsoft Power Automate Desktop.