CData Software - Knowledge Base

Recent Articles

• «
• 230
• 231
• 232
• 233
• 234
• 235
• 236
• 237
• 238
• 239
• »

• Automated Continuous Raisers Edge NXT Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Amazon S3.

• Build Dashboards with Redis in Dundas BI

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

• How to Connect to Unbounce in Using Python: 6 Steps

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

• Connect to MYOB AccountRight in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Author and Share Power BI Reports on Real-Time Amazon Marketplace

  Use the CData ODBC Driver for Amazon Marketplace to visualize Amazon Marketplace in Power BI Desktop and then upload to the Power BI service.

• Visualize Dropbox in Tableau

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

• Connect to and Visualize Live Adobe Commerce in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Adobe Commerce.

• Validate Phoenix with QuerySurge

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

• Automated Continuous GraphQL Replication to SingleStore

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

• Access Power BI XMLA from MySQL in PHP

  Connect to Power BI XMLA through the standard MySQL libraries in PHP.

• Working with Google Cloud Storage in LINQPad

  Execute LINQ queries to Google Cloud Storage in LINQPad.

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

  Use CData Power BI Connectors to visualize Act CRM in Power BI.

• Import Microsoft Teams into FileMaker Pro

  Create reports that integrate Microsoft Teams in Filemaker Pro.

• Visualize Amazon Athena in TIBCO Spotfire through ODBC

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

• Automated Continuous Google Search Replication to SingleStore

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

• Integrate with LinkedIn using Apache Camel2

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

• Replicate SAP Fieldglass from PowerShell

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

• Publish Crystal Reports on Azure Active Directory

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

• DataBind Controls to Quickbase in C++Builder

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

• How to update CockroachDB from Excel

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

• Connect to Salesforce Pardot in RapidMiner

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

• Integrate Live Xero into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Xero Accounting and integrate live Xero Accounting into apps built in Microsoft Power Apps.

• Build Acumatica-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Acumatica ERP.

• Build Spark Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Apache Spark SQL and build visualizations in Tableau.

• Integrate Live OneNote into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Microsoft OneNote and integrate live Microsoft OneNote into apps built in Microsoft Power Apps.

• Integrate Real-Time Access to Google Sheets in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Sheets in real time.

• Excel Spreadsheet Automation with the QUERY Formula

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

• How to connect to BigQuery from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for BigQuery and work with Google BigQuery in Microsoft Excel on Mac OS X.

• How to load Kafka data into Elasticsearch via Logstash

  Introducing a simple method to load Kafka data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Automated Continuous Reckon Accounts Hosted Replication to SQLite

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SQLite.

• How to Build Dynamic React Apps with Greenplum

  Use the CData Connect and React to Build Dynamic Web Apps with Live Greenplum .

• Stream JSON Services into Apache Kafka Topics

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

• Build MVC Applications with Connectivity to Facebook Ads

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

• How to update Sage Intacct from Excel

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

• Connect to Reckon Accounts Hosted from PowerBuilder

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

• How to connect and process SAP Business One from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Business One

• Connect to and Query Jira in QlikView over ODBC

  Create data visualizations with Atlassian Jira in QlikView.

• Creating Greenplum-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Pivotal GreenPlum to Unqork and build custom business apps.

• Enable the Smartsheet JDBC Driver in KNIME

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

• Automate SAP Business One Replication to SAP HANA

  Use CData Sync to customize and automate SAP Business One replication to SAP HANA.

• Automated Continuous Zoom Replication to AlloyDB

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

• Automated Continuous Avalara AvaTax Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to IBM DB2.

• Query IBM Informix as a SQL Server Database in Node.js

  Execute SQL Server queries against IBM Informix from Node.js.

• How to import SAP ByDesign into Apache Solr

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to SAP Ariba Procurement in RazorSQL

  Connect to SAP Ariba Procurement from wizards and query SAP Ariba Procurement from the GUI in the RazorSQL database management tool.

• Automated Continuous HCL Domino Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable HCL Domino replication to Microsoft Access.

• Build Dashboards with SQL Server in Dundas BI

  Create dynamic dashboards and perform analytics based on Microsoft SQL Server in Dundas BI.

• Import MYOB AccountRight Using Azure Data Factory

  Use CData Connect Cloud to connect to MYOB AccountRight from Azure Data Factory and import live MYOB AccountRight.

• Access Act CRM from MySQL in PHP

  Connect to Act CRM through the standard MySQL libraries in PHP.

• Automate Confluence Replication to Azure Data Lake

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

• DataBind Controls to Google Data Catalog in C++Builder

  DataBind to Google Data Catalog in C++Builder with standard components and controls.

• Integrate with live Epicor Kinetic in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Epicor Kinetic in Jitterbit.

• Connect to Workday in Aqua Data Studio

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

• Build Pipelines with Live Twitter Ads in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Twitter Ads from Google Cloud Data Fusion, enabling the integration of live Twitter Ads into the building and management of effective data pipelines.

• Working with Microsoft Planner in LINQPad

  Execute LINQ queries to Microsoft Planner in LINQPad.

• Import Real-Time Salesforce Pardot in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Salesforce Pardot in ColdFusion.

• Use the CData ODBC Driver for SAP SuccessFactors in Microsoft Power Query

  You can use the CData SAP SuccessFactors ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP SuccessFactors into Microsoft Power Query.

• Connect to SAS Data Sets in RapidMiner

  Integrate SAS Data Sets with standard components and data source configuration wizards in RapidMiner Studio.

• Analyze MySQL in Infragistics Reveal

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

• How to update BigCommerce from Excel

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

• How to Connect to Shippo in Using Python: 6 Steps

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

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

• How to connect and process xBase from Azure Databricks

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

• Prepare, Blend, and Analyze Tableau CRM Analytics in Alteryx Designer

  Build workflows to access live Tableau CRM Analytics for self-service data analytics.

• Connect to Live JotForm in MicroStrategy through CData Software Connect Server

  Create a virtual database for JotForm in CData Software Connect Server and connect to it from MicroStrategy.

• Connect to Twilio from AWS Glue

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

• Operational Reporting on Twilio from Spotfire Server

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

• How to Import Authorize.Net into SQL Server using SSIS

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

• Bridge Twilio Connectivity with Apache NiFi

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

• Visualize REST in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for REST in CData Software Connect (or Connect Server) and build visualizations from live REST in Tableau Desktop.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Data Catalog

  Provide connectivity to Google Data Catalog through an SAP BusinessObjects universe.

• Automated Continuous Active Directory Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Active Directory replication to SQL Server.

• Publish Reports with Odoo in SAP Crystal Reports

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

• Stream Todoist into Apache Kafka Topics

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

• Connect to Microsoft Exchange in as an External Source in Dremio

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

• Use the CData ODBC Driver for Blackbaud FE NXT in Microsoft Power Query

  You can use the CData Blackbaud FE NXT ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Blackbaud FE NXT into Microsoft Power Query.

• Connect to Harvest in JRuby

  Create a simple JRuby app with access to live Harvest.

• Use the CData Software ODBC Driver for LinkedIn Ads in MicroStrategy

  Connect to LinkedIn Ads in MicroStrategy Developer using the CData Software ODBC Driver for LinkedIn Ads.

• Use the CData Software ODBC Driver for Zoho Books in MicroStrategy Web

  Connect to Zoho Books in MicroStrategy Web using the CData Software ODBC Driver for Zoho Books.

• Connect to Cvent from PowerBuilder

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

• Access Google Directory in PHP through Connect Server

  Connect to Google Directory through the standard SQL Server libraries in PHP.

• How to Connect the Power BI Service to Klaviyo: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Connect to and Visualize Live xBase in Tableau Prep

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

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

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

• How to Import Sybase into SQL Server using SSIS

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

• Use the CData Software JDBC Driver for Sage 300 in MicroStrategy

  Connect to Sage 300 in MicroStrategy Developer using the CData Software JDBC Driver for Sage 300.

• Integrate Live CockroachDB into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to CockroachDB and integrate live CockroachDB into apps built in Microsoft Power Apps.

• Build Visualizations of Live JotForm in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for JotForm and build custom reports in Power BI.

• How to Work with EventBrite in ETL Validator JDBC

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

• Process & Analyze SAP BusinessObjects BI in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAP BusinessObjects BI .

• How to Connect to & Open Sugar CRM in Microsoft Excel

  This article uses the CData ODBC driver for Sugar CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Model Oracle Using Azure Analysis Services

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

• Connect to Email in CloverDX (formerly CloverETL)

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

• Connect to Twitter in Ruby

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

• Build Dashboards with LDAP Objects in Dundas BI

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

• Connect to Odoo in Aqua Data Studio

  Access Odoo ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Connect to Klipfolio in CloverDX (formerly CloverETL)

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

• Visualize Todoist in Tableau

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

• Configure the CData JDBC Driver for Sage Cloud Accounting in a Connection Pool in Tomcat

  Connect to Sage Business Cloud Accounting from a connection pool in Tomcat.

• «
• 230
• 231
• 232
• 233
• 234
• 235
• 236
• 237
• 238
• 239
• »