CData Software - Knowledge Base

Recent Articles

---

• «
• 561
• 562
• 563
• 564
• 565
• 566
• 567
• 568
• 569
• 570
• »

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

  Use CData ODBC drivers to import and use Google Directory in ColdFusion.

• Extend Google Sheets with Microsoft Ads Data

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

• Create Data Visualizations in Cognos BI with Klipfolio Data

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

• Getting Started with the CData Power BI Connector for PhantomBuster

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

• Replicate Jira Data in Heroku for Use in Salesforce Connect

  Replicate Atlassian Jira to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect to SQL Server Data from a Connection Pool in JBoss

  Integrate Microsoft SQL Server into Java servlets: Use the Management Console in JBoss to install the SQL Server JDBC Driver.

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

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

• How to Access Google Tasks Data Using Entity Framework

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

• Connect to and Query FTP Data in QlikView over ODBC

  Create data visualizations with FTP Servers in QlikView.

• Building Dynamic Web Pages with Facebook Data Using AngularJS

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

• Integrating Claude Code with Amazon S3 Data via CData Connect AI

  Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon S3 within assisted coding and automated development workflows.

• Analyze Landbot Data with Power Pivot

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

• Integrating Claude Code CLI with Excel 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.

• Create YouTube Analytics-Connected Applications in Appsmith

  Connect to YouTube Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to YouTube Analytics.

• Connect to MessageBird Data in Ruby

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

• Build Gmail-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Gmail Data and create custom apps in Bubble.

• Connect to Twilio Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Twilio using standard SQL.

• Create Informatica Mappings From/To a JDBC Data Source for Pipeline CRM

  Create Pipeline CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Use JayDeBeApi to access FormSite Data in Python

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

• Viewing Accelo Data in RAD Studio Data Explorer

  How to view Accelo in RAD Studio Data Explorer using the CData ODBC Driver for Accelo.

• Query Google Directory Data as a MySQL Database in Node.js

  Execute MySQL queries against Google Directory from Node.js.

• Load MongoDB Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MongoDB to a database.

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

  Use CData JDBC drivers to import and use Datadog in ColdFusion.

• Load Access Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Access to a database.

• DataBind Charts to Copper Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Copper 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 Snapchat Ads Data from PowerBuilder via ADO.NET

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

• Access Live MailChimp Data in AWS Lambda

  Connect to live MailChimp in AWS Lambda using the CData JDBC Driver.

• Connect to Wistia from a Connection Pool in WebLogic

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

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

• Explore Geographical Relationships in Paylocity Data with Power Map

  Create data visualizations with Paylocity in Power Map.

• Connect to SAS xpt Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live SAS XPORT.

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

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

• How to connect PolyBase to Sybase IQ

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

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

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

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

• How to create ZohoInvoice federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for ZohoInvoice in MySQL .

• Build Dashboards with LightSpeedRetail Data in DBxtra

  Create dynamic dashboards and perform analytics based on LightSpeedRetail in DBxtra.

• Stream Avro Data into Apache Kafka Topics

  Access and stream Apache Avro in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

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

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

• How to Access Facebook Ads Data Using Entity Framework

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

• Oracle HCM Cloud Data Cloud Connectivity

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

• Access Live PolarTeamPro Data in Coginiti Pro

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

• How to Build an ETL App for Adobe Commerce Data in Python with CData Connect AI

  Build ETL pipelines that read and write live Adobe Commerce in Python with petl and the CData Connect AI Python SDK.

• Using the CData Software ODBC Driver for ConvertKit in PyCharm

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

• Build a PostgreSQL Interface for Dropbox Data using the CData JDBC Driver

  Use the Remoting features of the Dropbox JDBC Driver to create a PostgreSQL entry-point for data access.

• Create a Data Access Object for Greenhouse Data using JDBI

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

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

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

• Connect to Okta Data in DBeaver

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

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

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

• Automate Aircall Integration Tasks from PowerShell

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

• Build Dashboards with Sage Intacct Data in DBxtra

  Create dynamic dashboards and perform analytics based on Sage Intacct in DBxtra.

• Connect to EmailOctopus in SpagoBI

  Create reports featuring live EmailOctopus in SpagoBI Studio. Host EmailOctopus reports on SpagoBI Server.

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

  Connect to real-time Salesforce & Force.com in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce.

• Connect and Query Live SAP Ariba Procurement Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live SAP Ariba Procurement into Databricks

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

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

• Build an OLAP Cube in SSAS from RSS Feeds

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

• Import and Visualize Google Ads Data in Power View

  Create data visualizations based on Google Ads in Excel.

• DataBind Controls to Oracle Eloqua Reporting Data in C++Builder

  DataBind to Oracle Eloqua Reporting in C++Builder with standard components and controls.

• Publish Crystal Reports on Elasticsearch Data

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

• Connect to Salesforce Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Salesforce & Force.com from Crystal Reports.

• Automate Neo4J Data Replication to Azure Synapse

  Use CData Sync to customize and automate Neo4J replication to Azure Synapse.

• Visualize Placid Data in Sisense

  Create an ElastiCube in Sisense app with access to Placid.

• Automated Google Campaign Manager 360 Data Replication to Teradata

  Use CData Sync to Customize and automate Google Campaign Manager 360 replication to Teradata.

• Connecting Pipedream with SAP Netweaver Gateway Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP Netweaver Gateway data in real time.

• Build Charts with Salesforce Data 360 Data in Clear Analytics

  Create dynamic charts and perform analytics based on Salesforce Data 360 in Clear Analytics.

• How to Connect DBeaver to Avalara AvaTax via a JDBC Driver

  Manage Avalara AvaTax with visual tools in DBeaver like the query browser.

• How to use SQLAlchemy ORM to access Microsoft Entra ID Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Entra ID.

• Automated Continuous Stack Exchange Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Stack Exchange replication to Amazon Redshift.

• Amazon Redshift: Million Row Challenge

  CData Software tests a one million row bulk load of Amazon Redshift data.

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

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

• Create Reports from Box Data in Looker Studio

  Use CData Connect AI to gain access to live Box and create custom reports in Looker Studio.

• Create Data Visualizations in Cognos BI with ADP Data

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

• Integrate with ShipStation Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live ShipStation in SnapLogic.

• How to connect to LDAP Objects in DBVisualizer

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

• Connect to and Query Lakebase Data in QlikView over ODBC

  Create data visualizations with Lakebase in QlikView.

• Feed LightSpeedRetail Data into FineReport

  How to set LightSpeedRetail as a JDBC data source in FineReport.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Ariba Procurement

  Provide connectivity to SAP Ariba Procurement through an SAP BusinessObjects universe.

• Create SSAS Tabular Models from GitHub Data

  How to build a SQL Server Analysis Service Tabular Model from GitHub using CData drivers.

• Choosing the Best Method to Connect Odoo to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Odoo ERP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Import Jira Data Using Azure Data Factory

  Use CData Connect AI to connect to Jira Data from Azure Data Factory and import live Atlassian Jira.

• Create Sugar CRM Reports on JasperReports Server

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

• How to Query Parquet Data in MySQL Workbench

  Execute MySQL queries against live Apache Parquet from MySQL Workbench.

• Using the CData Software ODBC Driver for Quickbase in PyCharm

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

• Enable the LionDesk JDBC Driver in KNIME

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

• Automated Continuous Oracle Replication to Snowflake

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

• Access Live Oracle Financials Cloud Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Oracle Financials Cloud from your Excel spreadsheets.

• Connect to Bitly from a Connection Pool in WebLogic

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

• Build Charts with Landbot Data in Clear Analytics

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

• Connect to Dynamics 365 Data from AWS Glue

  Use CData Connect AI to gain access to live Microsoft Dynamics 365 from your AWS Glue jobs.

• Validate Mailjet Data with QuerySurge

  Access and validate Mailjet in QuerySurge using the CData JDBC Driver.

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

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

• How to Build an ETL App for QuickBooks Online Data in Python with CData Connect AI

  Build ETL pipelines that read and write live QuickBooks Online in Python with petl and the CData Connect AI Python SDK.

• DataBind Controls to Monday.com Data in C++Builder

  DataBind to Monday.com in C++Builder with standard components and controls.

• Edit and Search Salesloft External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Salesloft to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Salesloft objects that you can access from apps and the dashboard.

• Migrating data from Figshare to Databricks using CData SSIS Components.

  Easily push Figshare to Databricks using the CData SSIS Tasks for Figshare and Databricks.

• Use Manus AI to Talk to Your Amazon Athena Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Amazon Athena.

• Integrating Kiro CLI with YouTube Analytics 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 connect to Cvent Data from Spring Boot

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

• Work with Google Sheets Data in FoxPro

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

• Moving Data from Blackbaud FE NXT to SQL Server Using Toad Data Point and CData ODBC Driver

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

• «
• 561
• 562
• 563
• 564
• 565
• 566
• 567
• 568
• 569
• 570
• »