CData Software - Knowledge Base
Recent Articles
-
Connect to SAP SuccessFactors LMS Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP SuccessFactors LMS using standard SQL.
-
Build Automated Workflows with Live Google Drive Data in Workato
Use CData Connect AI to connect to live Google Drive and build automated workflows in Workato.
-
Access Float 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 Float.
-
Access Mode Data from MySQL in Amazon QuickSight
Connect to Mode and build visualizations of Mode using a MySQL Connection in Amazon QuickSight.
-
Build Salesforce CRM Analytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesforce CRM Analytics and build visualizations in Tableau.
-
How to connect to Phoenix Data from Spring Boot
Connect to Phoenix in a Spring Boot Application using the CData JDBC Driver for Phoenix
-
Access Live WordPress Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate WordPress into the statistical analysis tools available in SAS JMP. This article shows how to use WordPress in the Graph Builder and Query Builder.
-
Replicate Amazon Athena Data in Heroku for Use in Salesforce Connect
Replicate Amazon Athena to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Extract, Transform, and Load Xero Data in Informatica PowerCenter
Create a simple Workflow for Xero Accounting in Informatica PowerCenter.
-
How to use SQLAlchemy ORM to access BenchmarkEmail Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of BenchmarkEmail.
-
Visualize Tally Data in TIBCO Spotfire through OData
Integrate Tally ERP into dashboards in TIBCO Spotfire.
-
How to Build an ETL App for Typeform Data in Python with CData
Create ETL applications and real-time data pipelines for Typeform in Python with petl.
-
Use Microsoft Copilot Studio to talk to your WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your WooCommerce for you.
-
View Reports on Real-Time LinkedIn Data in Power BI Report Server
Use the CData ODBC Driver for LinkedIn to visualize LinkedIn in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Mailjet Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mailjet. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy Web
Connect to Amazon Redshift in MicroStrategy Web using the CData Software JDBC Driver for Redshift.
-
Connect to Outreach.io Data from AWS Glue
Use CData Connect AI to gain access to live Outreach.io from your AWS Glue jobs.
-
Replicate Multiple Azure Synapse Accounts
Replicate multiple Azure Synapse accounts to one or many databases.
-
Connect to BigQuery Data in JRuby
Create a simple JRuby app with access to live Google BigQuery.
-
Integrate with CSV Data in JReport Designer
Create charts and reports based on CSV/TSV Files in JReport Designer.
-
Integrating OpenCode Terminal 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.
-
Connect to Impala Data from a Connection Pool in Jetty
The Impala JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Impala from Web apps in Jetty.
-
How to load Jira data into Elasticsearch via Logstash
Introducing a simple method to load Jira data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Access Zoho Recruit Data Using Entity Framework
This article shows how to access Zoho Recruit using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to MailerSend Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MailerSend to connect to MailerSend and execute queries in PowerBuilder.
-
Build Charts with Telegram Data in Clear Analytics
Create dynamic charts and perform analytics based on Telegram in Clear Analytics.
-
A PostgreSQL Interface for Workable Data (MySQL Remoting via JDBC)
Use the Remoting features of the Workable JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from ServiceDesk Plus to Google BigQuery using CData SSIS Components.
Easily push ServiceDesk Plus to Google BigQuery using the CData SSIS Tasks for ServiceDesk Plus and Google BigQuery.
-
Create Power BI Reports on Real-Time Databricks Data
Use the CData ODBC Driver for Databricks to visualize Databricks in Power BI Desktop.
-
Automated Continuous Sendwithus Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sendwithus replication to Apache Cassandra.
-
Tally Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Tally facts in real time.
-
Migrating data from Dynamics 365 Business Central to Databricks using CData SSIS Components.
Easily push Dynamics 365 Business Central to Databricks using the CData SSIS Tasks for Dynamics 365 Business Central and Databricks.
-
Migrating data from SAP ByDesign to Snowflake using CData SSIS Components.
Easily push SAP Business ByDesign to Snowflake using the CData SSIS Tasks for SAP ByDesign and Snowflake.
-
Integrate Real-Time Access to SAP Fieldglass in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Fieldglass in real time.
-
Connect to Trello from a Connection Pool in WebLogic
Use the CData JDBC Driver for Trello to connect to Trello from Web applications running on WebLogic.
-
Build Dynamics 365 Business Central-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Dynamics 365 Business Central and build Dynamics 365 Business Central-connected web apps with Axios.
-
ETL WordPress in Oracle Data Integrator
This article shows how to transfer WordPress into a data warehouse using Oracle Data Integrator.
-
How to Connect to Tavily Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Tavily. Leverage the pyodbc module for ODBC in Python.
-
Create Quickbase-Connected Applications in Appsmith
Connect to Quickbase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Quickbase.
-
Integrate Insightly Data in the Pentaho Report Designer
Publish reports based on Insightly in the Pentaho BI tool.
-
Use the CData ODBC Driver for Moosend from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Moosend to connect to Moosend from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Moosend in Excel.
-
Access Bitly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bitly from HeidiSQL.
-
Build Agents in Relevance AI with Access to Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on BigCommerce within intelligent agent workflows.
-
Analyze Google Contacts Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Contacts and visualize Google Contacts in SAP Analytics Cloud.
-
Migrating data from BigCommerce to Snowflake using CData SSIS Components.
Easily push BigCommerce to Snowflake using the CData SSIS Tasks for BigCommerce and Snowflake.
-
Bind Live ActiveCampaign Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ActiveCampaign data
-
View Reports on Real-Time Office 365 Data in Power BI Report Server
Use the CData ODBC Driver for Office 365 to visualize Microsoft Office 365 in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Templated Data in CloverDX (formerly CloverETL)
Transfer Templated using the visual workflow in the CloverDX data integration tool.
-
Connect to SharePoint Excel Services Data in Ruby
Connect to SharePoint Excel Services in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to eBay Data in HULFT Integrate
Connect to eBay as a JDBC data source in HULFT Integrate
-
How to Design Reckon Accounts Hosted Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Reckon Accounts Hosted from mobile and tablet Power Apps.
-
Manage Slack Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Slack.
-
Automate SurveyMonkey Data Replication to SAP HANA
Use CData Sync to customize and automate SurveyMonkey replication to SAP HANA.
-
Build JotForm-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live JotForm.
-
Connect to Square Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Square and the SQL Gateway to access Square from Google Apps Script.
-
Migrating data from LDAP to Snowflake using CData SSIS Components.
Easily push LDAP to Snowflake using the CData SSIS Tasks for LDAP and Snowflake.
-
How to Easily Query Tavily Data in OpenOffice Base
Connect to Tavily data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Query PolarTeamPro Data as a MySQL Database in Node.js
Execute MySQL queries against PolarTeamPro from Node.js.
-
Connecting Pipedream with Outreach.io Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Outreach.io data in real time.
-
How to Access Live Authorize.Net Data in Visual Studio Code via Cline
Run CData MCP Server for Authorize.Net on Windows Subsytem for Linux (WSL) and connect to live Authorize.Net from the Cline extension in Visual Studio Code.
-
Connect to LightSpeedRetail Data in HULFT Integrate
Connect to LightSpeedRetail as a JDBC data source in HULFT Integrate
-
Build a PostgreSQL Interface for Gumroad Data using the CData JDBC Driver
Use the Remoting features of the Gumroad JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Moosend Data in DBVisualizer
Integrate Moosend with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect Amazon QuickSight to MySQL Data
Create a connection to MySQL in CData Connect AI and insert MySQL into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Databricks Data in the Pentaho Report Designer
Publish reports based on Databricks in the Pentaho BI tool.
-
Connect to Scrapfly Data in NetBeans
Connect to Scrapfly in NetBeans with the data source configuration wizard.
-
Automated Continuous Gorgias Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Gorgias replication to Apache Kafka.
-
Create SSAS Tabular Models from Amazon DynamoDB Data
How to build a SQL Server Analysis Service Tabular Model from Amazon DynamoDB using CData drivers.
-
Visualize Live Reckon Accounts Hosted Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Reckon Accounts Hosted into custom reports in Power BI.
-
Access Freshservice Data from MySQL in Amazon QuickSight
Connect to Freshservice and build visualizations of Freshservice using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous FHIR Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable FHIR replication to Azure SQL Database.
-
Use the CData SSIS Components to Insert New or Update Existing Dynamics 365 Business Central Records from SQL Server
Easily push SQL Server data to Dynamics 365 Business Central using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Dynamics 365 Business Central or update existing records with data from a SQL Server database.
-
Connect MailerSend Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MailerSend using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Query ZohoInvoice Data in MySQL Workbench
Execute MySQL queries against live ZohoInvoice from MySQL Workbench.
-
Connect to BambooHR Data in HULFT Integrate
Connect to BambooHR as a JDBC data source in HULFT Integrate
-
Build MVC Applications with Connectivity to Everhour Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Everhour from an ASP.NET MVC application.
-
CData Elasticsearch Driver Features & Differentiators
An overview of the features of the CData Elasticsearch Drivers, particular as they compare to and surpass the native Elasticsearch drivers.
-
Work with Instagram Data in FoxPro
Load Instagram into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate MailChimp with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MailChimp with External Services.
-
Connecting Agentforce with Microsoft Teams 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 Microsoft Teams for you.
-
Connect Codat to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Codat using the CData Python MCP Server.
-
Use CData Connect AI to Access MarkLogic Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MarkLogic in the Power Pivot business intelligence tool.
-
Automated Continuous TaxJar Replication to Databricks
Use CData Sync for automated, continuous, customizable TaxJar replication to Databricks.
-
Access Live Power BI XMLA 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 Power BI XMLA through MCP integration.
-
Natively Connect to Vault CRM Data in PHP
The CData ODBC driver for Vault CRM enables you to create PHP applications with connectivity to Veeva Vault & Vault CRM. Leverage the native support for ODBC in PHP.
-
Integrate Parquet Data in Pentaho Data Integration
Build ETL pipelines based on Apache Parquet in the Pentaho Data Integration tool.
-
Choosing the Best Method to Connect Copper to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Copper from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to HCL Domino Data in HULFT Integrate
Connect to HCL Domino as a JDBC data source in HULFT Integrate
-
How to work with Todoist Data in Apache Spark using SQL
Access and process Todoist Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze Azure Table Data in Cognos Analytics
Use CData Connect AI to connect to Azure Table Data from Cognos Analytics and analyze live Azure Table Storage.
-
Connect to and Query Notion Data in QlikView over ODBC
Create data visualizations with Notion in QlikView.
-
How to Connect to Live Freshservice 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 Freshservice through natural language.
-
Connect to Real-Time Act CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Act CRM and Dataflow to import and use Act CRM in Power Apps.
-
Integrating Claude Code CLI with MongoDB 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.
-
A PostgreSQL Interface for LeadDesk Data (MySQL Remoting via JDBC)
Use the Remoting features of the LeadDesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish iContact-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live iContact.
-
How to Access SendPulse Data Using Entity Framework
This article shows how to access SendPulse using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use JayDeBeApi to access Pingdom Data in Python
Use standard Python scripting and the development environment of your choice to access live Pingdom.
-
How to connect to Bitly Data from IntelliJ
Integrate connectivity to Bitly with wizards in IntelliJ.
-
Rapidly Develop Greenhouse-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 Greenhouse.