CData Software - Knowledge Base
Recent Articles
-
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.
-
Connect SendInBlue Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SendInBlue data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to GitLab Data as an External Source in Dremio
Use the CData JDBC Driver to connect to GitLab as an External Source in Dremio.
-
Automated Continuous SAP Business One Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Business One replication to AlloyDB.
-
Connect to Tally Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Tally Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build SAP SuccessFactors-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP SuccessFactors data and build web apps with connectivity to live SAP SuccessFactors data.
-
Automated Continuous NetSuite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NetSuite replication to Azure SQL Database.
-
Connect to BenchmarkEmail 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 BenchmarkEmail and work with BenchmarkEmail data in your FileMaker application.
-
Integrate Simplesat Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Simplesat data from Informatica Cloud.
-
Connecting Agentforce with Blackbaud FE NXT 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 Blackbaud FE NXT data for you.
-
Connect to Facebook Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Facebook Ads data from Filemaker Pro on Mac.
-
Query ZohoExpense Data as a SQL Server Database in Node.js
Execute SQL Server queries against ZohoExpense data from Node.js.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Apache Cassandra.
-
Access PhantomBuster Data from MySQL in Amazon QuickSight
Connect to PhantomBuster and build visualizations of PhantomBuster data using a MySQL Connection in Amazon QuickSight.
-
How to update Act-On from Excel
This article explains how to transfer data from Excel to Act-On using the Excel Add-In for Act-On.
-
Connect to Live Adobe Target Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Adobe Target in CData Connect AI and connect to your Adobe Target data from PostgreSQL.
-
Import Real-Time Email Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Email data in ColdFusion.
-
Replicate Multiple ElevenLabs Accounts
Replicate multiple ElevenLabs accounts to one or many databases.
-
Automated Continuous Grafana Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Grafana replication to Azure SQL Database.
-
Build Dashboards with Amazon DynamoDB Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon DynamoDB data in DBxtra.
-
Replicate Multiple Presto Accounts via the CData Sync CLI
Replicate multiple Presto accounts to one or many databases.
-
Integrate Dify with Live Azure DevOps Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Azure DevOps data.
-
Build Agents in Relevance AI with Access to Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Facebook data within intelligent agent workflows.
-
Trigger Box IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Box with standard wizards in Logic Apps.
-
Build a Simple VCL Application for Zuora Data
How to build a simple VCL Application to view Zuora data in RAD Studio using the CData ODBC Driver for Zuora.
-
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
-
Prepare, Blend, and Analyze Cosmos DB Data in Alteryx Designer (ODBC)
Build workflows to access live Cosmos DB data for self-service data analytics.
-
Explore Geographical Relationships in Odoo Data with Power Map
Create data visualizations with Odoo data in Power Map.
-
Building Dynamic Web Pages with Google Analytics Data Using AngularJS
Create single-page applications with live connectivity to Google Analytics using the CData API Server.
-
Integrate Google's Vertex AI Agent with Live Jumpseller 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 Jumpseller data within intelligent workflows.
-
Build AI Agents with SFTP Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SFTP data through CData Connect AI.
-
View Reports on Real-Time ServiceNow Data in Power BI Report Server
Use the CData ODBC Driver for ServiceNow to visualize ServiceNow data in Power BI Desktop and then publish them to Power BI Report Server.
-
Building Dynamic Web Pages with Microsoft Exchange Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Exchange using the CData API Server.
-
Automated Continuous Slack Replication to MySQL
Use CData Sync for automated, continuous, customizable Slack replication to MySQL.
-
Getting Started with the CData Excel Add-In for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics CRM.
-
Integrating Gumloop with Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Eloqua data within automated workflows.
-
Replicate Marketo Data to Multiple Databases
Replicate Marketo data to disparate databases with a point-and-click configuration.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Rebilly
Provide connectivity to Rebilly data through an SAP BusinessObjects universe.
-
Build ChargeOver-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ChargeOver data and build web apps with connectivity to live ChargeOver data.
-
Connect to and Query SpaceX Data in QlikView over ODBC
Create data visualizations with SpaceX data in QlikView.
-
Automated Continuous Splunk Replication to SQL Server
Use CData Sync for automated, continuous, customizable Splunk replication to SQL Server.
-
DataBind Charts to Google Campaign Manager 360 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Campaign Manager 360 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.
-
Connecting Moonlit Workflow with SAP HANA 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 SAP HANA data in real time.
-
Migrating data from RSS to Google BigQuery using CData SSIS Components.
Easily push RSS feeds to Google BigQuery using the CData SSIS Tasks for RSS and Google BigQuery.
-
Build Apps with Live Klaviyo data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Klaviyo data into the Adalo platform and build custom mobile and web applications with real-time Klaviyo data.
-
Getting Started with the CData Tableau Connector for VWO
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous BenchmarkEmail Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Azure SQL Database.
-
Trigger CockroachDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for CockroachDB with standard wizards in Logic Apps.
-
Create Dynamic Monday.com Grids Using the Infragistics XamDataGrid
Learn how you can connect Monday.com to Infragistics XamDataGrid to build dynamic grids.
-
How to connect SharePoint with Microsoft OneDrive Data through external lists
Provide Microsoft OneDrive data to SharePoint users as an external list.
-
Natively Connect to LightSpeedRetail Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LightSpeedRetail data. Leverage the native support for ODBC in PHP.
-
Publish SurveyMonkey-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SurveyMonkey data.
-
Integrate MessageBird Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MessageBird data from Informatica Cloud.
-
How to load Hugging Face data into Elasticsearch via Logstash
Introducing a simple method to load Hugging Face data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Automated Workflows with Live Google Drive Data in Workato
Use CData Connect AI to connect to live Google Drive data and build automated workflows in Workato.
-
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.
-
Configure the CData JDBC Driver for Nethunt in a Connection Pool in Tomcat
Connect to Nethunt data from a connection pool in Tomcat.
-
Back Up Presto data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Presto. In this article, we will employ an SSIS workflow to populate a database with Presto data data.
-
Connect to Insightly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Insightly.
-
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.
-
Import Real-Time Qualaroo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Qualaroo data in ColdFusion.
-
Publish Dynamics 365-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Dynamics 365 data.
-
Integrate Microsoft Planner Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Planner data in the Pentaho Data Integration tool.
-
Connect and Visualize Live Twitter Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Twitter Ads data into the Databricks platform and create visualization dashboards with real-time Twitter Ads data.
-
Excel Spreadsheet Automation on Microsoft Planner Data with the QUERY Formula
Pull data from Microsoft Planner, automate spreadsheets, and more with the QUERY formula.
-
Build Pipelines with Live QuickBooks Time Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to QuickBooks Time from Google Cloud Data Fusion, enabling the integration of live QuickBooks Time data into the building and management of effective data pipelines.
-
Use the CData Software ODBC Driver for Phoenix in MicroStrategy Web
Connect to Phoenix data in MicroStrategy Web using the CData Software ODBC Driver for Phoenix.
-
Automated Continuous Apify Replication to MySQL
Use CData Sync for automated, continuous, customizable Apify replication to MySQL.
-
Back Up Vault CRM data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Vault CRM. In this article, we will employ an SSIS workflow to populate a database with Vault CRM data data.
-
Use the CData ODBC Driver for Active Directory from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Active Directory to connect to Active Directory data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Active Directory data in Excel.
-
Create Power BI Reports on Real-Time Hubstaff Data
Use the CData ODBC Driver for Hubstaff to visualize Hubstaff data in Power BI Desktop.
-
Create Data Visualizations in Cognos BI with CloudConvert Data
Access CloudConvert data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Reports with Cosmos DB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cosmos DB data.
-
Visualize Tally Data in TIBCO Spotfire through OData
Integrate Tally data into dashboards in TIBCO Spotfire.
-
Connect to Onfleet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Onfleet to connect to Onfleet data from Web applications running on WebLogic.
-
Build a Singer.io Tap for Contentful With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Contentful data using the CData Python Connector.
-
Automated Continuous Zoom Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoom replication to Google Cloud SQL.
-
How to Connect to Mailjet Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mailjet data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Shopify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Shopify replication to SQL Server.
-
Choosing the Best Method to Connect ClickUp to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ClickUp data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Gmail Data in ACL Analytics
Connect to Gmail data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Gmail data.
-
Replicate QuickBooks Online Data from PowerShell
Write a quick PowerShell script to query QuickBooks Online data. Use connectivity to the live data to replicate QuickBooks Online data to SQL Server.
-
Automated Redis Data Replication to Teradata
Use CData Sync to Customize and automate Redis data replication to Teradata.
-
Build a PostgreSQL Interface for CockroachDB Data using the CData JDBC Driver
Use the Remoting features of the CockroachDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Cassandra in MicroStrategy Desktop
Connect to Cassandra data in MicroStrategy Desktop using the CData Software ODBC Driver for Cassandra.
-
Import Real-Time Zoho Recruit Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Recruit data in ColdFusion.
-
Publish Google Ad Manager-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Ad Manager data.
-
Replicate Multiple Azure Synapse Accounts
Replicate multiple Azure Synapse accounts to one or many databases.
-
Connect to Act CRM Data in HULFT Integrate
Connect to Act CRM as a JDBC data source in HULFT Integrate
-
Integrating OpenCode with Zendesk 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.
-
Back Up Figshare data 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 Figshare data data.
-
Connect to Apify Data from AWS Glue
Use CData Connect AI to gain access to live Apify data from your AWS Glue jobs.
-
How to Connect DBeaver to SingleStore via a JDBC Driver
Manage SingleStore data with visual tools in DBeaver like the query browser.
-
LINQ to Autopilot 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 Autopilot Data Provider.
-
Design BIRT Reports on SAP SuccessFactors Data
Provide current SAP SuccessFactors data to your embedded analytics.
-
Create Power BI Reports on Real-Time Databricks Data
Use the CData ODBC Driver for Databricks to visualize Databricks data in Power BI Desktop.
-
Automated Continuous Sendwithus Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sendwithus replication to Apache Cassandra.
-
How to connect to Gong Data from Spring Boot
Connect to Gong in a Spring Boot Application using the CData API Driver for JDBC
-
Migrating data from Dynamics 365 Business Central to Databricks using CData SSIS Components.
Easily push Dynamics 365 Business Central data to Databricks using the CData SSIS Tasks for Dynamics 365 Business Central and Databricks.