CData Software - Knowledge Base

Recent Articles

---

• «
• 1307
• 1308
• 1309
• 1310
• 1311
• 1312
• 1313
• 1314
• 1315
• 1316
• »

• Bidirectional Access to Flowlu Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Flowlu in Filemaker Pro for Mac or Windows.

• Use the CData ODBC Driver for Freshsales in Microsoft Power Query

  You can use the CData Freshsales ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Freshsales into Microsoft Power Query.

• Analyze Outlook Data in R via ODBC

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

• Publish Reports with Scrapfly Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Scrapfly.

• Connect to Klaviyo Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Klaviyo from Appeon PowerBuilder using the CData ADO.NET Provider for Klaviyo.

• Connect to Presto Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for Presto in Airbyte.

• Automated Continuous Cloudant Replication to PostgreSQL

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

• Natively Connect to SAP HANA XS Advanced Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to SAP HANA XS Advanced. Leverage the native support for ODBC in PHP.

• How to work with Amazon Athena Data in Apache Spark using SQL

  Access and process Amazon Athena Data in Apache Spark using the CData Software JDBC Driver.

• Automate Toggl Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Toggl replication to Azure Data Lake.

• Create Zoho Recruit Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Zoho Recruit from PowerBI.com to create Power BI Dataflows with real-time data.

• Getting Started with the CData ODBC Driver for SAP Ariba Source

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

• Build Charts with DocuSign Data in Clear Analytics

  Create dynamic charts and perform analytics based on DocuSign in Clear Analytics.

• Use Agno to Talk to Your Microsoft Exchange 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 Exchange for you.

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

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

• How to Connect to Live Workday Data from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Workday for you.

• Access Live Databricks Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Databricks from your Google Sheets.

• Migrating data from IBM Cloud Object Storage to Databricks using CData SSIS Components.

  Easily push IBM Cloud Object Storage to Databricks using the CData SSIS Tasks for IBM Cloud Object Storage and Databricks.

• Query Google Ad Manager Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Google Ad Manager and perform CRUD operations on Google Ad Manager from Node.js.

• Connect to QuickBooks Time Data in ACL Analytics

  Connect to QuickBooks Time via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to QuickBooks Time.

• Connect to Zoho Projects Data in RapidMiner

  Integrate Zoho Projects with standard components and data source configuration wizards in RapidMiner Studio.

• How to connect SharePoint with SAS xpt Data through external lists

  Provide SAS XPORT to SharePoint users as an external list.

• How to Import Data from SAP Concur into Google Sheets

  Import SAP Concur into a Google spreadsheet that is automatically refreshed.

• Use the CData Software JDBC Driver for Timely in MicroStrategy Desktop

  Connect to Timely in MicroStrategy Desktop using the CData Software JDBC Driver for Timely.

• Build a Simple VCL Application for OpenWeatherMap Data

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

• Back Up Mode 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 Mode data.

• How to use SQLAlchemy ORM to access Avro Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Avro.

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

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

• Use the CData Software ODBC Driver for Jumpseller in MicroStrategy Desktop

  Connect to Jumpseller in MicroStrategy Desktop using the CData Software ODBC Driver for Jumpseller.

• Import Google Campaign Manager 360 Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Google Campaign Manager 360 Data and provide access to live Google Campaign Manager 360 for custom reports in the Power BI Service.

• Automate Impala Data Replication to Azure Synapse

  Use CData Sync to customize and automate Apache Impala replication to Azure Synapse.

• Connect to Salesforce Pardot Data in Claris FileMaker Pro

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

• Access SuiteCRM Data from MySQL in PHP

  Connect to SuiteCRM through the standard MySQL libraries in PHP.

• Connect to Mocean Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Mocean.

• Access Live SAP BusinessObjects BI Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live SAP BusinessObjects BI from your Excel spreadsheets.

• How to Visualize Ontraport Data in Python with pandas

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

• How to connect to Xero Data from Spring Boot

  Connect to Xero in a Spring Boot Application using the CData JDBC Driver for Xero

• Use Claude to Talk to Your Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.

• DataBind Sugar CRM Data to the DevExpress Data Grid

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

• Connect to Adobe Commerce Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Adobe Commerce to connect to Adobe Commerce and execute queries in PowerBuilder.

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

  Use CData Power BI Connectors to visualize Clari in Power BI.

• Automate IBM Informix Integration Tasks from PowerShell

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

• How to connect and process Apache Parquet from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Parquet.

• Integrate ConvertAPI Data in Your Informatica Cloud Instance

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

• Connect Toggl to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Toggl with IBM WebSphere for seamless data integration and connectivity.

• Automate Insightly Data Replication to SAP HANA

  Use CData Sync to customize and automate Insightly replication to SAP HANA.

• Analyze SQL Server Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Microsoft SQL Server and visualize Microsoft SQL Server in SAP Analytics Cloud.

• How to Build an ETL App for Google Campaign Manager 360 Data in Python with CData

  Create ETL applications and real-time data pipelines for Google Campaign Manager 360 in Python with petl.

• Access Live Tally Data in Excel 365 Online (Excel for the web)

  Connect to Tally ERP from Excel 365 Online (Excel for the web) with CData Connect AI.

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

• Use Dash to Build to Web Apps on Amazon Athena Data

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

• Create SAP SuccessFactors LMS-Connected Applications in Appsmith

  Connect to SAP SuccessFactors LMS Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP SuccessFactors LMS.

• Use JayDeBeApi to access Workday Data in Python

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

• Use the CData ODBC Driver for Zendesk from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Zendesk to connect to Zendesk from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zendesk in Excel.

• Natively Connect to Zoho Books Data in PHP

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

• Building Dynamic Web Pages with Oracle Sales Data Using AngularJS

  Create single-page applications with live connectivity to Oracle Sales using the CData API Server.

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

• Connect to Zendesk Data Using the Script Function in Claris FileMaker Pro

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

• Create Zoho Inventory-Connected Enterprise Applications in OutSystems

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

• Use the CData ODBC Driver for Postmark from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Postmark to connect to Postmark from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Postmark in Excel.

• Working with SAP Business Warehouse Data in LINQPad

  Execute LINQ queries to SAP Business Warehouse in LINQPad.

• Use the CData Software JDBC Driver for Amazon S3 in MicroStrategy Web

  Connect to Amazon S3 in MicroStrategy Web using the CData Software JDBC Driver for Amazon S3.

• How to Query Live Acumatica Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Acumatica ERP data in natural language using Python.

• Create a Data Access Object for HelloSign Data using JDBI

  A brief overview of creating a SQL Object API for HelloSign in JDBI.

• Automate REST Data Replication to SAP HANA

  Use CData Sync to customize and automate REST replication to SAP HANA.

• Integrate Google Calendar Data in Your Informatica Cloud Instance

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

• Getting Started with the CData Power BI Connector for Insightly

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

• Automated Continuous eBay Analytics Replication to Snowflake

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

• Analyze HCL Domino Data in Cognos Analytics

  Use CData Connect AI to connect to HCL Domino Data from Cognos Analytics and analyze live HCL Domino.

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

• Build AI Agents with EnterpriseDB Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live EnterpriseDB through CData Connect AI.

• DataBind Charts to LaunchDarkly Data

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

• Integrating LangChain with Kintone Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Kintone within automated workflows.

• How to connect PolyBase to SAP Netweaver Gateway

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Netweaver Gateway.

• Replicate WooCommerce Data to Multiple Databases

  Replicate WooCommerce to disparate databases with a point-and-click configuration.

• Create Data Visualizations in Cognos BI with SendGrid Data

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

• How to Seamlessly Import Google Calendar Data into IBM SPSS Modeler

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

• Import and Visualize SendPulse Data in Power View

  Create data visualizations based on SendPulse in Excel.

• Access Live OnePageCrm Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate OnePageCrm into the statistical analysis tools available in SAS JMP. This article shows how to use OnePageCrm in the Graph Builder and Query Builder.

• Analyze Highrise Data in R via ODBC

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

• Analyze Elasticsearch Data with Power Pivot

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

• How to Access Todoist Data Using Entity Framework

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

• Import Real-Time CSV Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use CSV/TSV Files in ColdFusion.

• Use the CData Software ODBC Driver for SAS xpt in MicroStrategy

  Connect to SAS XPORT in MicroStrategy Developer using the CData Software ODBC Driver for SAS xpt.

• Exa Reporting in OBIEE with the Exa JDBC Driver

  Deploy the Exa JDBC driver on OBIEE to provide real-time reporting across the enterprise.

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

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

• How to Access Live Exa Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for Exa enables you to integrate Exa into workflows built using Microsoft Power Automate Desktop.

• Query Google Calendar Data in DataGrip

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

• Access Live Facebook Ads Data in Excel 365 Online (Excel for the web)

  Connect to Facebook Ads from Excel 365 Online (Excel for the web) with CData Connect AI.

• Connect to Bugsnag Data in DBeaver

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

• Visualize Live Presto Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Presto.

• Consume Kafka OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Kafka feeds that reflect any changes in SAP Lumira.

• Using the CData Software ODBC Driver for FreshBooks in PyCharm

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

• Build Semantic Layer Views for TigerGraph Data in APOS Live Data Gateway

  Use the CData Connector for TigerGraph in APOS Live Data Gateway to build Semantic Layer Views for TigerGraph.

• Bridge SageHR Connectivity with Apache NiFi

  Access and process SageHR in Apache NiFi using the CData JDBC Driver.

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

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

• Connect to Notion Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Notion.

• Automated Continuous Vertica Replication to SingleStore

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

• LINQ to NetSuite Data

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the NetSuite Data Provider.

• Moving Data from Teamgate to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Teamgate data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• «
• 1307
• 1308
• 1309
• 1310
• 1311
• 1312
• 1313
• 1314
• 1315
• 1316
• »