CData Software - Knowledge Base

Recent Articles

• «
• 135
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• 143
• 144
• »

• Integrate Cosmos DB in Pentaho Data Integration

  Build ETL pipelines based on Azure Cosmos DB in the Pentaho Data Integration tool.

• Excel Spreadsheet Automation on NetSuite with the QUERY Formula

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

• How to Import Data from Authorize.Net into Google Sheets

  Import Authorize.Net into a Google spreadsheet that is automatically refreshed.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Access Live Sage Intacct in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Sage Intacct from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

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

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

• How to connect to Klaviyo from Spring Boot

  Connect to Klaviyo in a Spring Boot Application using CData JDBC Klaviyo Driver

• Replicate Microsoft Exchange in Heroku for Use in Salesforce Connect

  Replicate Microsoft Exchange to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

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

• Visualize Instagram in Sisense

  Create an ElastiCube in Sisense app with access to Instagram.

• Design BIRT Reports on Microsoft Dataverse

  Provide current Microsoft Dataverse (CDS) to your embedded analytics.

• Import Real-Time Azure Synapse via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Azure Synapse in ColdFusion.

• Connect and Visualize Live Exact Online Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Exact Online into the Databricks platform and create visualization dashboards with real-time Exact Online.

• Automated Continuous Zendesk Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Zendesk replication to Azure SQL Database.

• Create Sage 200-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Sage 200 from OutSystems and build custom enterprise apps using live Sage 200.

• Connect to Sybase IQ in CloverDX (formerly CloverETL)

  Transfer Sybase IQ using the visual workflow in the CloverDX data integration tool.

• Access Live Adobe Analytics in AWS Lambda

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

• Import Real-Time Tableau CRM Analytics via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Tableau CRM Analytics in ColdFusion.

• Create Dynamic Avalara AvaTax Grids Using the Infragistics XamDataGrid

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

• Enable the SendGrid JDBC Driver in KNIME

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

• Amazon Athena Reporting in OBIEE with the Amazon Athena JDBC Driver

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

• Natively Connect to Slack in PHP

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

• Access Live Cosmos DB in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Azure Cosmos DB from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Visualize Airtable in Tableau

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

• Publish Snapchat Ads-Connected Dashboards in Tableau Server

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

• Create LinkedIn-Connected Nintex Workflows

  Use CData Connect Cloud to connect to LinkedIn from Nintex Workflow Cloud and build custom workflows using live LinkedIn.

• Build Data Flows from Workday to SQL Server using SSIS

  Easily back up Workday to SQL Server using the SSIS components for Workday.

• Connect to and Query Klaviyo in QlikView over ODBC

  Create data visualizations with Klaviyo in QlikView.

• Integrate Act-On into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Act-On and integrate live Act-On into your Power Automate tasks.

• Automate Exact Online Replication to Azure Synapse

  Use CData Sync to customize and automate Exact Online replication to Azure Synapse.

• Integrate with Bullhorn CRM using Apache Camel2

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

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

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

• Migrating data from Jira Assets to Snowflake using CData SSIS Components.

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

• How to import Active Directory into Apache Solr

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

• Automated Continuous SAS xpt Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SAS xpt replication to Microsoft Access.

• Add Azure Active Directory to Informatica Enterprise Data Catalog

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

• Deploy the ADO.NET Provider for Gmail on an SSRS Report Server

  Connect to Gmail from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Build Data Flows from SQL Server to Reckon through SSIS

  Easily push SQL Server data to Reckon using the CData SSIS Tasks for Reckon.

• How to connect and process IBM Informix from Azure Databricks

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

• Import Real-Time SAP Business One via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use SAP Business One in ColdFusion.

• How to Use a Microsoft Access Database to Update Azure Synapse in Real Time

  Update Azure Synapse data by creating a linked table in Microsoft Access with the CData Azure Synapse ODBC Driver.

• Replicate Cosmos DB to Multiple Databases via the CData Sync CLI

  Replicate Azure Cosmos DB to disparate databases with a single configuration.

• Use the CData Software ODBC Driver for Azure Data Lake Storage in MicroStrategy

  Connect to Azure Data Lake Storage in MicroStrategy Developer using the CData Software ODBC Driver for Azure Data Lake Storage.

• Query Pinterest in ColdFusion

  Write standard ColdFusion data access code to connect to Pinterest.

• LINQ to Email

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

• Connect to and Query HBase in QlikView over ODBC

  Create data visualizations with Apache HBase in QlikView.

• Build MariaDB-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to MariaDB from Zoho Analytics and import live MariaDB.

• Build Dashboards with MariaDB in Dundas BI

  Create dynamic dashboards and perform analytics based on MariaDB in Dundas BI.

• Connect to GraphQL in RapidMiner

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

• How to update Sugar CRM from Excel

  This article explains how to transfer data from Excel to Sugar CRM using the Excel Add-In for Sugar CRM.

• Create Reports from Asana in Looker Studio

  Use CData Connect Cloud to gain access to live Asana and create custom reports in Looker Studio.

• Feed Adobe Analytics into FineReport

  How to set Adobe Analytics as a JDBC data source in FineReport.

• Access Live MongoDB in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live MongoDB from your Excel spreadsheets.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed LinkedIn to Power BI dashboards. Simply drag and drop LinkedIn into data visuals on the Power BI canvas.

• How to Connect to Live Zoho CRM in n8n Workflows and Agents (via CData Connect Cloud)

  Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Zoho CRM for you.

• How to Query Oracle Eloqua in MySQL Workbench

  Execute MySQL queries against live Oracle Eloqua from MySQL Workbench.

• Automated Continuous Avro Replication to SingleStore

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

• Integrate Live Twitter Ads into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Twitter Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Twitter Ads.

• Consume Google Sheets OData Feeds in PowerBuilder

  This article demonstrates how to consume Google Sheets as OData feeds from PowerBuilder using the API Server.

• Natively Connect to Parquet in PHP

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

• Natively Connect to Salesforce Data Cloud in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Data Cloud. Leverage the native support for ODBC in PHP.

• Working with Bitbucket in LINQPad

  Execute LINQ queries to Bitbucket in LINQPad.

• Use the CData API Server to Access eBay in Microsoft PowerPivot

  Use the CData API Server to connect to live eBay in the Power Pivot business intelligence tool.

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

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

• Connect to MongoDB in JRuby

  Create a simple JRuby app with access to live MongoDB.

• DataBind Controls to WooCommerce in Delphi

  DataBind to WooCommerce in Delphi with standard data access components and controls.

• Automated Continuous SAP ByDesign Replication to AlloyDB

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

• Explore Geographical Relationships in Salesforce Pardot with Power Map

  Create data visualizations with Salesforce Pardot in Power Map.

• Integrate with Live Zoho CRM in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Zoho CRM from the MuleSoft Anypoint Platform to integrate live Zoho CRM into custom reports and dashboards.

• Connect to Basecamp in RazorSQL

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

• Connect to SharePoint in DBeaver

  Use the CData ODBC Driver to connect to Microsoft SharePoint in DBeaver.

• Back Up Facebook to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Facebook. In this article, we will employ an SSIS workflow to populate a database with Facebook data.

• Automated Continuous Zoho CRM Replication to SQLite

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

• Natively Connect to Azure Synapse in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Azure Synapse. Leverage the native support for ODBC in PHP.

• How to import Adobe Analytics into Apache Solr

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

• Automate Salesforce Marketing Replication to Azure Synapse

  Use CData Sync to customize and automate Salesforce Marketing Cloud replication to Azure Synapse.

• Create SSAS Tabular Models from Kintone

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

• Connect to SuiteCRM from PowerBuilder via ADO.NET

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

• Connect to and Visualize Live Quickbase in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Quickbase.

• Automated Continuous Twilio Replication to Amazon Redshift

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

• DataBind Dynamics 365 Business Central to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Dynamics 365 Business Central with the DevExpress Windows Forms and Web controls to provide Dynamics 365 Business Central to a chart.

• Analyze FHIR in Infragistics Reveal

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

• How to create Cosmos DB federated tables in MySQL

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

• Automated Continuous Google Calendar Replication to PostgreSQL

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

• Create Dynamic XML Grids Using the Infragistics XamDataGrid

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

• Build Visualizations of Coinbase in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Coinbase in Birst.

• Validate Basecamp with QuerySurge

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

• Visualize Live ActiveCampaign in the Power BI Service

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

• Automated Continuous Google Search Replication to SingleStore

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

• Connect to Sansan through External Services in Salesforce

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

• Connect to Wave Financial in DBeaver

  Use the CData ODBC Driver to connect to Wave Financial in DBeaver.

• Bridge Xero Connectivity with Apache NiFi

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Avalara AvaTax

  Provide connectivity to Avalara AvaTax through an SAP BusinessObjects universe.

• How to Access Live Salesforce Marketing in Visual Studio Code via Cline

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

• Connect to Smaregi from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Smaregi from Crystal Reports.

• Integrate with MariaDB in JReport Designer

  Create charts and reports based on MariaDB in JReport Designer.

• Create Active Directory Dataflows on PowerBI.com

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

• How to Visualize SAP Netweaver Gateway Data in Python with pandas

  Use pandas and other modules to analyze and visualize live SAP Netweaver Gateway in Python.

• Connect to Email from Asprova with CData Software ODBC Driver for Email

  This article shows how to connect faster to Email data from Asprova.

• DataBind Controls to MYOB AccountRight in Delphi

  DataBind to MYOB AccountRight in Delphi with standard data access components and controls.

• «
• 135
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• 143
• 144
• »