CData Software - Knowledge Base

Recent Articles

• «
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• »

• Automated Continuous Basecamp Replication to SingleStore

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

• Create a Data Access Object for Paylocity using JDBI

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

• Publish Reports with SAP in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP ERP/NetWeaver.

• How to Connect DBeaver to Azure Active Directory via a JDBC Driver

  Manage Azure Active Directory with visual tools in DBeaver like the query browser.

• Build MailChimp-Connected Dashboards Using Zoho Analytics

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

• Connect and Visualize Live SAP Concur Data in Databricks Lakehouse Federation with CData Connect Cloud

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

• Build Semantic Layer Views for Twitter Ads in APOS Live Data Gateway

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

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

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

• Connect to Act-On in Aqua Data Studio

  Access Act-On from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Build a Simple VCL Application for Redis

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

• Connect to Greenhouse in CloverDX (formerly CloverETL)

  Transfer Greenhouse using the visual workflow in the CloverDX data integration tool.

• How to update Twitter from Excel

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

• How to Query Live Microsoft Exchange in Claude Desktop

  Connect to and query live Microsoft Exchange in Claude Desktop using the CData MCP Server.

• Integrate Real-Time Access to SAP BusinessObjects BI in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP BusinessObjects BI in real time.

• Automated Continuous DB2 Replication to PostgreSQL

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

• How to connect to Microsoft Planner in DBVisualizer

  Integrate Microsoft Planner with visual data analysis tools and data connection wizards in DBVisualizer

• A PostgreSQL Interface for Elasticsearch using the CData ODBC Driver

  Use the SQL Gateway and Elasticsearch ODBC Driver to create a PostgreSQL entry-point for data access.

• Integrate Microsoft Teams in Your Informatica Cloud Instance

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

• Automate HBase Integration Tasks from PowerShell

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

• Automated Continuous SAP ByDesign Replication to Amazon S3

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

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

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

• Migrating data from Monday.com to Snowflake using CData SSIS Components.

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

• Connect to Excel Online in HULFT Integrate

  Connect to Excel Online as a JDBC data source in HULFT Integrate

• Explore Geographical Relationships in Email with Power Map

  Create data visualizations with Email in Power Map.

• Stream Active Directory into Apache Kafka Topics

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

• Connect to and Query Dynamics 365 in QlikView over ODBC

  Create data visualizations with Microsoft Dynamics 365 in QlikView.

• Automated Continuous Freshdesk Replication to Databricks

  Use CData Sync for automated, continuous, customizable Freshdesk replication to Databricks.

• Automated Continuous Dynamics 365 Business Central Replication to SingleStore

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

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

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

• Build GraphQL Visualizations in Tableau Cloud

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

• Automated Continuous Vertica Replication to Databricks

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

• DataBind Controls to Google Search Results in Delphi

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

• Use the CData Software ODBC Driver for SharePoint in MicroStrategy Web

  Connect to Microsoft SharePoint in MicroStrategy Web using the CData Software ODBC Driver for SharePoint.

• DataBind Controls to Dynamics 365 Business Central in C++Builder

  DataBind to Dynamics 365 Business Central in C++Builder with standard components and controls.

• Import Twitter into the Power BI Service for Visualizations

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

• Use the CData API Server in Microsoft Power BI

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

• Use Claude to Talk to Your SingleStore via CData Connect Cloud

  Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your SingleStore for you.

• How to Query Live Microsoft Planner in Claude Desktop

  Connect to and query live Microsoft Planner in Claude Desktop using the CData MCP Server.

• Create Reports from Facebook in Looker Studio

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

• Query Azure DevOps in DataGrip

  Create a Data Source for Azure DevOps in DataGrip and use SQL to query live Azure DevOps.

• DataBind Controls to Teradata in C++Builder

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

• Object-Relational Mapping (ORM) with SAP HANA XS Advanced Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP HANA XS Advanced into a Java-based ORM framework, Hibernate.

• Snowflake Reporting in OBIEE with the Snowflake JDBC Driver

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

• Build Automated WordPress-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live WordPress and build automated workflows in Zapier.

• Analyze AlloyDB in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Google AlloyDB and visualize Google AlloyDB in SAP Analytics Cloud.

• How to Work with Dynamics CRM in ETL Validator JDBC

  Connect to Dynamics CRM from ETL Validator jobs using the CData Software JDBC Driver.

• Query Basecamp in DataGrip

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

• Connect to Azure Active Directory from a Connection Pool in JBoss

  Integrate Azure Active Directory into Java servlets: Use the Management Console in JBoss to install the Azure Active Directory JDBC Driver.

• Automated Continuous SAP BusinessObjects BI Replication to SQL Server

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

• Consume Microsoft Project OData Feeds in PowerBuilder

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

• Access Snapchat Ads 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 Snapchat Ads.

• Analyze Marketo with Power Pivot

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

• Build a PostgreSQL Interface for ServiceNow using the CData JDBC Driver

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

• Load Microsoft Teams to a Database Using Embulk

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

• Replicate ServiceNow in Heroku for Use in Salesforce Connect

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

• Use Dash to Build to Web Apps on Cvent

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

• Work with Live LinkedIn in Power Query

  Use CData Connect Cloud to connect to LinkedIn and work with live LinkedIn in Microsoft Power Query.

• How to integrate HCL Domino with Apache Airflow

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

• Analyze Amazon S3 with Power Pivot

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

• Bridge SFTP Connectivity with Apache NiFi

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

• Automated Continuous MarkLogic Replication to MongoDB

  Use CData Sync for automated, continuous, customizable MarkLogic replication to MongoDB.

• A PostgreSQL Interface for Power BI XMLA (MySQL Remoting via JDBC)

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

• Use CData Connect Cloud to Access NetSuite in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live NetSuite CRM & ERP in the Power Pivot business intelligence tool.

• How to Access SendGrid Using Entity Framework

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

• Integrate with Live Google Sheets in MuleSoft (via CData Connect Cloud)

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

• Connect to Freshdesk as an External Source in Dremio

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

• Analyze Live Dynamics 365 in SAS Viya

  Use CData Connect Cloud to connect to Microsoft Dynamics 365 from SAS Viya and deploy self-service analytics using live Microsoft Dynamics 365.

• How to create an RPA flow for Snapchat Ads in UiPath Studio

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

• Replicate Wave Financial to Multiple Databases via the CData Sync CLI

  Replicate Wave Financial to disparate databases with a single configuration.

• Build Apps with Live Reckon Accounts Hosted in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Reckon Accounts Hosted into the Adalo platform and build custom mobile and web applications with real-time Reckon Accounts Hosted.

• ETL ShipStation in Oracle Data Integrator

  This article shows how to transfer ShipStation into a data warehouse using Oracle Data Integrator.

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

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

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

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

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

  Use CData ODBC drivers to import and use Microsoft SharePoint in ColdFusion.

• Integrate Real-Time Access to SAP HANA XS Advanced in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP HANA XS Advanced in real time.

• Connect to Okta in Ruby

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

• Exact Online Reporting and Star Schemas in OBIEE

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

• Connect to Elasticsearch from PowerBuilder via JDBC

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

• Build Asana-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Asana from Choreo and build custom apps using live Asana.

• Analyze Clio in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Clio and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Natively Connect to GitHub in PHP

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

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

  Use CData ODBC drivers to import and use Apache Avro in ColdFusion.

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

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

• How to Import Data from FHIR into Google Sheets

  Import FHIR into a Google spreadsheet that is automatically refreshed.

• Connect to Azure Table as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Table Storage.

• Automated Continuous Highrise Replication to Databricks

  Use CData Sync for automated, continuous, customizable Highrise replication to Databricks.

• Enable the Splunk JDBC Driver in KNIME

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

• Connect to and Query CockroachDB in QlikView over ODBC

  Create data visualizations with CockroachDB in QlikView.

• Connect to SurveyMonkey in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automate SAP HANA Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live SAP HANA and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Access IBM Cloud Object Storage as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access IBM Cloud Object Storage from your Oracle system.

• Operational Reporting on ClickUp from Spotfire Server

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

• Build Dashboards with Azure Analysis Services in DBxtra

  Create dynamic dashboards and perform analytics based on Azure Analysis Services in DBxtra.

• Build Odoo-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Odoo and create custom apps in Mendix.

• Visualize Stripe in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Stripe into TIBCO Spotfire.

• Connect to Adobe Analytics as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Adobe Analytics.

• Create Reports with Email in SAP Crystal Reports

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

• Visualize Redshift in TIBCO Spotfire through OData

  Integrate Amazon Redshift into dashboards in TIBCO Spotfire.

• Replicate Outreach.io in Heroku for Use in Salesforce Connect

  Replicate Outreach.io to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect to Oracle SCM in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Oracle SCM in Google Apps Script.

• «
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• »