CData Software - Knowledge Base

Recent Articles

---

• «
• 874
• 875
• 876
• 877
• 878
• 879
• 880
• 881
• 882
• 883
• »

• Import Real-Time Paymo Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Paymo in ColdFusion.

• How to work with QuickBooks Time Data in Apache Spark using SQL

  Access and process QuickBooks Time Data in Apache Spark using the CData Software JDBC Driver.

• Connect to Real-Time Facebook Ads Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for Facebook Ads and Dataflow to import and use Facebook Ads in Power Apps.

• Access Live Power BI XMLA Data in TIBCO Data Virtualization

  Use the Power BI XMLA Tibco DV Adapter to create a Power BI XMLA data source in TIBCO Data Virtualization Studio and gain access to live Power BI XMLA from your TDV Server.

• Use the CData Software JDBC Driver for SAP HANA in MicroStrategy

  Connect to SAP HANA in MicroStrategy Developer using the CData Software JDBC Driver for SAP HANA.

• How to Build an ETL App for Sage Cloud Accounting Data in Python with CData Connect AI

  Build ETL pipelines that read and write live Sage Business Cloud Accounting in Python with petl and the CData Connect AI Python SDK.

• Query Dynamics CRM Data in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft Dynamics CRM.

• Create Power BI Reports on Real-Time Bugsnag Data

  Use the CData ODBC Driver for Bugsnag to visualize Bugsnag in Power BI Desktop.

• Integrate Placid Data in Your Informatica Cloud Instance

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

• Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy Web

  Connect to SAP Ariba Source in MicroStrategy Web using the CData Software JDBC Driver for SAP Ariba Source.

• Use the CData Software ODBC Driver for Bright Data in SAS for Real-Time Reporting and Analytics

  Connect to real-time Bright Data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Bright Data.

• Publish Twitter Ads-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Twitter Ads.

• DataBind Charts to Timely Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Timely 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 to Hacker News Data in Claris FileMaker Pro

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

• Access GraphQL Data from MySQL in Amazon QuickSight

  Connect to GraphQL and build visualizations of GraphQL using a MySQL Connection in Amazon QuickSight.

• Import Real-Time SAP HANA Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use SAP HANA in ColdFusion.

• Getting Started with the CData ADO.NET Provider for Bright Data

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

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

  Create an ODBC connection to Jira in Informatica and browse and transfer Atlassian Jira.

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

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

• Create Reports with CSV Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date CSV/TSV Files.

• Connect to REST Data in JRuby

  Create a simple JRuby app with access to live REST.

• Connect to Workday Data in JRuby

  Create a simple JRuby app with access to live Workday.

• Integrate Live Opsgenie Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Opsgenie to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Analyze Excel Online Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Microsoft Excel Online in Microsoft R Open.

• Create Data Visualizations in Cognos BI with Freshsales Data

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

• Prepare, Blend, and Analyze Vault CRM Data in Alteryx Designer (ODBC)

  Build workflows to access live Veeva Vault & Vault CRM for self-service data analytics.

• How to Connect to Live Blackbaud FE NXT Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Blackbaud FE NXT without replication.

• Connect to Insightly Data in Google Apps Script via SQL Gateway

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

• Prepare, Blend, and Analyze Google Drive Data in Alteryx Designer (ODBC)

  Build workflows to access live Google Drive for self-service data analytics.

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

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

• Analyze Zoho CRM Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Zoho CRM with the CData JDBC Driver for Zoho CRM.

• Design BIRT Reports on Avaza Data

  Provide current Avaza to your embedded analytics.

• Automated Continuous Gorgias Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Gorgias replication to Snowflake.

• How to Query SAP Concur Data in MySQL Workbench

  Execute MySQL queries against live SAP Concur from MySQL Workbench.

• How to Connect to Live Oracle HCM Cloud 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 Oracle HCM Cloud for you.

• Integrate Real-Time Access to Microsoft Dataverse in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Dataverse (CDS) in real time.

• Build a Simple VCL Application for Oracle Sales Data

  How to build a simple VCL Application to view Oracle Sales in RAD Studio using the CData ODBC Driver for Oracle Sales.

• Connect to and Query Dynamics 365 Business Central Data in QlikView over ODBC

  Create data visualizations with Dynamics 365 Business Central in QlikView.

• Connect to Real-Time Oracle Eloqua Reporting Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for Oracle Eloqua Reporting and Dataflow to import and use Oracle Eloqua Reporting in Power Apps.

• Connect to SAP SuccessFactors Data in Claris FileMaker Pro

  Use the CData ODBC Driver for SAP SuccessFactors in FileMaker Pro to connect to SAP SuccessFactors and work with SAP SuccessFactors in your FileMaker applications.

• Migrating data from Freshteam to Snowflake using CData SSIS Components.

  Easily push Freshteam to Snowflake using the CData SSIS Tasks for Freshteam and Snowflake.

• How to Connect to Live ActiveCampaign Data from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your ActiveCampaign for you.

• DataBind Charts to Paddle Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Paddle 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 to Azure Analysis Services Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Azure Analysis Services Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Integrate with live SingleStore Data in Jitterbit

  Use CData Connect AI to connect to and integrate live SingleStore in Jitterbit.

• Write a Simple Go Application to work with Oracle Financials Cloud Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Financials Cloud.

• Access Live GitHub Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live GitHub in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Build Google Search-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Search.

• Connect to Couchbase Data in Google Apps Script via Connect AI

  Use CData Connect AI to access Couchbase in Google Apps Script.

• Automated Continuous Vertica Replication to Oracle

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

• How to Work with Sugar CRM Data in ETL Validator JDBC

  Connect to Sugar CRM from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to Blackbaud FE NXT from Asprova with CData Software ODBC Driver for Blackbaud FE NXT

  This article shows how to connect faster to Blackbaud FE NXT data from Asprova.

• Connect to RabbitMQ Data in the Denodo Platform

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

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

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

• Create Apps from ShipStation Data in Qlik Sense Cloud

  Use CData Connect AI to connect to ShipStation Data and build apps from live ShipStation in Qlik Sense Cloud.

• Connecting GenSpark with Epicor Kinetic Data via CData Connect AI MCP Server

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

• Use the CData Software JDBC Driver for Jira Assets in MicroStrategy

  Connect to Jira Assets in MicroStrategy Developer using the CData Software JDBC Driver for Jira Assets.

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

  Use CData Power BI Connectors to visualize Atlassian Confluence in Power BI.

• View Reports on Real-Time Dynamics 365 Data in Power BI Report Server

  Use the CData ODBC Driver for Dynamics 365 to visualize Microsoft Dynamics 365 in Power BI Desktop and then publish them to Power BI Report Server.

• Use Biml to Build SSIS Tasks to Replicate Reckon Accounts Hosted Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Reckon Accounts Hosted to SQL Server.

• Rapidly Develop Superchat-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 Superchat.

• How to Connect to ADP Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to ADP. Leverage the pyodbc module for ODBC in Python.

• Connect to Drip Data in Google Apps Script via SQL Gateway

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

• Access PabblySubscriptions Data from MySQL in PHP

  Connect to PabblySubscriptions through the standard MySQL libraries in PHP.

• How to Design Zendesk Power Apps with Database-Like Connectivity

  Gain real-time, database-like connectivity to Zendesk from mobile and tablet Power Apps.

• Getting Started with the CData Excel Add-In for SageHR

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SageHR.

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

• Connect to LaunchDarkly Data in Ruby

  Connect to LaunchDarkly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• How to connect to Raisers Edge NXT Data in DBVisualizer

  Integrate Raisers Edge NXT with visual data analysis tools and data connection wizards in DBVisualizer

• Use the CData JDBC Driver for Salesforce in MicroStrategy

  Connect to Salesforce data in MicroStrategy Developer using the CData JDBC Driver for Salesforce.

• Natively Connect to LDAP Objects in PHP

  The CData ODBC driver for LDAP enables you to create PHP applications with connectivity to LDAP. Leverage the native support for ODBC in PHP.

• Create Apps from CouchDB Data in Qlik Sense Cloud

  Use CData Connect AI to connect to CouchDB Data and build apps from live Apache CouchDB in Qlik Sense Cloud.

• Enable the FHIR JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with FHIR.

• How to connect PolyBase to Oracle Sales

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Sales.

• Getting Started with the CData JDBC Driver for EnterpriseDB

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for EnterpriseDB.

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

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

• Integrate SAP Business One Data in the Pentaho Report Designer

  Publish reports based on SAP Business One in the Pentaho BI tool.

• Process & Analyze Autopilot Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Autopilot Data.

• Automated Continuous Pipeliner CRM Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Google BigQuery.

• Publish Facebook-Connected Dashboards in Tableau Server

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

• How to publish and share Odoo Data dashboards with Tableau Server

  The CData ODBC driver for Odoo enables you integrate Odoo ERP into Tableau dashboards.

• Analyze JSON Services in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of JSON and visualize live JSON in Infragistics Reveal.

• Automated Continuous PagerDuty Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable PagerDuty replication to AlloyDB.

• Use the CData Software ODBC Driver for MYOB AccountRight in MicroStrategy

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

• Import Xero Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Xero Accounting. In this article, you will use the OData format to import Xero Accounting into Microsoft Power Query.

• Build Procore-Connected Apps in Choreo

  Use CData Connect AI to connect to Procore Data from Choreo and build custom apps using live Procore.

• Integrate with FreeAgent Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy FreeAgent to a JSON file on disk.

• How to Seamlessly Import ADP Data into IBM SPSS Modeler

  Integrate ADP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Visualize Live Elasticsearch Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Elasticsearch into custom reports in Power BI.

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

• Analyze Recurly Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Recurly with the CData JDBC Driver for Recurly.

• How to Work with QuickBooks Online Data in AWS Glue Jobs Using JDBC

  Connect to QuickBooks Online from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• How to Visualize Short.io Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Short.io in Python.

• Object-Relational Mapping (ORM) with Cohere Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Cohere into a Java-based ORM framework, Hibernate.

• Work with Live BigQuery Data in Power Query

  Use CData Connect AI to connect to Google BigQuery and work with live Google BigQuery in Microsoft Power Query.

• Automated Continuous Basecamp Replication to Vertica

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

• JDBC Driver Getting Started Guide

  A basic guide to connecting applications to data from anywhere using the CData JDBC Driver

• Connect to Authorize.Net Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Authorize.Net and the Script function in FileMaker Pro to connect to Authorize.Net and work with Authorize.Net in your FileMaker application.

• Visualize Excel Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Excel into TIBCO Spotfire.

• Migrating data from Google Forms to Google BigQuery using CData SSIS Components.

  Easily push Google Forms to Google BigQuery using the CData SSIS Tasks for Google Forms and Google BigQuery.

• «
• 874
• 875
• 876
• 877
• 878
• 879
• 880
• 881
• 882
• 883
• »