CData Software - Knowledge Base
Recent Articles
-
Access SAP SuccessFactors Data from MySQL in Amazon QuickSight
Connect to SAP SuccessFactors and build visualizations of SAP SuccessFactors using a MySQL Connection in Amazon QuickSight.
-
Access Live Bullhorn CRM 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 Bullhorn CRM through MCP integration.
-
Connect to GitHub Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for GitHub and the Script function in FileMaker Pro to connect to GitHub and work with GitHub in your FileMaker application.
-
Getting Started with the CData SSIS Components for LinkedIn
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LinkedIn.
-
Publish Telegram-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Telegram.
-
How to connect to Onfleet Data from IntelliJ
Integrate connectivity to Onfleet with wizards in IntelliJ.
-
Replicate Multiple iContact Accounts
Replicate multiple iContact accounts to one or many databases.
-
Automate Rootly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Rootly from PowerShell? This article demonstrates how to utilize the Rootly Cmdlets for tasks like connecting to Rootly, automating operations, downloading data, and more.
-
Using the CData Software ODBC Driver for LaunchDarkly in PyCharm
Connect to LaunchDarkly as an ODBC data source in PyCharm using the CData Software ODBC Driver for LaunchDarkly.
-
Connect to Amazon Athena Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon Athena in Airbyte.
-
Migrating data from Todoist to Databricks using CData SSIS Components.
Easily push Todoist to Databricks using the CData SSIS Tasks for Todoist and Databricks.
-
Connect to and Visualize Live Tanda Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Tanda.
-
Easily Integrate Pinecone Data in Lazarus Pascal IDE
Learn how to easily integrate live Pinecone in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Easily Query VWO Data in OpenOffice Base
Connect to VWO data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Visualize Delighted Data in Sisense
Create an ElastiCube in Sisense app with access to Delighted.
-
Access Unbounce Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Unbounce from your Oracle system.
-
Automated Continuous ZohoDesk Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoDesk replication to SQLite.
-
Connect to Google Directory Data from a Connection Pool in JBoss
Integrate Google Directory into Java servlets: Use the Management Console in JBoss to install the Google Directory JDBC Driver.
-
Publish Reports with MailChimp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailChimp.
-
Integrating Cursor CLI with Redis 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 Use a Microsoft Access Database to Update Acumatica Data in Real Time
Update Acumatica data by creating a linked table in Microsoft Access with the CData Acumatica ODBC Driver.
-
Access EmailOctopus Data from MySQL in PHP
Connect to EmailOctopus through the standard MySQL libraries in PHP.
-
How to create an RPA flow for Kintone Data in UiPath Studio
Use the Kintone ODBC Driver to create workflows that access real-time Kintone without any coding.
-
Connect to Amazon S3 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon S3 in FileMaker Pro to connect to Amazon S3 and work with Amazon S3 in your FileMaker applications.
-
How to create Microsoft OneDrive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft OneDrive in MySQL .
-
Create Informatica Mappings From/To a JDBC Data Source for Coinbase
Create Coinbase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Twitter Ads Data in Talend Cloud Data Management Platform
Connect Twitter Ads Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Twitter Ads.
-
Use Dash to Build Web Apps on Active Directory Data via CData Connect AI
Build interactive Dash web apps on live Active Directory using pandas and the CData Connect AI Python SDK.
-
Build Sybase-Connected Apps in Choreo
Use CData Connect AI to connect to Sybase Data from Choreo and build custom apps using live Sybase.
-
Connect to Google Translate Data in RazorSQL
Connect to Google Translate from wizards and query Google Translate from the GUI in the RazorSQL database management tool.
-
Publish Reports with Dropbox Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dropbox.
-
Model, Search, and Visualize Live IBM Informix Data in ThoughtSpot
Use CData Connect AI to connect to live IBM Informix for modeling, searching, and visualizing.
-
Automated Continuous Azure Data Catalog Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Databricks.
-
Integrate with MailerLite Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailerLite to a JSON file on disk.
-
Integrating Pushbullet Data in Talend Cloud Data Management Platform
Connect Pushbullet Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData Excel Add-In for SAP
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP.
-
Build Dashboards with Coda Data in Dundas BI
Create dynamic dashboards and perform analytics based on Coda in Dundas BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SendGrid
Provide connectivity to SendGrid through an SAP BusinessObjects universe.
-
Connect to Databricks Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Databricks in the Denodo Virtual DataPort Administrator.
-
How to Query Sage Intacct Data in MySQL Workbench
Execute MySQL queries against live Sage Intacct from MySQL Workbench.
-
Integrate with PostgreSQL Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PostgreSQL to a JSON file on disk.
-
Automated SAS xpt Data Replication to Teradata
Use CData Sync to Customize and automate SAS XPORT replication to Teradata.
-
How to Access Sugar CRM Data Using Entity Framework
This article shows how to access Sugar CRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import Real-Time Azure Table Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Azure Table Storage in ColdFusion.
-
Migrating data from Clari to Databricks using CData SSIS Components.
Easily push Clari to Databricks using the CData SSIS Tasks for Clari and Databricks.
-
Connect to Drip Data in DBArtisan
Use wizards in DBArtisan to configure Drip as a data source.
-
Integrate JobNimbus Data in the Pentaho Report Designer
Publish reports based on JobNimbus in the Pentaho BI tool.
-
Automate Tasks in Power Automate Using the CData API Server
Automate MYOB AccountRight actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to work with ScrapingBee Data in Apache Spark using SQL
Access and process ScrapingBee Data in Apache Spark using the CData Software JDBC Driver.
-
Query Acumatica Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Acumatica ERP from Node.js.
-
Connect to Mocean Data from a Connection Pool in JBoss
Integrate Mocean into Java servlets: Use the Management Console in JBoss to install the Mocean JDBC Driver.
-
Connect to eBay Analytics from Asprova with CData Software ODBC Driver for eBay Analytics
This article shows how to connect faster to eBay Analytics data from Asprova.
-
Connect to Sage 200 Data in RazorSQL
Connect to Sage 200 from wizards and query Sage 200 from the GUI in the RazorSQL database management tool.
-
Connect to SAP HANA Data in Aqua Data Studio
Access SAP HANA from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Design Exact Online Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Exact Online from mobile and tablet Power Apps.
-
Connect to Facebook Ads Data in NetBeans
Connect to Facebook Ads in NetBeans with the data source configuration wizard.
-
Create Bullhorn CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Bullhorn CRM Data from Nintex Workflow Cloud and build custom workflows using live Bullhorn CRM.
-
Connect to SendPulse Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to SendPulse and work with SendPulse in your FileMaker applications.
-
Use Databricks Agent Bricks to Talk to Your ShipStation Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ShipStation for you.
-
Analyze Freshdesk Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshdesk in Microsoft R Open.
-
How to Seamlessly Import Procore Data into IBM SPSS Modeler
Integrate Procore data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Azure AI Foundry to Talk to Your SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SQL Analysis Services for you.
-
Query Zoom Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoom.
-
How to create Visio diagrams from PostgreSQL Data
Automatically update PostgreSQL with the changes you make to Visio master shapes.
-
Connect to Apollo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Apollo Data and connect to Apollo in Akorbi Digital RunMyProcess.
-
Integrating Boomi Agentstudio with eBay Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to eBay, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Write a Simple Go Application to work with ZendeskSell Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZendeskSell.
-
Build Dashboards with Google Sheets Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Sheets in Dundas BI.
-
Integrating GitHub Copilot CLI with Reckon 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.
-
Analyze Klipfolio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Klipfolio from Power Pivot. You will use the Table Import Wizard to load Klipfolio. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Databricks from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Databricks, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData SSIS Components to Insert New or Update Existing Redis Records from SQL Server
Easily push SQL Server data to Redis using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Redis or update existing records with data from a SQL Server database.
-
Extract, Transform, and Load SAP Hybris C4C Data in Informatica PowerCenter
Create a simple Workflow for SAP Hybris C4C in Informatica PowerCenter.
-
Automate SAS xpt Data Replication to Azure Synapse
Use CData Sync to customize and automate SAS XPORT replication to Azure Synapse.
-
Natively Connect to RabbitMQ Data in PHP
The CData ODBC driver for RabbitMQ enables you to create PHP applications with connectivity to RabbitMQ. Leverage the native support for ODBC in PHP.
-
Integrate Live Google Cloud Storage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Cloud Storage to Blue Prism using the CData ODBC Driver for Google Cloud Storage to create automated workflows for repetitive business tasks.
-
How to connect PolyBase to SQL Server
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft SQL Server.
-
Stream Adobe Target Data into Apache Kafka Topics
Access and stream Adobe Target in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a Simple VCL Application for AlloyDB Data
How to build a simple VCL Application to view Google AlloyDB in RAD Studio using the CData ODBC Driver for AlloyDB.
-
Access Live Klaviyo Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Klaviyo through MCP integration.
-
Access Live WordPress Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live WordPress from your Excel spreadsheets.
-
How to integrate ConstantContact with Apache Airflow
Access and process ConstantContact in Apache Airflow using the CData JDBC Driver.
-
Excel Spreadsheet Automation on ActiveCampaign Data with the QUERY Formula
Pull data from ActiveCampaign, automate spreadsheets, and more with the QUERY formula.
-
How to Connect the Power BI Service to FreeAgent: Complete Guide
Connect to the CData Software Power BI Connector for FreeAgent from PowerBI.com to provide real-time FreeAgent across the organization.
-
How to connect PolyBase to MailerLite
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MailerLite.
-
How to Work with Microsoft Exchange Data in ETL Validator JDBC
Connect to Microsoft Exchange from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Real-Time Sybase IQ Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sybase IQ and Dataflow to import and use Sybase IQ in Power Apps.
-
Access ChartMogul 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 ChartMogul.
-
Import Act CRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Act CRM. In this article, you will use the OData format to import Act CRM into Microsoft Power Query.
-
Replicate Multiple ZarMoney Accounts
Replicate multiple ZarMoney accounts to one or many databases.
-
Create SparkPost Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SparkPost from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize QuickBooks Data in TIBCO Spotfire through ADO.NET
Integrate QuickBooks Desktop into dashboards in TIBCO Spotfire.
-
Import Real-Time PagerDuty Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PagerDuty in ColdFusion.
-
Build Snapchat Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Snapchat Ads and build Snapchat Ads-connected web apps with Axios.
-
Integrate with Salesforce Data in JReport Designer
Create charts and reports based on Salesforce & Force.com in JReport Designer.
-
Getting Started with the CData Power BI Connector for SAP Business One
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Business One.
-
Automated Continuous Google Calendar Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Calendar replication to Vertica.
-
Extract, Transform, and Load HBase Data in Informatica PowerCenter
Create a simple Workflow for Apache HBase in Informatica PowerCenter.
-
Create a Data Access Object for Dotmailer Data using JDBI
A brief overview of creating a SQL Object API for Dotmailer in JDBI.
-
Query Live Salesforce Pardot Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Salesforce Pardot directly from the development environment.