CData Software - Knowledge Base
Recent Articles
-
Access Live ServiceNow Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ServiceNow in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect PolyBase to Demio
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Demio.
-
Create Informatica Mappings From/To an ODBC Data Source for Bitbucket
Create an ODBC connection to Bitbucket in Informatica and browse and transfer Bitbucket.
-
Choosing the Best Method to Connect MessageBird to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MessageBird from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software JDBC Driver for LionDesk in MicroStrategy Web
Connect to LionDesk in MicroStrategy Web using the CData Software JDBC Driver for LionDesk.
-
Connect to Databricks Data in ACL Analytics
Connect to Databricks via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Databricks.
-
Build API-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live API.
-
Integrate with Amazon Athena Data in JReport Designer
Create charts and reports based on Amazon Athena in JReport Designer.
-
How to Build an ETL App for Gorgias Data in Python with CData
Create ETL applications and real-time data pipelines for Gorgias in Python with petl.
-
How to integrate Bugsnag with Apache Airflow
Access and process Bugsnag in Apache Airflow using the CData JDBC Driver.
-
Connect to Zoho Projects Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoho Projects in Airbyte.
-
Connect to MYOB AccountRight Data in RapidMiner
Integrate MYOB AccountRight with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze GitLab Data in Looker
Use CData Connect AI to connect to GitLab Data from Looker and build custom apps using live GitLab.
-
Use Dash to Build to Web Apps on Bannerbear Data
Create Python applications that use pandas and Dash to build Bannerbear-connected web apps.
-
Connect to BambooHR 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 BambooHR and work with BambooHR in your FileMaker application.
-
How to Visualize HBase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache HBase in Python.
-
How to integrate Microsoft Teams with Apache Airflow
Access and process Microsoft Teams in Apache Airflow using the CData JDBC Driver.
-
Automate Bullhorn CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Bullhorn CRM replication to Azure Synapse.
-
How to Create Power BI Visual Reports with Real-Time Cosmos DB Data
Use CData Power BI Connectors to visualize Azure Cosmos DB in Power BI.
-
Access LDAP Objects from MySQL in PHP
Connect to LDAP through the standard MySQL libraries in PHP.
-
Connect to Jodoo Data from a Connection Pool in JBoss
Integrate Jodoo into Java servlets: Use the Management Console in JBoss to install the Jodoo JDBC Driver.
-
Create Zoho CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoho CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Create Power BI Visual Reports with Real-Time eBay Analytics Data
Use CData Power BI Connectors to visualize eBay Analytics in Power BI.
-
Use Biml to Build SSIS Tasks to Replicate Salesforce Marketing Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce Marketing Cloud to SQL Server.
-
DataBind Controls to Salesforce Data in Delphi
DataBind to Salesforce & Force.com in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Redis in SAS for Real-Time Reporting and Analytics
Connect to real-time Redis in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Redis.
-
SSIS Components: The PerformUpgrade Method Failed
In this entry, you will find resolutions for the SSIS PerformUpgrade error.
-
Automate Sage 300 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sage 300 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Charts with Helpscout Data in Clear Analytics
Create dynamic charts and perform analytics based on Helpscout in Clear Analytics.
-
Connect to Discourse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Discourse and the SQL Gateway to access Discourse from Google Apps Script.
-
Connect to Quickbase Data from PowerBuilder via JDBC
This article demonstrates how to access Quickbase from PowerBuilder using the Quickbase JDBC Driver.
-
How to Work with Sage 200 Data in ETL Validator JDBC
Connect to Sage 200 from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Datasets from HBase in Domo Workbench and Build Visualizations of HBase Data in Domo
Use the CData Software ODBC Driver for HBase to create datasets from Apache HBase in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Asana Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Asana replication to Amazon S3.
-
Establish a Live Connection with Recurly Data using Tableau Bridge
The CData ODBC Driver for Recurly enables you to integrate live Recurly into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Cline with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Freshservice from within your IDE.
-
Build Automated Google Drive-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Drive and build automated workflows in Zapier.
-
How to Visualize Discord Data in Python with pandas
Use pandas and other modules to analyze and visualize live Discord in Python.
-
Prepare, Blend, and Analyze Marketo Data in Alteryx Designer (ODBC)
Build workflows to access live Marketo for self-service data analytics.
-
Connect to Twilio Data in Jaspersoft Studio
Execute SQL to remote Twilio in Jaspersoft Studio.
-
Use Agno to Talk to Your Redis 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 Redis for you.
-
Connect to Google Cloud Storage Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Cloud Storage from Filemaker Pro on Mac.
-
Prepare, Blend, and Analyze Salesforce Pardot Data in Alteryx Designer (ODBC)
Build workflows to access live Salesforce Pardot for self-service data analytics.
-
Automated Continuous EmailOctopus Replication to Amazon S3
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Amazon S3.
-
Use the CData Software JDBC Driver for Exa in MicroStrategy
Connect to Exa in MicroStrategy Developer using the CData Software JDBC Driver for Exa.
-
Connect to and Visualize Live Pinecone Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pinecone.
-
How to Import Data from Oracle into Google Sheets
Import Oracle Database into a Google spreadsheet that is automatically refreshed.
-
Create Apps from Bullhorn CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Bullhorn CRM Data and build apps from live Bullhorn CRM in Qlik Sense Cloud.
-
Publish Reports with Google Forms Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Forms.
-
Stream Procore Data into Apache Kafka Topics
Access and stream Procore in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Intercom Data in DBVisualizer
Integrate Intercom with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect PolyBase to Procore
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Procore.
-
How to use SQLAlchemy ORM to access Oracle Financials Cloud Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Financials Cloud.
-
Automated Continuous Microsoft Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to SQL Server.
-
How to Connect the Power BI Service to SparkPost: Complete Guide
Connect to the CData Software Power BI Connector for SparkPost from PowerBI.com to provide real-time SparkPost across the organization.
-
Connect to Hive Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Apache Hive.
-
Build Pipedrive-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pipedrive.
-
Bind Live Couchbase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Couchbase data
-
Integrate Live SpaceX Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SpaceX to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating OpenCode Terminal with SAS Data Sets 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 connect PolyBase to Clockify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Clockify.
-
How to integrate Metabase with WordPress Data
Use CData Connect AI to connect to live WordPress and create an interactive dashboard in Metabase from WordPress.
-
Automated Retently Data Replication to Teradata
Use CData Sync to Customize and automate Retently replication to Teradata.
-
Integrate with Jira Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Atlassian Jira in SnapLogic.
-
How to Connect to Live Google Analytics 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 Google Analytics through natural language.
-
DataBind Charts to Guru Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Guru 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.
-
Connect to SAP SuccessFactors Data in RazorSQL
Connect to SAP SuccessFactors from wizards and query SAP SuccessFactors from the GUI in the RazorSQL database management tool.
-
Integrating Kiro CLI with JobNimbus 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.
-
Enable the Browserless JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Browserless.
-
Shopify Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Shopify through CData Connect AI using different applications and tools.
-
Analyze Microsoft Teams Data in Looker
Use CData Connect AI to connect to Microsoft Teams Data from Looker and build custom apps using live Microsoft Teams.
-
Getting Started with the CData ADO.NET Provider for FTP
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for FTP.
-
Automated Continuous Klaviyo Replication to MySQL
Use CData Sync for automated, continuous, customizable Klaviyo replication to MySQL.
-
How to Query Discord Data in MySQL Workbench
Execute MySQL queries against live Discord from MySQL Workbench.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Dynamics CRM to Power BI dashboards. Simply drag and drop Microsoft Dynamics CRM into data visuals on the Power BI canvas.
-
How to Connect to Live Excel Online 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 Microsoft Excel Online for you.
-
Automated Continuous IBM Cloud Object Storage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to PostgreSQL.
-
Access Live BigQuery Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google BigQuery from your Excel spreadsheets.
-
Dynamically Retrieve Data Based on Cell Values with the CData Excel Add-in: CData Excel Formulas
Learn how to use the CData Excel Add-in and CData Excel Formulas to dynamically retrieve and refresh live cloud data in Excel using SQL queries.
-
Publish Dotmailer-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Dotmailer.
-
Connecting Moonlit Workflow with Salesforce CRM Analytics 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 Salesforce CRM Analytics in real time.
-
Building Dynamic Web Pages with SendGrid Data Using AngularJS
Create single-page applications with live connectivity to SendGrid using the CData API Server.
-
How to Connect to Live BigQuery Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google BigQuery for you.
-
How to create an RPA flow for Postmark Data in UiPath Studio
Use the Postmark ODBC Driver to create workflows that access real-time Postmark without any coding.
-
Replicate Microsoft Planner Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Planner to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Blackbaud FE NXT Data in DBVisualizer
Integrate Blackbaud FE NXT with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Nuclia Data from PowerShell
Write a quick PowerShell script to query Nuclia. Use connectivity to the live data to replicate Nuclia to SQL Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Missive
Create an ODBC connection to Missive in Informatica and browse and transfer Missive.
-
Integrate with Google Ads Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Ads to a JSON file on disk.
-
Connect to PDFMonkey Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PDFMonkey and the SQL Gateway to access PDFMonkey from Google Apps Script.
-
Integrate with Authorize.Net Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Authorize.Net in SnapLogic.
-
Working with Onfleet Data in LINQPad
Execute LINQ queries to Onfleet in LINQPad.
-
Migrating data from Customer.io to Databricks using CData SSIS Components.
Easily push Customer.io to Databricks using the CData SSIS Tasks for Customer.io and Databricks.
-
How to connect to Avaza Data with Squirrel SQL client
Connect to Avaza and execute queries in the Squirrel SQL Client.
-
Migrating data from Todoist to Snowflake using CData SSIS Components.
Easily push Todoist to Snowflake using the CData SSIS Tasks for Todoist and Snowflake.
-
Analyze SAP Business One Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Business One and visualize SAP Business One in SAP Analytics Cloud.
-
Automated Continuous Excel Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Excel replication to Apache Cassandra.
-
Query SFTP Data in DataGrip
Create a Data Source for SFTP in DataGrip and use SQL to query live SFTP.
-
Connect to Freshservice Data from Crystal Reports
Use CData Connect AI to connect to and report on live Freshservice from Crystal Reports.
-
How to Work with HDFS Data in AWS Glue Jobs Using JDBC
Connect to HDFS from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.