CData Software - Knowledge Base

Recent Articles

• «
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• »

• Automated Facebook Ads Replication to Teradata

  Use CData Sync to Customize and automate Facebook Ads replication to Teradata.

• Prepare, Blend, and Analyze Drip in Alteryx Designer (ODBC)

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

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

  Use CData Power BI Connectors to visualize Acumatica ERP in Power BI.

• Build Data Flows from Sage 300 to SQL Server using SSIS

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

• Connect to Basecamp from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Basecamp to connect to Basecamp and execute queries in PowerBuilder.

• Access Monday.com 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 Monday.com.

• How to integrate IBM Informix with Apache Airflow

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

• Build SAP Ariba Source-Connected Apps in Choreo

  Use CData Connect Cloud to connect to SAP Ariba Source from Choreo and build custom apps using live SAP Ariba Source.

• Automated Continuous Unbounce Replication to AlloyDB

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

• Analyze Jira Service Management with Power Pivot

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

• Connect to Veeva Vault from PowerBuilder via ADO.NET

  This article demonstrates how to access Veeva Vault & Vault CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Veeva Vault.

• Create Dynamic Azure DevOps Grids Using the Infragistics XamDataGrid

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

• Connect to Avro from a Connection Pool in JBoss

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

• Analyze Calendly in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Calendly and visualize Calendly in SAP Analytics Cloud.

• Integrate SAP Business One in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Business One from Informatica Cloud.

• Query Wave Financial as a MySQL Database in Node.js

  Execute MySQL queries against Wave Financial from Node.js.

• Work with Tally in FoxPro

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

• Connect to Amazon Athena 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 Amazon Athena.

• Use the CData Software ODBC Driver for Salesforce Data Cloud in MicroStrategy Desktop

  Connect to Salesforce Data Cloud in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce Data Cloud.

• Connect to PostgreSQL from AWS Glue

  Use CData Connect Cloud to gain access to live PostgreSQL from your AWS Glue jobs.

• How to update Microsoft Planner from Excel

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

• Access Live Azure Table in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Azure Table Storage from your Excel spreadsheets.

• Use the CData Software JDBC Driver for Drip in MicroStrategy Web

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

• Automated Continuous Amazon Marketplace Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to SQL Server.

• Connect to Outreach.io in SpagoBI

  Create reports featuring live Outreach.io in SpagoBI Studio. Host Outreach.io reports on SpagoBI Server.

• Marketo Cloud Connectivity

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

• LinkedIn Cloud Connectivity

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

• Query Reckon as a SQL Server Database in Node.js

  Execute SQL Server queries against Reckon from Node.js.

• Analyze Act-On in Looker

  Use CData Connect Cloud to connect to Act-On from Looker and build custom apps using live Act-On.

• Bridge SuiteCRM Connectivity with Apache NiFi

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

• DataBind Controls to Greenhouse in Delphi

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

• A PostgreSQL Interface for Couchbase using the CData ODBC Driver

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

• Visualize Live Typeform in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Typeform and create custom reports in the Power BI Service.

• How to create HCL Domino federated tables in MySQL

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

• Build Sansan-Connected Apps in Choreo

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

• How to connect to SAP Ariba Procurement from IntelliJ

  Integrate connectivity to SAP Ariba Procurement with wizards in IntelliJ.

• Publish Reports with SAP Ariba Source in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Ariba Source.

• How to create an RPA flow for Sage 200 in UiPath Studio

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

• Perform Batch Operations with Sybase IQ in Apache NiFi

  Connect to Sybase IQ and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Automated Continuous SAP ByDesign Replication to IBM DB2

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

• Automated Continuous WordPress Replication to MongoDB

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

• Build Data Flows from SQL Server to Redshift through SSIS

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

• Build Automated Workflows with Live Jira Service Management in Workato

  Use CData Connect Cloud to connect to live Atlassian Jira Service Management and build automated workflows in Workato.

• How to Query Azure Table in MySQL Workbench

  Execute MySQL queries against live Azure Table Storage from MySQL Workbench.

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

  Provide connectivity to Instagram through an SAP BusinessObjects universe.

• Model Presto Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Presto, enabling the direct import of real-time Presto.

• Analyze Excel in R via ODBC

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

• Automated Continuous MailChimp Replication to OneLake in Microsoft Fabric

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

• Automate Sage Intacct Integration Tasks from PowerShell

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

• Rapidly Develop BambooHR-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.

• Connect to Live GitHub in MicroStrategy through CData Connect Cloud

  Create a live connection to GitHub in CData Connect Cloud and connect to your GitHub from MicroStrategy.

• Create HCL Domino-Connected Enterprise Applications in OutSystems

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

• How to Access Trello Using Entity Framework

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

• Connect to Odoo from PowerBuilder via ADO.NET

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

• Connect to Azure Table in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Azure Table and connect to Azure Table Storage in Akorbi Digital RunMyProcess.

• Write a Simple Go Application to work with Redis on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Redis.

• Feed MySQL into FineReport

  How to set MySQL as a JDBC data source in FineReport.

• Build Data Flows from Airtable to SQL Server using SSIS

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

• Use Biml to Build SSIS Tasks to Replicate MongoDB to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MongoDB to SQL Server.

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

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

• DataBind Wijmo Grid to Sugar CRM

  Provide real-time Sugar CRM to interactive controls.

• Replicate Salesforce Pardot from PowerShell

  Write a quick PowerShell script to query Salesforce Pardot. Use connectivity to the live data to replicate Salesforce Pardot to SQL Server.

• Analyze Zoho CRM in Looker

  Use CData Connect Cloud to connect to Zoho CRM from Looker and build custom apps using live Zoho CRM.

• Connect to Bing Search Results from a Connection Pool in Jetty

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

• Automated Continuous SAP Concur Replication to Snowflake

  Use CData Sync for automated, continuous, customizable SAP Concur replication to Snowflake.

• Automated Continuous QuickBooks Online Replication to Amazon Redshift

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

• Viewing REST in RAD Studio Data Explorer

  How to view REST in RAD Studio Data Explorer using the CData ODBC Driver for REST.

• Access Live Bing Search Results in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Bing Search from your Excel spreadsheets.

• Access XML as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access XML Files from your Oracle system.

• Automated Oracle SCM Replication to Teradata

  Use CData Sync to Customize and automate Oracle SCM replication to Teradata.

• Use JayDeBeApi to access SAP ByDesign in Python

  Use standard Python scripting and the development environment of your choice to access live SAP Business ByDesign.

• Working with Smartsheet in LINQPad

  Execute LINQ queries to Smartsheet in LINQPad.

• A PostgreSQL Interface for Google Ads using the CData ODBC Driver

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

• Connect to LinkedIn in DBArtisan

  Use wizards in DBArtisan to configure LinkedIn as a data source.

• Replicate TaxJar from PowerShell

  Write a quick PowerShell script to query TaxJar. Use connectivity to the live data to replicate TaxJar to SQL Server.

• Using AngularJS to Build Dynamic Web Pages with REST

  Use the CData Connect Server to create REST OData feeds and build single-page applications with live REST.

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

• Integrate with Workday in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Workday in SnapLogic.

• Query Calendly as a SQL Server in Node.js

  Execute SQL Server queries against Calendly from Node.js.

• Access Live Microsoft Dataverse in Excel 365 Online (Excel for the web)

  Connect to Microsoft Dataverse (CDS) from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Use the CData Software JDBC Driver for TaxJar in MicroStrategy Web

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

• Seamlessly Bring Redis into Retool Using CData Connect Cloud

  Integrate Redis data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Work with Live AlloyDB in Power Query

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

• Automated Continuous Couchbase Replication to Google BigQuery

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

• Access Live GraphQL in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live GraphQL from your Excel spreadsheets.

• Query ShipStation through ODBC in Node.js

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

• Create Apps from Unbounce in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Unbounce and build apps from live Unbounce in Qlik Sense Cloud.

• How to Use a Microsoft Access Database to Update Sage Cloud Accounting in Real Time

  Update Sage Cloud Accounting data by creating a linked table in Microsoft Access with the CData Sage Cloud Accounting ODBC Driver.

• How to Access Live Google Cloud Storage in Power Automate Desktop via ODBC

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

• Connect to Instagram in HULFT Integrate

  Connect to Instagram as a JDBC data source in HULFT Integrate

• Access Act-On in PHP through Connect Server

  Connect to Act-On through the standard SQL Server libraries in PHP.

• Natively Connect to Jira Assets in PHP

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

• How to connect to Dynamics GP with Squirrel SQL client

  Connect to Microsoft Dynamics GP and execute queries in the Squirrel SQL Client.

• Access Raisers Edge NXT as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Raisers Edge NXT from your Oracle system.

• Replicate Kafka to Multiple Databases

  Replicate Apache Kafka to disparate databases with a point-and-click configuration.

• Build a Simple VCL Application for Zoho Books

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

• Back Up Salesforce Pardot to SQL Server through SSIS

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

• Access Bing Search Results 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 Bing Search.

• How to Visualize Parquet Data in Python with pandas

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

• Use the Connect Server to Access SAS Data Sets in Microsoft Power Pivot

  Use the Connect Server to connect to live SAS Data Sets in the Power Pivot business intelligence tool.

• «
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• »