CData Software - Knowledge Base

Recent Articles

---

• «
• 469
• 470
• 471
• 472
• 473
• 474
• 475
• 476
• 477
• 478
• »

• Excel Spreadsheet Automation on Jira Assets Data with the QUERY Formula

  Pull data from Jira Assets, automate spreadsheets, and more with the QUERY formula.

• ETL SAP Ariba Procurement in Oracle Data Integrator

  This article shows how to transfer SAP Ariba Procurement data into a data warehouse using Oracle Data Integrator.

• Automate Active Directory Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Active Directory data replication to Azure Data Lake.

• How to Easily Query Recurly Data in OpenOffice Base

  Connect to Recurly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• Replicate Multiple Contentful Accounts

  Replicate multiple Contentful accounts to one or many databases.

• How to Build an ETL App for Autopilot Data in Python with CData

  Create ETL applications and real-time data pipelines for Autopilot data in Python with petl.

• Connect and Visualize Live SharePoint Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live SharePoint data into the Databricks platform and create visualization dashboards with real-time SharePoint data.

• Connect to Splunk Data in DBeaver

  Use the CData ODBC Driver to connect to Splunk data in DBeaver.

• Build an OLAP Cube in SSAS from Salesforce Pardot Data

  Establish a connection to Salesforce Pardot data data from SQL Server Analysis Services, and use the Salesforce Pardot Data Provider to build OLAP cubes for use in analytics and reporting.

• Use Azure AI Foundry to Talk to Your Supabase 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 Supabase data for you.

• Connect to Grafana Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Grafana.

• Connect Factorial Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Factorial data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Work with Helpscout Data in FoxPro

  Load Helpscout data into a FoxPro database. This article includes full code and a walk-through of the process.

• Automated Continuous MailerLite Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable MailerLite replication to IBM DB2.

• Connect to Wrike Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Wrike.

• How to Create Power BI Visual Reports with Real-Time SAP ByDesign Data

  Use CData Power BI Connectors to visualize SAP ByDesign data in Power BI.

• Connect to Workable Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Workable.

• Integrate Excel Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Excel data from Informatica Cloud.

• Analyze Live Moosend Data in SAS Viya

  Use CData Connect AI to connect to Moosend data from SAS Viya and deploy self-service analytics using live Moosend data.

• Create Dropbox-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Dropbox Data from OutSystems and build custom enterprise apps using live Dropbox data.

• Extract, Transform, and Load SAP HANA Data in Informatica PowerCenter

  Create a simple Workflow for SAP HANA data in Informatica PowerCenter.

• Use JayDeBeApi to access SageHR Data in Python

  Use standard Python scripting and the development environment of your choice to access live SageHR data.

• Integrating Antigravity CLI with Opsgenie data via CData CLI

  Connect Opsgenie data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Connect to Toggl 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 Toggl and work with Toggl data in your FileMaker application.

• A PostgreSQL Interface for MailerLite Data using the CData ODBC Driver

  Use the SQL Gateway and MailerLite ODBC Driver to create a PostgreSQL entry-point for data access.

• Integrate LibreChat with Live TaxJar Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live TaxJar data from within the chat interface.

• Getting Started with the CData ODBC Driver for SAP Business One

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Business One.

• Manage Google Directory Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Google Directory.

• Connect to MariaDB Data from a Connection Pool in JBoss

  Integrate MariaDB data into Java servlets: Use the Management Console in JBoss to install the MariaDB JDBC Driver.

• Access Bitbucket Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Bitbucket data from HeidiSQL.

• Use Dash to Build to Web Apps on Factorial Data

  Create Python applications that use pandas and Dash to build Factorial-connected web apps.

• How to Connect to Live SAP ByDesign Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAP ByDesign data through natural language.

• Aweber Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Aweber data through CData Connect AI using different applications and tools.

• How to Work with Sage Intacct Data in ETL Validator JDBC

  Connect to Sage Intacct from ETL Validator jobs using the CData Software JDBC Driver.

• How to connect to Sentry Data in DBVisualizer

  Integrate Sentry data with visual data analysis tools and data connection wizards in DBVisualizer

• Create Azure Table-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Azure Table Data from Klipfolio and build custom visualizations using live Azure Table data.

• Use Claude to Talk to Your Zendesk 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 Zendesk data for you.

• Automated Continuous Lakebase Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Lakebase replication to Google Cloud SQL.

• Connect to Twilio Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Twilio data from Crystal Reports.

• Analyze SQL Analysis Services Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze SQL Analysis Services data with the CData JDBC Driver for SQL Analysis Services.

• How to connect to SAS Data Sets Data from Spring Boot

  Connect to SAS Data Sets in a Spring Boot Application using the CData JDBC Driver for SAS Data Sets

• Access Zoho Inventory 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 Zoho Inventory data.

• How to create an RPA flow for Procore Data in UiPath Studio

  Use the Procore ODBC Driver to create workflows that access real-time Procore data without any coding.

• Access Power BI XMLA Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Power BI XMLA data from your Oracle system.

• Publish Gumroad-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Gumroad data.

• Integrating FreeAgent Data in Talend Cloud Data Management Platform

  Connect FreeAgent Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

• Automate MailChimp Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access MailChimp data from PowerShell? This article demonstrates how to utilize the MailChimp Cmdlets for tasks like connecting to MailChimp data, automating operations, downloading data, and more.

• Create Power BI Reports on Real-Time Mistral AI Data

  Use the CData ODBC Driver for Mistral AI to visualize Mistral AI data in Power BI Desktop.

• Connect to Coda Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Coda and work with Coda data in your FileMaker applications.

• Visualize ConstantContact Data in Sisense

  Create an ElastiCube in Sisense app with access to ConstantContact data.

• Automate SAP Ariba Procurement Data Replication to Azure Synapse

  Use CData Sync to customize and automate SAP Ariba Procurement data replication to Azure Synapse.

• Connecting GenSpark with Discord Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Discord data without any replication or custom integration required.

• Automated Continuous Postmark Replication to Vertica

  Use CData Sync for automated, continuous, customizable Postmark replication to Vertica.

• Prepare, Blend, and Analyze QuickBooks Time Data in Alteryx Designer (Connect AI)

  Build workflows to access live QuickBooks Time data for self-service data analytics.

• Using the CData Software ODBC Driver for Todoist in PyCharm

  Connect to Todoist as an ODBC data source in PyCharm using the CData Software ODBC Driver for Todoist.

• How to Connect to & Open Kintone Data in Microsoft Excel

  This article uses the CData ODBC driver for Kintone to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Connect Quaderno Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Quaderno data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Grafana Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Grafana facts in real time.

• Connect to Rebilly from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Rebilly to connect to Rebilly data from Web applications running on WebLogic.

• Automated Continuous Auth0 Replication to Oracle

  Use CData Sync for automated, continuous, customizable Auth0 replication to Oracle.

• Connecting Moonlit Workflow with Toggl 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 Toggl data in real time.

• How to integrate Metabase with DocuSign Data

  Use CData Connect AI to connect to live DocuSign data and create an interactive dashboard in Metabase from DocuSign data.

• Analyze Oracle HCM Cloud Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Oracle HCM Cloud from Power Pivot. You will use the Table Import Wizard to load Oracle HCM Cloud data. You can visually build the import query or use any SQL supported by the driver.

• Automate Mailgun Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Mailgun data from PowerShell? This article demonstrates how to utilize the Mailgun Cmdlets for tasks like connecting to Mailgun data, automating operations, downloading data, and more.

• Create ElevenLabs Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time ElevenLabs data access from reports, embedded analytics, and more.

• Access Apify Data from MySQL in PHP

  Connect to Apify through the standard MySQL libraries in PHP.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Certinia

  Provide connectivity to Certinia data through an SAP BusinessObjects universe.

• Access Live iContact 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 iContact data through MCP integration.

• Build MVC Applications with Connectivity to ClickUp Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ClickUp from an ASP.NET MVC application.

• Getting Started with the CData Connect AI Python SDK for Office 365

  Install the CData Connect AI Python SDK to read and write live Office 365 data with standard DB-API 2.0 Python code.

• Excel Spreadsheet Automation on Beeminder Data with the QUERY Formula

  Pull data from Beeminder, automate spreadsheets, and more with the QUERY formula.

• Connect to SQL Server Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for SQL Server data in the Denodo Virtual DataPort Administrator.

• Model Typeform Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Typeform, enabling the direct import of real-time Typeform data.

• Create Informatica Mappings From/To an ODBC Data Source for Phoenix

  Create an ODBC connection to Phoenix in Informatica and browse and transfer Phoenix data.

• Connect to SAP SuccessFactors from a Connection Pool in WebLogic

  Use the CData JDBC Driver for SAP SuccessFactors to connect to SAP SuccessFactors data from Web applications running on WebLogic.

• Automated Continuous WordPress Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable WordPress replication to delimited files (CSV/TSV).

• Build Visualizations of Aweber Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aweber data in Birst.

• Integrate LibreChat with Live SparkPost Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SparkPost data from within the chat interface.

• Visualize Live SFTP Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live SFTP data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to Easily Query Zoho Inventory Data in OpenOffice Base

  Connect to Zoho Inventory data in OpenOffice Base using the CData ODBC Driver for Zoho Inventory and generate reports with live data insights.

• Use JayDeBeApi to access QuickBooks Online Data in Python

  Use standard Python scripting and the development environment of your choice to access live QuickBooks Online data.

• How to Connect to Live NetSuite Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your NetSuite data for you.

• How to Access ConvertAPI Data Using Entity Framework

  This article shows how to access ConvertAPI data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Create a Data Access Object for Monday.com Data using JDBI

  A brief overview of creating a SQL Object API for Monday.com data in JDBI.

• Build Visualizations of Paylocity Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Paylocity data in Birst.

• How to connect to Sybase Data from IntelliJ

  Integrate connectivity to Sybase data with wizards in IntelliJ.

• Connect to BambooHR Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live BambooHR data.

• Connect to ADP Data from a Connection Pool in JBoss

  Integrate ADP data into Java servlets: Use the Management Console in JBoss to install the ADP JDBC Driver.

• Connect to Yelp Data from PowerBuilder via JDBC

  This article demonstrates how to access Yelp data from PowerBuilder using the Yelp JDBC Driver.

• Access Dynamics 365 Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Dynamics 365 data from HeidiSQL.

• Import Bright Data Data Using Azure Data Factory

  Use CData Connect AI to connect to Bright Data Data from Azure Data Factory and import live Bright Data data.

• Build Apps with Live Dynamics CRM Data Using the Low-Code Development Platform of Mendix

  Connect Dynamics CRM data with Mendix to build apps using the CData JDBC Driver for Dynamics CRM.

• Visualize Live Bright Data Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Bright Data data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to Query Mailjet Data in MySQL Workbench

  Execute MySQL queries against live Mailjet data from MySQL Workbench.

• Access Oracle Service Cloud Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Service Cloud data from HeidiSQL.

• Integrating Kiro with REST 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 Excel Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Excel data in Python.

• Access Vault CRM Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Vault CRM data from your Oracle system.

• Connect to Redshift Data in Jaspersoft Studio

  Execute SQL to remote Redshift data in Jaspersoft Studio.

• DataBind Charts to Retently Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Retently 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.

• «
• 469
• 470
• 471
• 472
• 473
• 474
• 475
• 476
• 477
• 478
• »