CData Software - Knowledge Base

Recent Articles

• «
• 336
• 337
• 338
• 339
• 340
• 341
• 342
• 343
• 344
• 345
• »

• Migrating data from Sage 300 to Google BigQuery using CData SSIS Components.

  Easily push Sage 300 to Google BigQuery using the CData SSIS Tasks for Sage 300 and Google BigQuery.

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

  Connect to Marketo from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• How to create an RPA flow for NetSuite in UiPath Studio

  Use the NetSuite ODBC Driver to create workflows that access real-time NetSuite CRM & ERP without any coding.

• Replicate Jira Service Management to Multiple Databases

  Replicate Atlassian Jira Service Management to disparate databases with a point-and-click configuration.

• Access Bullhorn CRM 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 Bullhorn CRM.

• Integrate with live DocuSign in Jitterbit

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

• Create a Data Access Object for LinkedIn Ads using JDBI

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

• Connect to Avalara AvaTax as an External Source in Dremio

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

• Connect to YouTube Analytics from Asprova with CData Software ODBC Driver for YouTube Analytics

  This article shows how to connect faster to YouTube Analytics data from Asprova.

• Model, Search, and Visualize Live Salesforce in ThoughtSpot

  Use CData Connect Cloud to connect to live Salesforce & Force.com for modeling, searching, and visualizing.

• Choosing the Best Method to Connect Act-On to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Act-On from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Access Live Stripe in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Stripe into the statistical analysis tools available in SAS JMP. This article shows how to use Stripe in the Graph Builder and Query Builder.

• Provide OData Services of Highrise from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Highrise CRM by developing a WCF Service Application.

• Viewing CSV in RAD Studio Data Explorer

  How to view CSV/TSV Files in RAD Studio Data Explorer using the CData ODBC Driver for CSV.

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

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

• DataBind Charts to Zoom

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoom from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

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

  Use CData Power BI Connectors to visualize Salesforce Pardot in Power BI.

• How to Access Live SFTP in Visual Studio Code via Cline

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

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

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

• Automate Reckon Replication to Azure Synapse

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

• Bind Live Oracle Financials Cloud Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Oracle Financials Cloud data

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

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

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

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

• Build Sansan-Connected Dashboards Using Zoho Analytics

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

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

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

• Extract, Transform, and Load Zoho Inventory in Informatica PowerCenter

  Create a simple Workflow for Zoho Inventory in Informatica PowerCenter.

• Analyze SAP Netweaver Gateway in R via ODBC

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

• Automated Continuous Reckon Replication to AlloyDB

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

• YouTube Analytics Reporting in OBIEE with the YouTube Analytics JDBC Driver

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

• LINQ to QuickBooks

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

• Choosing the Best Method to Connect MYOB AccountRight to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use MYOB AccountRight from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Automated Continuous Microsoft Dataverse Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Amazon S3.

• Automated Continuous Aha Replication to Apache Cassandra

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

• Connect to Google Spanner 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 Google Spanner.

• Access Live Kintone Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Kintone data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Integrate with NetSuite using Apache Camel2

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

• Integrate API into Power Automate Desktop using CData Connect

  CData Connect for API enables you to integrate API into workflows built using Microsoft Power Automate Desktop.

• Analyze Active Directory in R via ODBC

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

• Replicate Multiple AlloyDB Accounts via the CData Sync CLI

  Replicate multiple AlloyDB accounts to one or many databases.

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

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

• How to Visualize Salesforce Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Salesforce & Force.com in Python.

• Analyze Presto in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Presto and visualize live Presto in Ingragistics Reveal.

• Connect to Sybase IQ in RapidMiner

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

• Create FTP 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 work with MongoDB in Apache Spark using SQL

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

• Build Databricks Visualizations in Tableau Cloud

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

• How to Design SAP SuccessFactors Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• Replicate ADP from PowerShell

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

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

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

• Build SAP BusinessObjects BI-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP BusinessObjects BI.

• How to Access Live Monday.com in Visual Studio Code via Cline

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

• Create SSAS Tabular Models from Google Search Results

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

• Extract, Transform, and Load Jira Assets in Informatica PowerCenter

  Create a simple Workflow for Jira Assets in Informatica PowerCenter.

• Establish a Live Connection with Spark using Tableau Bridge

  The CData ODBC Driver for Spark enables you to integrate live Apache Spark SQL into Tableau Cloud dashboards using the Tableau Bridge.

• How to Easily Query Excel Online in OpenOffice Base

• «
• 336
• 337
• 338
• 339
• 340
• 341
• 342
• 343
• 344
• 345
• »