CData Software - Knowledge Base

Recent Articles

---

• «
• 436
• 437
• 438
• 439
• 440
• 441
• 442
• 443
• 444
• 445
• »

• Hugging Face Reporting and Star Schemas in OBIEE

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

• Connect to Zoho Inventory Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Zoho Inventory and the SQL Gateway to access Zoho Inventory from Google Apps Script.

• Use the CData Software ODBC Driver for Bitly in MicroStrategy

  Connect to Bitly in MicroStrategy Developer using the CData Software ODBC Driver for Bitly.

• Build Data Flows from SQL Server to REST through SSIS

  Easily push SQL Server data to REST using the CData SSIS Tasks for REST.

• Query SendInBlue Data in DataGrip

  Create a Data Source for SendInBlue in DataGrip and use SQL to query live SendInBlue.

• Connect to Procore Data in CloverDX (formerly CloverETL)

  Transfer Procore using the visual workflow in the CloverDX data integration tool.

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

  Connect Gmail with Mendix to build apps using the CData JDBC Driver for Gmail.

• Access Live Zoho Books Data in Coginiti Pro

  Connect to and query live Zoho Books from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Build Salesforce Marketing-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesforce Marketing Cloud.

• How to load ShipEngine data into Elasticsearch via Logstash

  Introducing a simple method to load ShipEngine data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Connect to SAP Ariba Procurement from a Connection Pool in WebLogic

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

• Provide OData Services of Epicor Kinetic Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Epicor Kinetic by developing a WCF Service Application.

• Extend Google Sheets with Salesloft Data

  Make calls to Salesloft from Google Apps Script via the API Server.

• DataBind Shopify Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for Shopify with the DevExpress Windows Forms and Web controls to provide Shopify to a chart.

• Automated Continuous Freshsales Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Freshsales replication to PostgreSQL.

• Create Data Visualizations in Cognos BI with Guru Data

  Access Guru as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed EnterpriseDB to Power BI dashboards. Simply drag and drop EnterpriseDB into data visuals on the Power BI canvas.

• Getting Started with the CData SSIS Components for Dotmailer

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dotmailer.

• Access Live Email Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Email from your Excel spreadsheets.

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

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

• Publish Crystal Reports on SendInBlue Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SendInBlue.

• Automated Continuous Aha! Replication to Google Cloud SQL

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

• How to connect to Billsby Data with Squirrel SQL client

  Connect to Billsby and execute queries in the Squirrel SQL Client.

• 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 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 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.

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

  Create ETL applications and real-time data pipelines for Autopilot 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 Microsoft SharePoint into the Databricks platform and create visualization dashboards with real-time Microsoft SharePoint.

• Connect to Splunk Data in DBeaver

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

• Rapidly Develop Delighted-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Delighted.

• Build an OLAP Cube in SSAS from Salesforce Pardot Data

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

• Connect to Grafana Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

• Work with Helpscout Data in FoxPro

  Load Helpscout 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

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

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

• Connect to Workable Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Integrate Excel Data in Your Informatica Cloud Instance

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

• 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.

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

  Create a simple Workflow for SAP HANA 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.

• Integrating Antigravity CLI with Opsgenie via CData CLI

  Connect Opsgenie 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 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.

• 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 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 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 Business ByDesign through natural language.

• Analyze SQL Server Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Microsoft SQL Server and visualize live Microsoft SQL Server in Infragistics Reveal.

• 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 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 Storage.

• 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 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 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 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.

• 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 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 from your Oracle system.

• Publish Gumroad-Connected Dashboards in Tableau Server

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

• 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 from PowerShell? This article demonstrates how to utilize the MailChimp Cmdlets for tasks like connecting to MailChimp, 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 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 in your FileMaker applications.

• Visualize ConstantContact Data in Sisense

  Create an ElastiCube in Sisense app with access to ConstantContact.

• Automate SAP Ariba Procurement Data Replication to Azure Synapse

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

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

  Build workflows to access live QuickBooks Time 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 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 from Web applications running on WebLogic.

• How to integrate Metabase with DocuSign Data

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

• 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. 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 from PowerShell? This article demonstrates how to utilize the Mailgun Cmdlets for tasks like connecting to Mailgun, 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 through an SAP BusinessObjects universe.

• 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 Microsoft Office 365 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 Microsoft SQL Server in the Denodo Virtual DataPort Administrator.

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

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

• Connect to SAP SuccessFactors from a Connection Pool in WebLogic

  Use the CData JDBC Driver for SAP SuccessFactors to connect to SAP SuccessFactors 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 in Birst.

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

  Use CData Power BI Connectors to connect to live SFTP 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.

• 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 CRM & ERP for you.

• How to Access ConvertAPI Data Using Entity Framework

  This article shows how to access ConvertAPI 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 in JDBI.

• Build Visualizations of Paylocity Data in Birst

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

• How to connect to Sybase Data from IntelliJ

  Integrate connectivity to Sybase 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.

• «
• 436
• 437
• 438
• 439
• 440
• 441
• 442
• 443
• 444
• 445
• »