CData Software - Knowledge Base

Recent Articles

• «
• 507
• 508
• 509
• 510
• 511
• 512
• 513
• 514
• 515
• 516
• »

• Building Dynamic Web Pages with Email Using AngularJS

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

• Use the CData Software JDBC Driver for Avalara AvaTax in MicroStrategy Web

  Connect to Avalara AvaTax in MicroStrategy Web using the CData Software JDBC Driver for Avalara AvaTax.

• Integrate Azure Synapse in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Synapse from Informatica Cloud.

• Working with SurveyMonkey in LINQPad

  Execute LINQ queries to SurveyMonkey in LINQPad.

• Connect Sybase to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Sybase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Query Aha in ColdFusion

  Write standard ColdFusion data access code to connect to Aha!.

• Connect to and Query Jira in QlikView over ODBC

  Create data visualizations with Atlassian Jira in QlikView.

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

  Use CData ODBC drivers to import and use Quickbase in ColdFusion.

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

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

• Automated Continuous Acumatica Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Acumatica ERP replication to OneLake in Microsoft Fabric.

• Access SharePoint Excel Services as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SharePoint Excel Services from your Oracle system.

• Connect to Aha from a Connection Pool in Jetty

  The Aha JDBC Driver supports connection pooling: This article shows how to connect faster to Aha! from Web apps in Jetty.

• Query Microsoft Exchange as a SQL Server Database in Node.js

  Execute SQL Server queries against Microsoft Exchange from Node.js.

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

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

• Build Data Flows from SQL Server to OneNote through SSIS

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

• SendGrid Cloud Connectivity

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

• Automate EventBrite Replication to Azure Synapse

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

• Excel Spreadsheet Automation on Zendesk with the QUERY Formula

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

• Automate Quickbase Replication to Azure Data Lake

  Use CData Sync to customize and automate Quickbase replication to Azure Data Lake.

• Visualize HDFS in TIBCO Spotfire through OData

  Integrate Apache HDFS into dashboards in TIBCO Spotfire.

• How to Build an ETL App for Google Campaign Manager 360 in Python with CData

  Create ETL applications and real-time data pipelines for Google Campaign Manager 360 in Python with petl.

• Automated Continuous Microsoft Dataverse Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft Dataverse (CDS) replication to OneLake in Microsoft Fabric.

• Connect to Microsoft Exchange as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Exchange.

• Automated Continuous ShipStation Replication to Apache Cassandra

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

• Integrate Amazon Athena into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Amazon Athena and integrate live Amazon Athena into your Power Automate tasks.

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

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

• Build Dashboards with ServiceNow in DBxtra

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

• Using the CData Software ODBC Driver for Microsoft OneDrive in PyCharm

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

• Query Bitbucket through ODBC in Node.js

  Use node-odbc to execute SQL queries against Bitbucket from Node.js.

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

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

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

  Connect to Todoist 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.

• Automated Continuous Zenefits Replication to Amazon Redshift

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

• Publish SAP Ariba Procurement-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAP Ariba Procurement.

• Analyze Google Campaign Manager 360 in Slingshot with CData API Server

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

• Automated Continuous Klipfolio Replication to MySQL

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

• Build MVC Applications with Connectivity to Microsoft Dataverse

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

• Connect to Calendly from a Connection Pool in JBoss

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

• How to integrate Zoho Projects with Apache Airflow

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

• Build Data Flows from SAP Business One to SQL Server using SSIS

  Easily back up SAP Business One to SQL Server using the SSIS components for SAP Business One.

• Build Charts with Sage 50 UK in Clear Analytics

  Create dynamic charts and perform analytics based on Sage 50 UK in Clear Analytics.

• Analyze YouTube Analytics in Looker

  Use CData Connect Cloud to connect to YouTube Analytics from Looker and build custom apps using live YouTube Analytics.

• Connect to Highrise in SpagoBI

  Create reports featuring live Highrise CRM in SpagoBI Studio. Host Highrise reports on SpagoBI Server.

• Connect to Freshdesk from a Connection Pool in JBoss

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

• Explore Geographical Relationships in Bitbucket with Power Map

  Create data visualizations with Bitbucket in Power Map.

• Work with Tally in FoxPro

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

• Visualize Live LinkedIn in the Power BI Service

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

• Automated Continuous Zoho Projects Replication to Local Delimited Files

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

• Create Data Visualizations Based On LinkedIn in Mode

  Use CData Connect Cloud to connect to LinkedIn from Mode and build visualizations using live

• How to connect to Adobe Analytics from Spring Boot

  Connect to Adobe Analytics in a Spring Boot Application using CData JDBC Adobe Analytics Driver

• Automated Continuous SAS xpt Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable SAS xpt replication to Apache Kafka.

• DataBind Controls to Zoho CRM in C++Builder

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

• How to Visualize ConstantContact Data in Python with pandas

  Use pandas and other modules to analyze and visualize live ConstantContact in Python.

• Connect to DocuSign in RapidMiner

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

• PowerShell Scripting to Replicate CouchDB to MySQL

  Write a simple PowerShell script to replicate Apache CouchDB to a MySQL database.

• Access Snowflake from MySQL in Amazon QuickSight

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

• Automated Continuous Shippo Replication to Local Delimited Files

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

• Visualize JotForm in TIBCO Spotfire through ADO.NET

  Integrate JotForm into dashboards in TIBCO Spotfire.

• How to connect to Adobe Commerce from IntelliJ

  Integrate connectivity to Adobe Commerce with wizards in IntelliJ.

• Access Live Oracle in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Oracle to create a Oracle Database source in TIBCO Data Virtualization Studio and gain access to live Oracle Database from your TDV Server.

• Create Google Drive-Connected Applications in Appsmith

  Connect to Google Drive via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Google Drive.

• Publish Reports with Calendly in SAP Crystal Reports

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

• Visualize Live Zoho Books of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Zoho Books using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to Access Microsoft Teams Using Entity Framework

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

• Extract, Transform, and Load Twitter in Informatica PowerCenter

  Create a simple Workflow for Twitter in Informatica PowerCenter.

• Create Google Directory-Connected Enterprise Applications in OutSystems

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

• Connect to Dropbox in Ruby

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

• Build Azure Analysis Services-Connected Apps in Mendix

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

• Create Dynamic Avalara AvaTax Grids Using the Infragistics XamDataGrid

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

• Build Google Sheets-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Google Sheets.

• Automated Continuous Redis Replication to Amazon Redshift

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

• Connect to Salesforce Data Cloud in SpagoBI

  Create reports featuring live Salesforce Data Cloud in SpagoBI Studio. Host Salesforce Data Cloud reports on SpagoBI Server.

• Automate Azure Synapse Replication to Azure Data Lake

  Use CData Sync to customize and automate Azure Synapse replication to Azure Data Lake.

• Connect to SAP Hybris C4C in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for SAP Hybris C4C in Airbyte.

• Connect to Google Drive in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Google Drive in Google Apps Script.

• Visualize Sybase IQ in TIBCO Spotfire through OData

  Integrate Sybase IQ into dashboards in TIBCO Spotfire.

• Edit and Search Reckon Accounts Hosted External Objects

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

• How to use SQLAlchemy ORM to access Kintone in Python

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

• Create Informatica Mappings From/To an ODBC Data Source for Access

  Create an ODBC connection to Access in Informatica and browse and transfer Microsoft Access.

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

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

• Analyze Bing Search Results in Looker

  Use CData Connect Cloud to connect to Bing Search Results from Looker and build custom apps using live Bing Search.

• Automated Continuous Tableau CRM Analytics Replication to Amazon Redshift

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

• Integrate Oracle Eloqua with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Oracle Eloqua with External Services.

• Automate Google Calendar Tasks in Power Automate Using CData API Server

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

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

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

• Consume Adobe Commerce OData Feeds in PowerBuilder

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

• Automated Continuous HubSpot Replication to AlloyDB

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

• How to Seamlessly Import GitHub Data into IBM SPSS Modeler

  Integrate GitHub data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Replicate Multiple Wave Financial Accounts via the CData Sync CLI

  Replicate multiple Wave Financial accounts to one or many databases.

• How to Create Power BI Visual Reports with Real-Time Dynamics NAV

  Use CData Power BI Connectors to visualize Microsoft Dynamics NAV in Power BI.

• Publish Crystal Reports on GraphQL

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

• How to connect SharePoint with Greenplum through external lists

  Provide Pivotal GreenPlum to SharePoint users as an external list.

• How to work with QuickBooks Time in Apache Spark using SQL

  Access and process QuickBooks Time in Apache Spark using the CData Software JDBC Driver.

• Analyze Live NetSuite in SAS Viya

  Use CData Connect Cloud to connect to NetSuite CRM & ERP from SAS Viya and deploy self-service analytics using live NetSuite CRM & ERP.

• Integrating Dynamics 365 in Talend Cloud Data Management Platform

• «
• 507
• 508
• 509
• 510
• 511
• 512
• 513
• 514
• 515
• 516
• »