CData Software - Knowledge Base

Recent Articles

---

• «
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• »

• How to Create Power BI Visual Reports with Real-Time Azure Table

  Use CData Power BI Connectors to visualize Azure Table Storage in Power BI.

• How to pipe Oracle Eloqua Reporting to CSV in PowerShell

  Use standard PowerShell cmdlets to access Oracle Eloqua Reporting tables.

• How to create an RPA flow for Google Contacts in UiPath Studio

  Use the Google Contacts ODBC Driver to create workflows that access real-time Google Contacts without any coding.

• Integrate Cursor with Live Shopify Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Shopify from within the editor.

• Integrating Dataiku with Acumatica via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Acumatica ERP.

• Connect to Greenplum in Jaspersoft Studio

  Execute SQL to remote Pivotal GreenPlum in Jaspersoft Studio.

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

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

• Work with Dynamics 365 in FoxPro

  Load Microsoft Dynamics 365 into a FoxPro database. This article includes full code and a walk-through of the process.

• Automated Continuous CData Connect AI Replication to Oracle

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

• Edit and Search Raisers Edge NXT External Objects in Salesforce Connect (API Server)

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

• Automated Continuous Spark Replication to Local Delimited Files

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

• Automated Continuous Pipedrive Replication to PostgreSQL

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

• How to create BambooHR federated tables in MySQL

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

• Visualize PingOne from Tableau

  Use the Tableau Desktop business intelligence tool to connect to PingOne.

• Connect Box to IBM WebSphere Using the CData JDBC Driver

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

• How to publish and share Vault CRM dashboards with Tableau Server

  The CData ODBC driver for Vault CRM enables you integrate Veeva Vault & Vault CRM into Tableau dashboards.

• Create Power BI Reports on Real-Time SAP BusinessObjects BI

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

• Connect and Query Live CockroachDB Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live CockroachDB into Databricks

• How to connect to MariaDB with Squirrel SQL client

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

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

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

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

• Automated Continuous Adobe Analytics Replication to MySQL

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

• Visualize WordPress in TIBCO Spotfire through OData

  Integrate WordPress into dashboards in TIBCO Spotfire.

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

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

• How to Connect to LDAP Objects in Using Python: 6 Steps

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

• Automated Continuous Monday.com Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Monday.com replication to Google Cloud SQL.

• Connect to Excel as a Linked Server via SQL Gateway

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

• How to Access Epicor Kinetic Using Entity Framework

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

• Create Reports with Neo4J in SAP Crystal Reports

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

• Use the CData Software JDBC Driver for Dynamics NAV in MicroStrategy

  Connect to Microsoft Dynamics NAV in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics NAV.

• How to create Dynamics 365 Business Central federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Dynamics 365 Business Central in MySQL .

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

  The CData ODBC Driver for NetSuite enables you to integrate NetSuite CRM & ERP into workflows built using Microsoft Power Automate Desktop.

• Publish Reports with Salesforce in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Salesforce & Force.com.

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

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

• Create Data Visualizations in Cognos BI with Bitbucket

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

• Automated Zoho CRM Replication to Teradata

  Use CData Sync to Customize and automate Zoho CRM replication to Teradata.

• Build Voice Agents in ElevenLabs with access to Live LinkedIn

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live LinkedIn.

• Integrate WordPress in the Pentaho Report Designer

  Publish reports based on WordPress in the Pentaho BI tool.

• Visualize Eventbrite in Tableau

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

• Automated Continuous Dynamics 365 Business Central Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Microsoft Access.

• Automated Continuous Excel Replication to PostgreSQL

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

• Use Dash to Build to Web Apps on Vault CRM

  Create Python applications that use pandas and Dash to build Vault CRM-connected web apps.

• Query Shopify as a MySQL Database in Node.js

  Execute MySQL queries against Shopify from Node.js.

• Build a PostgreSQL Interface for Twitter Ads using the CData JDBC Driver

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

• Visualize Live Outreach.io in the Power BI Service

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

• Create Dashboards and Visualize Live Azure Active Directory in Geckoboard

  Use CData Connect AI to connect to live Azure Active Directory and create dashboards for real-time monitoring and visualization in Geckoboard.

• Analyze Microsoft Teams in R via JDBC

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

• Build MVC Applications with Connectivity to Slack

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

• Use Databricks Agent Bricks to Talk to Your OneNote via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft OneNote for you.

• Analyze Basecamp in R via JDBC

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

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

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

• Automated Continuous NetSuite Replication to SQLite

  Use CData Sync for automated, continuous, customizable NetSuite replication to SQLite.

• Bidirectional Access to Adobe Target from FileMaker Pro

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

• Use JayDeBeApi to access DocuSign in Python

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

• How to connect PolyBase to Azure Table

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

• Analyze Dynamics NAV in Infragistics Reveal

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

• Creating MailChimp-Connected Applications in Unqork

  You can use CData Connect AI to feed MailChimp to Unqork and build custom business apps.

• PowerShell Scripting to Replicate Twitter Ads to MySQL

  Write a simple PowerShell script to replicate Twitter Ads to a MySQL database.

• Integrate SAP in the Pentaho Report Designer

  Publish reports based on SAP ERP/NetWeaver in the Pentaho BI tool.

• Extend Google Sheets with Amazon DynamoDB

  Make calls to the API Server from Google Apps Script.

• Connect to Google Search Results from PowerBuilder via ADO.NET

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

• Validate Parquet with QuerySurge

  Access and validate Apache Parquet in QuerySurge using the CData JDBC Driver.

• Automate QuickBooks Replication to Couchbase

  Use CData Sync to Customize and automate QuickBooks Desktop replication to Couchbase.

• Natively Connect to Confluence in PHP

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

• Integrate Sage Cloud Accounting with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Sage Cloud Accounting with External Services.

• Automated Continuous SAP ByDesign Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Microsoft Access.

• DataBind Controls to Clio in C++Builder

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

• Connect to Google Search Results as an External Source in Dremio

  Use the CData JDBC Driver to connect to Google Search as an External Source in Dremio.

• Connect to Google Search Results as a Linked Server via SQL Gateway

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

• Integrate Google Campaign Manager 360 with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Google Campaign Manager 360 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Campaign Manager 360.

• How to publish and share Authorize.Net dashboards with Tableau Server

  The CData ODBC driver for Authorize.Net enables you integrate Authorize.Net into Tableau dashboards.

• How to Connect to Live Tableau CRM Analytics 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 Tableau CRM Analytics for you.

• Build a Simple VCL Application for Dropbox

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

• Build an OLAP Cube in SSAS from eBay

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

• Query Microsoft Dataverse through ODBC in Node.js

  Use node-odbc to execute SQL queries against Microsoft Dataverse (CDS) from Node.js.

• DataBind Controls to NetSuite in C++Builder

  DataBind to NetSuite CRM & ERP in C++Builder with standard components and controls.

• Create a Data Access Object for Freshdesk using JDBI

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

• Connect to Spark in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for Apache Spark SQL in Airbyte.

• Create Zoom Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Create Data Visualizations in Cognos BI with Pinterest

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

• Process & Analyze Vault CRM in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Vault CRM .

• Work with SuiteCRM in FoxPro

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

• Migrating data from SAP HANA XS Advanced to Snowflake using CData SSIS Components.

  Easily push SAP HANA XS Advanced to Snowflake using the CData SSIS Tasks for SAP HANA XS Advanced and Snowflake.

• Automated Continuous Office 365 Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Office 365 replication to Apache Cassandra.

• Import SendGrid into the Power BI Service for Visualizations

  Use CData Connect AI to connect to SendGrid and provide access to live SendGrid for custom reports in the Power BI Service.

• How to connect and process OData from Azure Databricks

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

• Build Procore-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Procore and build web apps with connectivity to live Procore.

• Use the CData SSIS Components to Insert New or Update Existing SAP Ariba Source Records from SQL Server

  Easily push SQL Server data to SAP Ariba Source using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP Ariba Source or update existing records with data from a SQL Server database.

• How to connect PolyBase to Shopify

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

• How to integrate eBay with Apache Airflow

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

• LINQ to Cvent

  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 Cvent Data Provider.

• Automated Authorize.Net Replication to Teradata

  Use CData Sync to Customize and automate Authorize.Net replication to Teradata.

• Rapidly Develop Eventbrite-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Integrate with Google Sheets in SnapLogic

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

• Import Redis Using Azure Data Factory

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

• Analyze Active Directory with Power Pivot

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

• Integrate Sybase in the Pentaho Report Designer

  Publish reports based on Sybase in the Pentaho BI tool.

• PowerShell Scripting to Replicate FTP to MySQL

  Write a simple PowerShell script to replicate FTP Servers to a MySQL database.

• Access Live SAP BusinessObjects BI in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP BusinessObjects BI through MCP integration.

• Visualize OData Services in Sisense

  Create an ElastiCube in Sisense app with access to OData.

• «
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• »