CData Software - Knowledge Base
Recent Articles
-
Build an OLAP Cube in SSAS from Jodoo Data
Establish a connection to Jodoo data from SQL Server Analysis Services, and use the Jodoo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Slack Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Slack replication to OneLake in Microsoft Fabric.
-
Access Live ChargeOver Data in Coginiti Pro
Connect to and query live ChargeOver from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Basecamp Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Basecamp.
-
How to connect to Databricks Data from IntelliJ
Integrate connectivity to Databricks with wizards in IntelliJ.
-
How to create Dynamics NAV federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dynamics NAV in MySQL .
-
Access Live Customer.io Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Customer.io data source in TIBCO Data Virtualization Studio and gain access to live Customer.io from your TDV Server.
-
Automated Continuous PolarTeamPro Replication to SQLite
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to SQLite.
-
Build a Simple VCL Application for Pushbullet Data
How to build a simple VCL Application to view Pushbullet in RAD Studio using the CData ODBC Driver for Pushbullet.
-
Create Datasets from Shortcut in Domo Workbench and Build Visualizations of Shortcut Data in Domo
Use the CData Software ODBC Driver for Shortcut to create datasets from Shortcut in Domo Workbench and then build visualizations in the Domo service.
-
Publish LeadDesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live LeadDesk.
-
Connect ServiceDesk Plus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ServiceDesk Plus with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Salesforce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce & Force.com using standard SQL.
-
Connecting GenSpark with SendGrid Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SendGrid without any replication or custom integration required.
-
Connect to Azure Analysis Services Data in JRuby
Create a simple JRuby app with access to live Azure Analysis Services.
-
Automated Continuous Grafana Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Grafana replication to Apache Kafka.
-
Connect to PostgreSQL Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData SSIS Components for Guru
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Guru.
-
View Reports on Real-Time Apify Data in Power BI Report Server
Use the CData ODBC Driver for Apify to visualize Apify in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Gong Data in AWS Lambda
Connect to live Gong in AWS Lambda using the CData JDBC Driver.
-
Work with AdRoll Data in FoxPro
Load AdRoll into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for Microsoft Ads in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Ads.
-
A PostgreSQL Interface for Postmark Data using the CData ODBC Driver
Use the SQL Gateway and Postmark ODBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Redshift JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amazon Redshift.
-
DataBind Charts to AdRoll Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to AdRoll 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 Workable to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Workable with IBM WebSphere for seamless data integration and connectivity.
-
How to Query Live Reply.io Data in Perplexity MacOS Desktop
Connect to and query live Reply.io Data in Perplexity Desktop using CData MCP Server.
-
Write a Simple Go Application to work with Sage Intacct Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage Intacct.
-
Import HBase Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache HBase. In this article, you will use the OData format to import Apache HBase into Microsoft Power Query.
-
Connect to BigQuery from Asprova with CData Software ODBC Driver for BigQuery
This article shows how to connect faster to BigQuery data from Asprova.
-
How to connect PolyBase to Ontraport
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Ontraport.
-
Working with Certinia Data in LINQPad
Execute LINQ queries to Certinia in LINQPad.
-
Create Dashboards and Visualize Live Epicor Kinetic Data in Geckoboard
Use CData Connect AI to connect to live Epicor Kinetic and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Microsoft Ads Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Apache Cassandra.
-
Publish Avro-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache Avro.
-
Visualize Recurly Data in Sisense
Create an ElastiCube in Sisense app with access to Recurly.
-
Integrating Kiro CLI with Instagram 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.
-
Analyze Sybase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sybase and visualize live Sybase in Infragistics Reveal.
-
How to Query Live SendInBlue Data in Claude Desktop
Connect to and query live SendInBlue Data in Claude Desktop using CData MCP Server.
-
How to Create Power BI Visual Reports with Real-Time Everhour Data
Use CData Power BI Connectors to visualize Everhour in Power BI.
-
Build an OLAP Cube in SSAS from Wrike Data
Establish a connection to Wrike data from SQL Server Analysis Services, and use the Wrike Data Provider to build OLAP cubes for use in analytics and reporting.
-
Process & Analyze Templated Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Templated Data.
-
Import Certinia Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Certinia Data and provide access to live Certinia for custom reports in the Power BI Service.
-
How to Build an ETL App for BigCommerce Data in Python with CData
Create ETL applications and real-time data pipelines for BigCommerce in Python with petl.
-
Feed Billsby Data into FineReport
How to set Billsby as a JDBC data source in FineReport.
-
Connect to and Query Zoho Projects Data in QlikView over ODBC
Create data visualizations with Zoho Projects in QlikView.
-
Edit and Search External Kintone Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Kintone to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Kintone Data objects that you can access from apps and the dashboard.
-
Add CockroachDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CockroachDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating LangGraph with GraphQL Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on GraphQL within automated workflows.
-
How to Connect DBeaver to Intercom via a JDBC Driver
Manage Intercom with visual tools in DBeaver like the query browser.
-
Create Informatica Mappings From/To an ODBC Data Source for SQL Server
Create an ODBC connection to SQL Server in Informatica and browse and transfer Microsoft SQL Server.
-
Connect Box to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Box using the CData Python MCP Server.
-
Connect to SAP SuccessFactors Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP SuccessFactors from Crystal Reports.
-
Integrate Live Email Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Email and integrate live Email into apps built in Microsoft Power Apps.
-
Integrating Cursor CLI with Apollo 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 Zoho Projects Data in Real Time
Update Zoho Projects data by creating a linked table in Microsoft Access with the CData Zoho Projects ODBC Driver.
-
How to update Elasticsearch from Excel
This article explains how to transfer data from Excel to Elasticsearch using the Excel Add-In for Elasticsearch.
-
Create Reports from FHIR Data in Looker Studio
Use CData Connect AI to gain access to live FHIR and create custom reports in Looker Studio.
-
Visualize Live Amazon Marketplace Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon Marketplace using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Testmonitor Data in Pentaho Data Integration
Build ETL pipelines based on Testmonitor in the Pentaho Data Integration tool.
-
Integrate PhantomBuster with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PhantomBuster with External Services.
-
Seamlessly Bring ADP Data into Retool Using CData Connect AI
Integrate ADP data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate Active Directory Data Replication to Couchbase
Use CData Sync to Customize and automate Active Directory replication to Couchbase.
-
Connect to Bitbucket Data in Jaspersoft Studio
Execute SQL to remote Bitbucket in Jaspersoft Studio.
-
How to create an RPA flow for Sybase IQ Data in UiPath Studio
Use the Sybase IQ ODBC Driver to create workflows that access real-time Sybase IQ without any coding.
-
Connect Jira Assets Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Jira Assets using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Python Connector for Pushbullet
Learn to install and license the CData Python Connector
-
Connect to SAP HANA XS Advanced Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP HANA XS Advanced as an External Source in Dremio.
-
Use the CData Software ODBC Driver for VWO in MicroStrategy Web
Connect to VWO in MicroStrategy Web using the CData Software ODBC Driver for VWO.
-
Use Agno to Talk to Your Sugar CRM 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 Sugar CRM for you.
-
DataBind Charts to Coda Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Coda 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.
-
How to load ConvertAPI data into Elasticsearch via Logstash
Introducing a simple method to load ConvertAPI data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Postmark Data in NetBeans
Connect to Postmark in NetBeans with the data source configuration wizard.
-
Analyze Sybase IQ Data in Looker
Use CData Connect AI to connect to Sybase IQ Data from Looker and build custom apps using live Sybase IQ.
-
Use Claude to Talk to Your Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Pipedrive for you.
-
Build Pipelines with Live SAP Concur Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Concur from Google Cloud Data Fusion, enabling the integration of live SAP Concur into the building and management of effective data pipelines.
-
Publish Reports with Shortcut Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shortcut.
-
Build a Simple VCL Application for Monday.com Data
How to build a simple VCL Application to view Monday.com in RAD Studio using the CData ODBC Driver for Monday.com.
-
Write a Simple Go Application to work with MailChimp Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailChimp.
-
Integrate Placid Data in the Pentaho Report Designer
Publish reports based on Placid in the Pentaho BI tool.
-
Query NASA Data in ColdFusion
Write standard ColdFusion data access code to connect to NASA.
-
Access Live BigCommerce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BigCommerce into the statistical analysis tools available in SAS JMP. This article shows how to use BigCommerce in the Graph Builder and Query Builder.
-
DataBind Charts to Zoho Inventory Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Inventory 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.
-
Validate Browserless Data with QuerySurge
Access and validate Browserless in QuerySurge using the CData JDBC Driver.
-
Create Slack-Connected Nintex Workflows
Use CData Connect AI to connect to Slack Data from Nintex Workflow Cloud and build custom workflows using live Slack.
-
Automated Continuous SendGrid Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SendGrid replication to Amazon S3.
-
Using the CData Software ODBC Driver for HBase in PyCharm
Connect to HBase as an ODBC data source in PyCharm using the CData Software ODBC Driver for HBase.
-
DataBind Controls to Pinecone Data in Delphi
DataBind to Pinecone in Delphi with standard data access components and controls.
-
How to Visualize LightSpeedRetail Data in Python with pandas
Use pandas and other modules to analyze and visualize live LightSpeedRetail in Python.
-
Use Microsoft Copilot Studio to talk to your LinkedIn Ads 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 LinkedIn Ads for you.
-
Use the CData Software ODBC Driver for Foursquare in MicroStrategy Desktop
Connect to Foursquare in MicroStrategy Desktop using the CData Software ODBC Driver for Foursquare.
-
How to Visualize HCL Domino Data in Python with pandas
Use pandas and other modules to analyze and visualize live HCL Domino in Python.
-
Connect to Sage 200 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage 200.
-
Create Reports from GitHub Data in Looker Studio
Use CData Connect AI to gain access to live GitHub and create custom reports in Looker Studio.
-
Access Jodoo 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 Jodoo.
-
Feed Google Translate Data into FineReport
How to set Google Translate as a JDBC data source in FineReport.
-
How to create an RPA flow for Toggl Data in UiPath Studio
Use the Toggl ODBC Driver to create workflows that access real-time Toggl without any coding.
-
Viewing Sybase IQ Data in RAD Studio Data Explorer
How to view Sybase IQ in RAD Studio Data Explorer using the CData ODBC Driver for Sybase IQ.
-
Replicate IBM Informix Data in Heroku for Use in Salesforce Connect
Replicate IBM Informix to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connecting Mastra with Freshdesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Freshdesk, no replication required.