CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Salesforce Pardot
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesforce Pardot.
-
Connect to Calendly Data in CloverDX (formerly CloverETL)
Transfer Calendly using the visual workflow in the CloverDX data integration tool.
-
Manage SAP Ariba Source Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Ariba Source.
-
JobNimbus Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on JobNimbus facts in real time.
-
Integrate with SuiteCRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SuiteCRM to a JSON file on disk.
-
Connect to Active Directory Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Active Directory from Filemaker Pro on Mac.
-
Use CData Connect AI to Access Avalara AvaTax Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Avalara AvaTax in the Power Pivot business intelligence tool.
-
Visualize Live Oracle Eloqua Reporting Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Eloqua Reporting using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous NetSuite Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable NetSuite replication to Google Cloud SQL.
-
DataBind Controls to DocuSign Data in Delphi
DataBind to DocuSign in Delphi with standard data access components and controls.
-
Replicate Drift Data from PowerShell
Write a quick PowerShell script to query Drift. Use connectivity to the live data to replicate Drift to SQL Server.
-
Integrating LlamaIndex with Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Active Directory in real time.
-
Natively Connect to Front Data in PHP
The CData ODBC driver for Front enables you to create PHP applications with connectivity to Front. Leverage the native support for ODBC in PHP.
-
Create Dashboards and Visualize Live SQL Analysis Services Data in Geckoboard
Use CData Connect AI to connect to live SQL Analysis Services and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Elasticsearch Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Elasticsearch data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Import Kafka Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Kafka. In this article, you will use the OData format to import Apache Kafka into Microsoft Power Query.
-
Process & Analyze CockroachDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CockroachDB Data.
-
Connect to and Query OnePageCrm Data in QlikView over ODBC
Create data visualizations with OnePageCrm in QlikView.
-
Create Datasets from Google Ads in Domo Workbench and Build Visualizations of Google Ads Data in Domo
Use the CData Software ODBC Driver for Google Ads to create datasets from Google Ads in Domo Workbench and then build visualizations in the Domo service.
-
Design BIRT Reports on LaunchDarkly Data
Provide current LaunchDarkly to your embedded analytics.
-
Connect to Perplexity Data in Ruby
Connect to Perplexity in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Outreach.io Data in NetBeans
Connect to Outreach.io in NetBeans with the data source configuration wizard.
-
Integrating Dynamics CRM Data in Talend Cloud Data Management Platform
Connect Dynamics CRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Dynamics CRM.
-
Connect to Azure Synapse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Azure Synapse and the SQL Gateway to access Azure Synapse from Google Apps Script.
-
Connect to SAP SuccessFactors Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP SuccessFactors Data and connect to SAP SuccessFactors in Akorbi Digital RunMyProcess.
-
Build MVC Applications with Connectivity to TaxJar Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access TaxJar from an ASP.NET MVC application.
-
Automated Continuous Microsoft Entra ID Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to SQL Server.
-
How to connect to FormSite Data from IntelliJ
Integrate connectivity to FormSite with wizards in IntelliJ.
-
Integrating Kiro CLI 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 Visualize Teamgate Data in Python with pandas
Use pandas and other modules to analyze and visualize live Teamgate in Python.
-
Connect to Reckon from a Connection Pool in WebLogic
Use the CData JDBC Driver for Reckon to connect to Reckon from Web applications running on WebLogic.
-
Automated Continuous Teamwork Replication to SQLite
Use CData Sync for automated, continuous, customizable Teamwork replication to SQLite.
-
Publish Mailjet-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Mailjet.
-
Access Live eBay Analytics Data in TIBCO Data Virtualization
Use the eBay Analytics Tibco DV Adapter to create a eBay Analytics data source in TIBCO Data Virtualization Studio and gain access to live eBay Analytics from your TDV Server.
-
Visualize FHIR Data in TIBCO Spotfire through OData
Integrate FHIR into dashboards in TIBCO Spotfire.
-
Access Live Microsoft Planner Data in Coginiti Pro
Connect to and query live Microsoft Planner from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to LionDesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LionDesk using standard SQL.
-
Access Egnyte Data from MySQL in Amazon QuickSight
Connect to Egnyte and build visualizations of Egnyte using a MySQL Connection in Amazon QuickSight.
-
Build Hubstaff-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Hubstaff and build web apps with connectivity to live Hubstaff.
-
Configure the CData JDBC Driver for Google Ads in a Connection Pool in Tomcat
Connect to Google Ads from a connection pool in Tomcat.
-
Build MVC Applications with Connectivity to LaunchDarkly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LaunchDarkly from an ASP.NET MVC application.
-
Analyze GitHub Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for GitHub from Power Pivot. You will use the Table Import Wizard to load GitHub. You can visually build the import query or use any SQL supported by the driver.
-
Build Data Flows from SQL Server to MYOB AccountRight through SSIS
Easily push SQL Server data to MYOB AccountRight using the CData SSIS Tasks for MYOB AccountRight.
-
Bind Live PingOne Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live PingOne data
-
Visualize Strava Data in Sisense
Create an ElastiCube in Sisense app with access to Strava.
-
Use Agno to Talk to Your Dynamics 365 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 Microsoft Dynamics 365 for you.
-
Automated Continuous Salesloft Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesloft replication to Oracle.
-
Use the CData Software JDBC Driver for AfterShip in MicroStrategy
Connect to AfterShip in MicroStrategy Developer using the CData Software JDBC Driver for AfterShip.
-
Access Greenplum Data from MySQL in PHP
Connect to Greenplum through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Zoho Creator in MicroStrategy Desktop
Connect to Zoho Creator in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Creator.
-
How to Access Live Paymo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Paymo enables you to integrate Paymo into workflows built using Microsoft Power Automate Desktop.
-
Use the CData API Server to Access Sugar CRM Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sugar CRM in the Power Pivot business intelligence tool.
-
Integrate with live GitHub Data in Jitterbit
Use CData Connect AI to connect to and integrate live GitHub in Jitterbit.
-
Connect Avro to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Avro with IBM WebSphere for seamless data integration and connectivity.
-
Deploy the ADO.NET Provider for Rebilly on an SSRS Report Server
Connect to Rebilly 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.
-
Build HBase-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for HBase to explore live HBase Data in GitHub Copilot to assist with building HBase-powered applications.
-
Connect to Microsoft Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Ads to connect to Microsoft Ads and execute queries in PowerBuilder.
-
Model Hive Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Hive, enabling the direct import of real-time Apache Hive.
-
Create Informatica Mappings From/To a JDBC Data Source for FreeAgent
Create FreeAgent data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Microsoft Exchange Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to MongoDB.
-
Moving Data from Grafana to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Grafana data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Salesforce Data in Aqua Data Studio
Access Salesforce & Force.com from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Codex CLI with Pushbullet 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.
-
Migrating data from SAP Concur to Databricks using CData SSIS Components.
Easily push SAP Concur to Databricks using the CData SSIS Tasks for SAP Concur and Databricks.
-
Explore Geographical Relationships in Act-On Data with Power Map
Create data visualizations with Act-On in Power Map.
-
Import and Visualize LinkedIn Ads Data in Power View
Create data visualizations based on LinkedIn Ads in Excel.
-
Integrating Kiro CLI with Browserless 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.
-
Visualize Miro Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Miro.
-
How to connect and process Oracle Database from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Database.
-
Publish Certinia-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Certinia.
-
Automated Continuous SAP Netweaver Gateway Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Oracle.
-
Extract, Transform, and Load Mailjet Data in Informatica PowerCenter
Create a simple Workflow for Mailjet in Informatica PowerCenter.
-
Getting Started with the CData Python Connector for Lakebase
Learn to install and license the CData Python Connector
-
How to Use a Microsoft Access Database to Update OneNote Data in Real Time
Update OneNote data by creating a linked table in Microsoft Access with the CData OneNote ODBC Driver.
-
Connect to Google Ad Manager Data in HULFT Integrate
Connect to Google Ad Manager as a JDBC data source in HULFT Integrate
-
Create a Data Access Object for Basecamp Data using JDBI
A brief overview of creating a SQL Object API for Basecamp in JDBI.
-
Connect to Pinecone Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pinecone using standard SQL.
-
Visualize Spark Data in Sisense
Create an ElastiCube in Sisense app with access to Apache Spark SQL.
-
Create Dynamic Bullhorn CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Bullhorn CRM to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Freshdesk 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 Freshdesk through MCP integration.
-
Automated Continuous PolarTeamPro Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to OneLake in Microsoft Fabric.
-
Automated Continuous Zoom Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoom replication to MongoDB.
-
Back Up Active Directory to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Active Directory. In this article, we will employ an SSIS workflow to populate a database with Active Directory data.
-
Using the CData Software ODBC Driver for Amazon Athena in PyCharm
Connect to Amazon Athena as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon Athena.
-
Connect to Gong Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Gong as an External Source in Dremio.
-
How to use SQLAlchemy ORM to access Workday Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Workday.
-
How to Work with Coda Data in ETL Validator JDBC
Connect to Coda from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Bright Data Data in Ruby
Connect to Bright Data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Add MessageBird Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MessageBird with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Live Shopify Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Shopify enables you to integrate Shopify into workflows built using Microsoft Power Automate Desktop.
-
Create Google Directory Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Directory data access from reports, embedded analytics, and more.
-
How to Easily Query NetSuite Data in OpenOffice Base
Connect to NetSuite data in OpenOffice Base using the CData ODBC Driver for NetSuite and generate reports with live data insights.
-
How to Query Live Authorize.Net Data in Perplexity MacOS Desktop
Connect to and query live Authorize.Net Data in Perplexity Desktop using CData MCP Server.
-
Design BIRT Reports on Gmail Data
Provide current Gmail to your embedded analytics.
-
Integrating Cursor CLI with PhantomBuster 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.
-
Connect IBM Cloud Object Storage Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your IBM Cloud Object Storage using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Work with Pipeline CRM Data in ETL Validator JDBC
Connect to Pipeline CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Beeminder Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Beeminder from HeidiSQL.
-
Build DB2 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live IBM DB2 and build visualizations in Tableau.
-
Migrating data from Harvest to Snowflake using CData SSIS Components.
Easily push Harvest to Snowflake using the CData SSIS Tasks for Harvest and Snowflake.