CData Software - Knowledge Base

Recent Articles

• «
• 518
• 519
• 520
• 521
• 522
• 523
• 524
• 525
• 526
• 527
• »

• Working with Snapchat Ads in LINQPad

  Execute LINQ queries to Snapchat Ads in LINQPad.

• Prepare, Blend, and Analyze Facebook in Alteryx Designer (Connect AI)

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

• How to Connect to Live Gmail 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 Gmail through natural language.

• Connect to Amazon Athena in DBArtisan

  Use wizards in DBArtisan to configure Amazon Athena as a data source.

• Build Cosmos DB-Connected Apps in Bubble

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

• Visualize Live Blackbaud FE NXT in the Power BI Service

  Use CData Connect AI to connect to live Blackbaud FE NXT and create custom reports in the Power BI Service through the On-Premises Gateway.

• Integrate Sage 50 UK with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Sage 50 UK with External Services.

• Getting Started with the CData SSIS Components for Instagram

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

• Access Live Azure Analysis Services in Coginiti Pro

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

• Provide OData Services of SendGrid from a WCF Application

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

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

  Connect to SAP Ariba Source in MicroStrategy Developer using the CData Software ODBC Driver for SAP Ariba Source.

• Connect to Splunk as a SQL Server Linked Server

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

• Automate NetSuite Replication to Azure Data Lake

  Use CData Sync to customize and automate NetSuite CRM & ERP replication to Azure Data Lake.

• Excel Spreadsheet Automation on Act CRM with the QUERY Formula

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

• Access Live Dropbox in AWS Lambda

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

• How to Connect to Live Azure Active Directory 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 Azure Active Directory without replication.

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

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

• Replicate Multiple ConstantContact Accounts via the CData Sync CLI

  Replicate multiple ConstantContact accounts to one or many databases.

• LINQ to Avalara AvaTax

  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 Avalara AvaTax Data Provider.

• How to Access Live Dynamics 365 in Visual Studio Code via Cline

  Run the CData MCP Server for Dynamics 365 on Windows Subsytem for Linux (WSL) and connect to live Microsoft Dynamics 365 from the Cline extension in Visual Studio Code.

• Automated Continuous Cosmos DB Replication to AlloyDB

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

• Build Dashboards with Azure Active Directory in DBxtra

  Create dynamic dashboards and perform analytics based on Azure Active Directory in DBxtra.

• Access Shippo from MySQL in Amazon QuickSight

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

• Use the CData ODBC Driver for Amazon Marketplace from SharePoint Excel Services

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

• How to Work with SAS xpt in ETL Validator JDBC

  Connect to SAS xpt from ETL Validator jobs using the CData Software JDBC Driver.

• How to Access Okta Using Entity Framework

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

• SFTP Reporting in OBIEE with the SFTP JDBC Driver

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

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

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

• Bind Live Workday Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Workday data

• Automated Continuous JSON Replication to SingleStore

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

• Connect to Shopify in RazorSQL

  Connect to Shopify from wizards and query Shopify from the GUI in the RazorSQL database management tool.

• Replicate Azure Synapse to Multiple Databases

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

• Validate Salesloft with QuerySurge

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

• eBay Reporting and Star Schemas in OBIEE

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

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Raisers Edge NXT using the Model Context Protocol.

• Analyze Live Cosmos DB in SAS Viya

  Use CData Connect AI to connect to Azure Cosmos DB from SAS Viya and deploy self-service analytics using live Azure Cosmos DB.

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

  Provide connectivity to SAP HANA through an SAP BusinessObjects universe.

• How to load Stripe data into Elasticsearch via Logstash

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

• How to connect PolyBase to Twitter

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

• Automated Continuous Klipfolio Replication to Local Delimited Files

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

• Provide OData Services of Airtable from a WCF Application

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

• Automated Continuous Kintone Replication to MySQL

  Use CData Sync for automated, continuous, customizable Kintone replication to MySQL.

• Working with QuickBooks using LINQPad

  The CData ADO.NET Providers can be used from many applications and development environments. This article shows how to use the CData ADO.NET Provider for QuickBooks to connect to QuickBooks in LINQPad. Although this example uses the QuickBooks Data Provider, the same process applies to any CData ADO.NET Providers.

• Integrating LangGraph with Jira via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Atlassian Jira within automated workflows.

• Automated Continuous Sugar CRM Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Sugar CRM replication to Amazon Redshift.

• Analyze Sage 50 UK in R via ODBC

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

• Connect to Sage 300 in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Using the CData Software ODBC Driver for Email in PyCharm

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

• Use Microsoft Copilot Studio to talk to your SAP Ariba Procurement via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Ariba Procurement for you.

• Build ShipStation Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live ShipStation and build visualizations in Tableau Cloud.

• Integrate with Live Exact Online in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Exact Online from the MuleSoft Anypoint Platform to integrate live Exact Online into custom reports and dashboards.

• Access Live Elasticsearch in AWS Lambda (with IntelliJ IDEA)

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

• Use the CData ODBC Driver for SAP Ariba Source from SharePoint Excel Services

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

• ETL Reckon Accounts Hosted in Oracle Data Integrator

  This article shows how to transfer Reckon Accounts Hosted into a data warehouse using Oracle Data Integrator.

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

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

• Create Data Visualizations in Cognos BI with Couchbase

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

• How to integrate Exact Online with Apache Airflow

  Access and process Exact Online in Apache Airflow using the CData JDBC Driver.

• How to connect and process Sage 300 from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Sage 300.

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

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

• Connect to Zoho Books in the Denodo Platform

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

• Add Marketo to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Marketo with the Informatica Enterprise Data Catalog to classify and organize data.

• Integrating LangGraph with Odoo via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Odoo ERP within automated workflows.

• Operational Reporting on Wave Financial from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Wave Financial.

• Connect IBM Informix to IBM WebSphere Using the CData JDBC Driver

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

• Operational Reporting on FTP from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote FTP Servers.

• Automated Continuous Aha Replication to Google BigQuery

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

• Access Live Splunk in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Splunk from your Excel spreadsheets.

• Validate Clio with QuerySurge

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

• Editing API Driver API Profiles

  Edit existing API Profiles to enable more SQL access to APIs.

• Connect to Google Search Results in RazorSQL

  Connect to Google Search from wizards and query Google Search from the GUI in the RazorSQL database management tool.

• Connect to CSV in CloverDX (formerly CloverETL)

  Transfer CSV/TSV Files using the visual workflow in the CloverDX data integration tool.

• Connect to RSS Feeds in DBArtisan

  Use wizards in DBArtisan to configure RSS Feeds as a data source.

• Connect to BigQuery in DBArtisan

  Use wizards in DBArtisan to configure Google BigQuery as a data source.

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

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

• Create Dynamic Typeform Grids Using the Infragistics XamDataGrid

  Learn how you can connect Typeform to Infragistics XamDataGrid to build dynamic grids.

• Create Oracle Eloqua Reports on JasperReports Server

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

• Create a Data Access Object for Dynamics CRM using JDBI

  A brief overview of creating a SQL Object API for Microsoft Dynamics CRM in JDBI.

• Consume Elasticsearch OData Feeds in SAP Lumira

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

• Analyze Spark in Cognos Analytics

  Use CData Connect AI to connect to Spark from Cognos Analytics and analyze live Apache Spark SQL.

• Automate Greenplum Replication to SAP HANA

  Use CData Sync to customize and automate Pivotal GreenPlum replication to SAP HANA.

• How to import Bing Ads into Apache Solr

  Use the CData Software JDBC Driver for Bing Ads in Data Import Handler and create an automated import of Bing Ads to Apache Solr Enterprise Search platform.

• Build a Simple VCL Application for Shippo

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

• Connect to SAP Ariba Source as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live SAP Ariba Source.

• Build MVC Applications with Connectivity to Drip

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

• Create Dashboards and Visualize Live Office 365 in Geckoboard

  Use CData Connect AI to connect to live Microsoft Office 365 and create dashboards for real-time monitoring and visualization in Geckoboard.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Pivotal GreenPlum using the Model Context Protocol.

• Connect to Azure Active Directory in DBArtisan

  Use wizards in DBArtisan to configure Azure Active Directory as a data source.

• Build Agents in Relevance AI with Access to Live Twitter Ads via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Twitter Ads within intelligent agent workflows.

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

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

• How to Work with Instagram in AWS Glue Jobs Using JDBC

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

• Automated Continuous SAP BusinessObjects BI Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Azure SQL Database.

• DataBind Controls to Pipedrive in C++Builder

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

• Connect to SharePoint from PowerBuilder via JDBC

  This article demonstrates how to access Microsoft SharePoint from PowerBuilder using the SharePoint JDBC Driver.

• Build Cloudant Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live IBM Cloudant and build visualizations in Tableau Cloud.

• Integrating LangGraph with Oracle via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Database within automated workflows.

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

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

• Build Pipelines with Live Redis in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Redis from Google Cloud Data Fusion, enabling the integration of live Redis into the building and management of effective data pipelines.

• How to Access Live Teradata in Power Automate Desktop via ODBC

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

• How to Connect to Live Sage 200 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 Sage 200 for you.

• How to integrate Metabase with Google Contacts

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

• «
• 518
• 519
• 520
• 521
• 522
• 523
• 524
• 525
• 526
• 527
• »