CData Software - Knowledge Base
Recent Articles
-
Connect to REST Data in Claris FileMaker Pro
Use the CData ODBC Driver for REST in FileMaker Pro to connect to REST and work with REST data in your FileMaker applications.
-
Integrate Access with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Access with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Access data.
-
DataBind Controls to SQL Server Data in Delphi
DataBind to SQL Server data in Delphi with standard data access components and controls.
-
Natively Connect to JobNimbus Data in PHP
The CData ODBC driver for JobNimbus enables you to create PHP applications with connectivity to JobNimbus data. Leverage the native support for ODBC in PHP.
-
Visualize Microsoft Dataverse Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Dataverse data.
-
Connect to Egnyte Data from PowerBuilder via ADO.NET
This article demonstrates how to access Egnyte data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect the Power BI Service to Google Drive: Complete Guide
Connect to the CData Software Power BI Connector for Google Drive from PowerBI.com to provide real-time Google Drive data across the organization.
-
Create Facebook-Connected Nintex Workflows
Use CData Connect AI to connect to Facebook Data from Nintex Workflow Cloud and build custom workflows using live Facebook data.
-
How to Build an ETL App for SAP Hybris C4C Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Hybris C4C data in Python with petl and the CData Connect AI Python SDK.
-
Back Up Quaderno data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Quaderno data data.
-
Create Data Visualizations Based On Pinterest Data in Mode
Use CData Connect AI to connect to Pinterest Data from Mode and build visualizations using live Pinterest data.
-
DataBind Charts to Google Directory Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Directory data 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.
-
Automate Onfleet Data Replication to Couchbase
Use CData Sync to Customize and automate Onfleet data replication to Couchbase.
-
How to publish and share Qualaroo Data dashboards with Tableau Server
The CData ODBC driver for Qualaroo enables you integrate Qualaroo data into Tableau dashboards.
-
Connect to PingOne from a Connection Pool in WebLogic
Use the CData JDBC Driver for PingOne to connect to PingOne data from Web applications running on WebLogic.
-
Connect to Hubstaff from Asprova with CData Software ODBC Driver for Hubstaff
This article shows how to connect faster to Hubstaff data from Asprova.
-
How to load Snapchat Ads data into Elasticsearch via Logstash
Introducing a simple method to load Snapchat Ads data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Vimeo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Vimeo facts in real time.
-
Connect to Slack Data from Crystal Reports
Use CData Connect AI to connect to and report on live Slack data from Crystal Reports.
-
Build MariaDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MariaDB data.
-
Model, Search, and Visualize Live PostgreSQL Data in ThoughtSpot
Use CData Connect AI to connect to live PostgreSQL data for modeling, searching, and visualizing.
-
How to create an RPA flow for Dynamics 365 Data in UiPath Studio
Use the Dynamics 365 ODBC Driver to create workflows that access real-time Dynamics 365 data without any coding.
-
Automate Perplexity Data Replication to Couchbase
Use CData Sync to Customize and automate Perplexity data replication to Couchbase.
-
Connect to WordPress Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for WordPress data.
-
Automated Continuous Codat Replication to Databricks
Use CData Sync for automated, continuous, customizable Codat replication to Databricks.
-
Integrating Kiro with Landbot 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.
-
Build CSV-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CSV data and build web apps with connectivity to live CSV data.
-
How to Access Coinbase Data Using Entity Framework
This article shows how to access Coinbase data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Real-Time xBase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for xBase and Dataflow to import and use xBase data in Power Apps.
-
How to connect to Impala Data from IntelliJ
Integrate connectivity to Impala data with wizards in IntelliJ.
-
Connect to Gumroad Data in JRuby
Create a simple JRuby app with access to live Gumroad data.
-
Connect to Apollo 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 Apollo and work with Apollo data in your FileMaker application.
-
Integrate with Facebook Ads Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Facebook Ads data in SnapLogic.
-
View Reports on Real-Time Snapchat Ads Data in Power BI Report Server
Use the CData ODBC Driver for Snapchat Ads to visualize Snapchat Ads data in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Multiple Bugsnag Accounts
Replicate multiple Bugsnag accounts to one or many databases.
-
Query Live Salesforce Data 360 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 Data 360 data directly from the development environment.
-
Connect to Real-Time SAP SuccessFactors LMS Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP SuccessFactors LMS and Dataflow to import and use SAP SuccessFactors LMS data in Power Apps.
-
Integrating ZohoExpense Data in Talend Cloud Data Management Platform
Connect ZohoExpense Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to connect PolyBase to Avaza
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Avaza data.
-
Working with Mixpanel Data in LINQPad
Execute LINQ queries to Mixpanel data in LINQPad.
-
How to create Google Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Analytics data in MySQL .
-
Explore Geographical Relationships in SuiteCRM Data with Power Map
Create data visualizations with SuiteCRM data in Power Map.
-
Back Up ZohoDesk data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoDesk data data.
-
Migrating data from HCL Domino to Databricks using CData SSIS Components.
Easily push HCL Domino data to Databricks using the CData SSIS Tasks for HCL Domino and Databricks.
-
Operational Reporting on SageHR Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SageHR data.
-
Build SAP HANA XS Advanced-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP HANA XS Advanced data.
-
Integrate with Cvent Data in JReport Designer
Create charts and reports based on Cvent data in JReport Designer.
-
Integrate MYOB AccountRight Data in the Pentaho Report Designer
Publish reports based on MYOB AccountRight data in the Pentaho BI tool.
-
Query ChargeOver Data as a MySQL Database in Node.js
Execute MySQL queries against ChargeOver data from Node.js.
-
How to Work with Printful Data in ETL Validator JDBC
Connect to Printful from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Twilio-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Twilio data and build Twilio-connected web apps with Axios.
-
Connect to Cloudflare in SpagoBI
Create reports featuring live Cloudflare data in SpagoBI Studio. Host Cloudflare reports on SpagoBI Server.
-
Access SFTP Data from MySQL in PHP
Connect to SFTP through the standard MySQL libraries in PHP.
-
Import and Visualize AlloyDB Data in Power View
Create data visualizations based on AlloyDB data in Excel.
-
How to Connect to Live Tavily 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 Tavily data for you.
-
Model Impala Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Impala, enabling the direct import of real-time Impala data.
-
Integrate Trae with Live Sage Intacct Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Sage Intacct data from within the AI-powered IDE.
-
Deploy the ADO.NET Provider for Azure Analysis Services on an SSRS Report Server
Connect to Azure Analysis Services 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.
-
Integrate Google's Vertex AI Agent with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Splunk data within intelligent workflows.
-
Replicate Parallel Data from PowerShell
Write a quick PowerShell script to query Parallel data. Use connectivity to the live data to replicate Parallel data to SQL Server.
-
Connect to Cassandra Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Cassandra data in Airbyte.
-
How to Connect to Live ServiceDesk Plus Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your ServiceDesk Plus data for you.
-
Replicate Multiple OneNote Accounts via the CData Sync CLI
Replicate multiple OneNote accounts to one or many databases.
-
Getting Started with the CData Python Connector for Couchbase
Learn to install and license the CData Python Connector and configure a connection to live Couchbase data.
-
Automate TaxJar Integration Tasks from PowerShell
Are you in search of a quick and easy way to access TaxJar data from PowerShell? This article demonstrates how to utilize the TaxJar Cmdlets for tasks like connecting to TaxJar data, automating operations, downloading data, and more.
-
How to Seamlessly Import Microsoft Dataverse Data into IBM SPSS Modeler
Integrate Microsoft Dataverse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect Tavily Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Tavily data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous ZohoExpense Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Google Cloud SQL.
-
Validate Salesforce Marketing Data with QuerySurge
Access and validate Salesforce Marketing data in QuerySurge using the CData JDBC Driver.
-
Connect to Klipfolio Data in Ruby
Connect to Klipfolio data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Migrating data from Sugar CRM to Databricks using CData SSIS Components.
Easily push Sugar CRM data to Databricks using the CData SSIS Tasks for Sugar CRM and Databricks.
-
Create Oracle Financials Cloud-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle Financials Cloud Data from Nintex Workflow Cloud and build custom workflows using live Oracle Financials Cloud data.
-
Use the CData ODBC Driver for Email from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Email to connect to Email data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Email data in Excel.
-
Build Reckon-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Reckon data and build web apps with connectivity to live Reckon data.
-
Use Agno to Talk to Your Azure Data Catalog 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 Azure Data Catalog data for you.
-
Deploy the ADO.NET Provider for Snapchat Ads on an SSRS Report Server
Connect to Snapchat Ads 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 Attio Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Attio replication to IBM DB2.
-
Create Amazon Athena-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Amazon Athena Data from Klipfolio and build custom visualizations using live Amazon Athena data.
-
Landbot Reporting in OBIEE with the Landbot JDBC Driver
Deploy the Landbot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Informatica Mappings From/To a JDBC Data Source for RSS
Create RSS data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Act CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Act CRM and the Script function in FileMaker Pro to connect to Act CRM and work with Act CRM data in your FileMaker application.
-
Connect to Typeform Data from a Connection Pool in Jetty
The Typeform JDBC Driver supports connection pooling: This article shows how to connect faster to Typeform data from Web apps in Jetty.
-
Connect to Eventbrite Data in CloverDX (formerly CloverETL)
Transfer Eventbrite data using the visual workflow in the CloverDX data integration tool.
-
Connect to SAP Ariba Source Data in NetBeans
Connect to SAP Ariba Source data in NetBeans with the data source configuration wizard.
-
Integrate OpenCode with Live Bright Data Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Bright Data data from within your AI coding agent.
-
Integrate with Sybase IQ Data in JReport Designer
Create charts and reports based on Sybase IQ data in JReport Designer.
-
Connect to and Visualize Live Customer.io Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Customer.io data.
-
Integrate with live Notion Data in Jitterbit
Use CData Connect AI to connect to and integrate live Notion data in Jitterbit.
-
Automated Continuous MYOB AccountRight Replication to Databricks
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Databricks.
-
Visualize Discourse Data in TIBCO Spotfire through ADO.NET
Integrate Discourse data into dashboards in TIBCO Spotfire.
-
Integrate AgileCRM Data in Pentaho Data Integration
Build ETL pipelines based on AgileCRM data in the Pentaho Data Integration tool.
-
Connecting Moonlit Workflow with SAP ByDesign 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 SAP ByDesign data in real time.
-
Automated Continuous JSON Replication to Amazon S3
Use CData Sync for automated, continuous, customizable JSON replication to Amazon S3.
-
Create TaxJar-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to TaxJar Data from OutSystems and build custom enterprise apps using live TaxJar data.
-
Use Claude to Talk to Your Adobe Experience Manager 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 Adobe Experience Manager data for you.
-
How to connect to BambooHR Data in DBVisualizer
Integrate BambooHR data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Act CRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Act CRM Data and connect to Act CRM data in Akorbi Digital RunMyProcess.
-
Integrate Active Directory Data in Pentaho Data Integration
Build ETL pipelines based on Active Directory data in the Pentaho Data Integration tool.
-
Search External ShipEngine Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ShipEngine data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ShipEngine Data objects that you can access from apps and the dashboard.
-
Migrating data from Xero to Google BigQuery using CData SSIS Components.
Easily push Xero data to Google BigQuery using the CData SSIS Tasks for Xero and Google BigQuery.