CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData SSIS Components for IBM Cloud Object Storage.
-
Visualize Live Missive Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Missive data.
-
Build Dashboards with Reckon Data in Dundas BI
Create dynamic dashboards and perform analytics based on Reckon data in Dundas BI.
-
Use the CData Software ODBC Driver for Jumpseller in MicroStrategy Web
Connect to Jumpseller data in MicroStrategy Web using the CData Software ODBC Driver for Jumpseller.
-
Use the CData Software JDBC Driver for GitHub in MicroStrategy Web
Connect to GitHub data in MicroStrategy Web using the CData Software JDBC Driver for GitHub.
-
Integrating Onfleet Data in Talend Cloud Data Management Platform
Connect Onfleet Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Analyze Paylocity Data in Looker
Use CData Connect AI to connect to Paylocity Data from Looker and build custom apps using live Paylocity data.
-
Getting Started with the CData ODBC Driver for Shortcut
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Shortcut.
-
Automated Continuous MongoDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MongoDB replication to Google Cloud SQL.
-
Automated Continuous LinkedIn Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Azure SQL Database.
-
Easily Integrate SAP Business One Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Business One data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Freshsales Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Freshsales replication to Amazon Redshift.
-
Getting Started with the CData Python Connector for ClickUp
Learn to install and license the CData Python Connector and configure a connection to live ClickUp data.
-
Prepare, Blend, and Analyze iContact Data in Alteryx Designer (ODBC)
Build workflows to access live iContact data for self-service data analytics.
-
Integrate Live eBay Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to eBay data and integrate live eBay data into apps built in Microsoft Power Apps.
-
Connecting GenSpark with Outreach.io Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Outreach.io data without any replication or custom integration required.
-
Extract, Transform, and Load Scrapfly Data in Informatica PowerCenter
Create a simple Workflow for Scrapfly data in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for Oracle Eloqua Reporting in MicroStrategy Web
Connect to Oracle Eloqua Reporting data in MicroStrategy Web using the CData Software JDBC Driver for Oracle Eloqua Reporting.
-
Deploy the ADO.NET Provider for ZeroBounce on an SSRS Report Server
Connect to ZeroBounce data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous Hive Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Hive replication to Amazon Redshift.
-
Use CData Connect AI to Access Cassandra Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Cassandra data in the Power Pivot business intelligence tool.
-
Automated Continuous Dynamics CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to delimited files (CSV/TSV).
-
Link Oracle HCM Cloud with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle HCM Cloud data in Filemaker Pro for Mac or Windows.
-
Connect to Presto Data from PowerBuilder via JDBC
This article demonstrates how to access Presto data from PowerBuilder using the Presto JDBC Driver.
-
Automated Continuous Printify Replication to Oracle
Use CData Sync for automated, continuous, customizable Printify replication to Oracle.
-
Getting Started with the CData Power BI Connector for Oracle SCM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle SCM.
-
Trello Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Trello facts in real time.
-
Automate ClickTime Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ClickTime data from PowerShell? This article demonstrates how to utilize the ClickTime Cmdlets for tasks like connecting to ClickTime data, automating operations, downloading data, and more.
-
Connect to Shopify Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Shopify to connect to Shopify data and execute queries in PowerBuilder.
-
Automated Continuous Aweber Replication to MySQL
Use CData Sync for automated, continuous, customizable Aweber replication to MySQL.
-
Connect to Wave Financial Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Wave Financial to connect to Wave Financial data and execute queries in PowerBuilder.
-
How to publish and share Templated Data dashboards with Tableau Server
The CData ODBC driver for Templated enables you integrate Templated data into Tableau dashboards.
-
Connect to Real-Time Kintone Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Kintone and Dataflow to import and use Kintone data in Power Apps.
-
Create OneNote-Connected Applications in Appsmith
Connect to OneNote Data via CData Connect AI in Appsmith and create custom business applications with real-time access to OneNote data.
-
Configure the CData JDBC Driver for EmailOctopus in a Connection Pool in Tomcat
Connect to EmailOctopus data from a connection pool in Tomcat.
-
Automated Continuous OneNote Replication to SQLite
Use CData Sync for automated, continuous, customizable OneNote replication to SQLite.
-
Creating ConstantContact-Connected Applications in Unqork
You can use CData Connect AI to feed ConstantContact data to Unqork and build custom business apps.
-
Connect to Salesforce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce data.
-
Analyze Exact Online Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Exact Online data in Microsoft R Open.
-
Use Microsoft Copilot Studio to talk to your Slack 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 Slack data for you.
-
How to update Salesforce Marketing from Excel
This article explains how to transfer data from Excel to Salesforce Marketing using the Excel Add-In for Salesforce Marketing.
-
Automate Webex Data Replication to SAP HANA
Use CData Sync to customize and automate Webex data replication to SAP HANA.
-
Import Gong Data Using Azure Data Factory
Use CData Connect AI to connect to Gong Data from Azure Data Factory and import live Gong data.
-
Add Pingdom Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pingdom with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect and Query Live Teradata Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Teradata data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect to Mode Data in DBVisualizer
Integrate Mode data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous SAP Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP replication to Apache Cassandra.
-
Analyze Raisers Edge NXT Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Raisers Edge NXT data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use Dash to Build Web Apps on QuickBooks Data via CData Connect AI
Build interactive Dash web apps on live QuickBooks data using pandas and the CData Connect AI Python SDK.
-
Build Dashboards with Float Data in Dundas BI
Create dynamic dashboards and perform analytics based on Float data in Dundas BI.
-
Integrate Devin with Live Square 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 Square data.
-
Feed Sage Intacct Data into FineReport
How to set Sage Intacct data as a JDBC data source in FineReport.
-
Using the CData Software ODBC Driver for Coinbase in PyCharm
Connect to Coinbase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Coinbase.
-
Build Data Flows from ServiceNow to SQL Server using SSIS
Easily back up ServiceNow data to SQL Server using the SSIS components for ServiceNow.
-
Connect Customer.io to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Customer.io data using the CData Python MCP Server.
-
Build Dashboards with Exa Data in DBxtra
Create dynamic dashboards and perform analytics based on Exa data in DBxtra.
-
Query, Visualize, and Share live Shortcut Data in Redash
Use CData Connect AI to connect to live Shortcut data in Redash for querying, visualizing, and sharing.
-
Enable the Anaplan JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Anaplan data.
-
How to Work with AfterShip Data in AWS Glue Jobs Using JDBC
Connect to AfterShip from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Edit and Search External SAP Ariba Source Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Ariba Source data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Ariba Source Data objects that you can access from apps and the dashboard.
-
Integrate Todoist Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Todoist data from Informatica Cloud.
-
Import and Visualize Zoom Data in Power View
Create data visualizations based on Zoom data in Excel.
-
How to Connect to Live Exa Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Exa data for you.
-
Create Data Visualizations in Cognos BI with Pushbullet Data
Access Pushbullet data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Deploy the ADO.NET Provider for Placid on an SSRS Report Server
Connect to Placid data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Work with Splunk Data in FoxPro
Load Splunk data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use JayDeBeApi to access NASA Data in Python
Use standard Python scripting and the development environment of your choice to access live NASA data.
-
Visualize Bright Data Data in TIBCO Spotfire through ADO.NET
Integrate Bright Data data into dashboards in TIBCO Spotfire.
-
Rapidly Develop FTP-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 FTP.
-
View Reports on Real-Time SuiteCRM Data in Power BI Report Server
Use the CData ODBC Driver for SuiteCRM to visualize SuiteCRM data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating LangGraph with Impala Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Impala data within automated workflows.
-
Automate Databricks Data Replication to Azure Data Lake
Use CData Sync to customize and automate Databricks data replication to Azure Data Lake.
-
How to Create Power BI Visual Reports with Real-Time Zoom Data
Use CData Power BI Connectors to visualize Zoom data in Power BI.
-
Connect to Quaderno Data in NetBeans
Connect to Quaderno data in NetBeans with the data source configuration wizard.
-
Replicate Zoom Data from PowerShell
Write a quick PowerShell script to query Zoom data. Use connectivity to the live data to replicate Zoom data to SQL Server.
-
Import Google Search Results into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Search Results and provide access to live Google Search results for custom reports in the Power BI Service.
-
Create SSAS Tabular Models from PabblySubscriptions Data
How to build a SQL Server Analysis Service Tabular Model from PabblySubscriptions data using CData drivers.
-
Access Live Microsoft Planner Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Planner data from your Google Sheets.
-
Build Visualizations of Intercom Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Intercom data in Birst.
-
Build Data Flows from Excel to SQL Server using SSIS
Easily back up Excel data to SQL Server using the SSIS components for Excel.
-
Replicate Multiple Deel Accounts via the CData Sync CLI
Replicate multiple Deel accounts to one or many databases.
-
Replicate Twilio Data to Multiple Databases via the CData Sync CLI
Replicate Twilio data to disparate databases with a single configuration.
-
Import FHIR Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to FHIR Data and provide access to live FHIR data for custom reports in the Power BI Service.
-
Integrating LangGraph with Dynamics 365 Business Central Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Dynamics 365 Business Central data within automated workflows.
-
How to update SAS Data Sets from Excel
This article explains how to transfer data from Excel to SAS Data Sets using the Excel Add-In for SAS Data Sets.
-
Integrating Dataiku with Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sage 300 data.
-
Connect to Apify Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apify data from Crystal Reports.
-
Connect to Bitly Data in RazorSQL
Connect to Bitly from wizards and query Bitly data from the GUI in the RazorSQL database management tool.
-
Migrating data from SAP Business Warehouse to Google BigQuery using CData SSIS Components.
Easily push SAP Business Warehouse data to Google BigQuery using the CData SSIS Tasks for SAP Business Warehouse and Google BigQuery.
-
Build ZohoDesk-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live ZohoDesk data without replication.
-
Access Live IBM Cloud Object Storage 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 IBM Cloud Object Storage data through MCP integration.
-
Manage Clio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Clio.
-
Build Agents in Relevance AI with Access to Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Cloud Storage data within intelligent agent workflows.
-
Connect to Salesloft Data in DBeaver
Use the CData ODBC Driver to connect to Salesloft data in DBeaver.
-
Build Automated Sage 200-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sage 200 data and build automated workflows in Zapier.
-
Connect to Bugsnag Data in DBArtisan
Use wizards in DBArtisan to configure Bugsnag data as a data source.
-
Automate Microsoft Exchange Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Exchange data replication to Azure Synapse.
-
Create Reports with Accelo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Accelo data.
-
Create Freshsales Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Freshsales from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Foursquare Data in DBArtisan
Use wizards in DBArtisan to configure Foursquare data as a data source.