CData Software - Knowledge Base

Recent Articles

• «
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• »

• How to publish and share Salesforce dashboards with Tableau Server

  The CData ODBC driver for Salesforce enables you integrate Salesforce & Force.com into Tableau dashboards.

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

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

• Work with AlloyDB in FoxPro

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

• Back Up Greenhouse to SQL Server through SSIS

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

• Connect to Oracle Service Cloud from a Connection Pool in Jetty

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

• Bridge BigQuery Connectivity with Apache NiFi

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

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

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

• Connect to Azure Table in RazorSQL

  Connect to Azure Table from wizards and query Azure Table Storage from the GUI in the RazorSQL database management tool.

• Automated Continuous Oracle Replication to SQL Server

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

• Visualize Epicor Kinetic in TIBCO Spotfire through OData

  Integrate Epicor Kinetic into dashboards in TIBCO Spotfire.

• PowerShell Scripting to Replicate Printful to MySQL

  Write a simple PowerShell script to replicate Printful to a MySQL database.

• How to load WordPress data into Elasticsearch via Logstash

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

• Access Salesloft from MySQL in Amazon QuickSight

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

• DataBind Charts to Smartsheet

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Smartsheet 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.

• Extend Google Sheets with Sugar CRM

  Make calls to the API Server from Google Apps Script.

• Working with Greenhouse in LINQPad

  Execute LINQ queries to Greenhouse in LINQPad.

• Build Acumatica Visualizations in Tableau Cloud

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

• Connect to Amazon S3 through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Amazon S3 using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

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

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

• How to Access Live TaxJar in Power Automate Desktop via ODBC

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

• Connect to and Query Oracle HCM Cloud in QlikView over ODBC

  Create data visualizations with Oracle HCM Cloud in QlikView.

• ETL PostgreSQL in Oracle Data Integrator

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

• Automated Continuous Jira Replication to MySQL

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

• How to load Adobe Target data into Elasticsearch via Logstash

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

• Use the CData Software JDBC Driver for Zuora in MicroStrategy

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

• A PostgreSQL Interface for QuickBooks Online (MySQL Remoting via JDBC)

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

• How to connect to Raisers Edge NXT from IntelliJ

  Integrate connectivity to Raisers Edge NXT with wizards in IntelliJ.

• Use Biml to Build SSIS Tasks to Replicate Amazon Athena to SQL Server

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

• Connect to Sugar CRM in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Sugar CRM in Google Apps Script.

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

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

• Object-Relational Mapping (ORM) with Highrise 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 Highrise CRM into a Java-based ORM framework, Hibernate.

• Access Live Sugar CRM in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Sugar CRM from your Google Sheets.

• Build Jira Assets-Connected ETL Processes in Google Data Fusion

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

• DataBind Microsoft Dataverse to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Microsoft Dataverse with the DevExpress Windows Forms and Web controls to provide Microsoft Dataverse (CDS) to a chart.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Authorize.Net

  Provide connectivity to Authorize.Net through an SAP BusinessObjects universe.

• Choosing the Best Method to Connect Azure Data Catalog to SQL Server: 5 Options Explained

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

• Build Snowflake-Connected ETL Processes in Google Data Fusion

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

• Use the CData API Server in Microsoft Power BI

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

• Connect to Splunk from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Splunk from Crystal Reports.

• How to Query Live Monday.com in Claude Desktop

  Connect to and query live Monday.com in Claude Desktop using the CData MCP Server.

• How to connect to Pinterest from Spring Boot

  Connect to Pinterest in a Spring Boot Application using CData JDBC Pinterest Driver

• Integrate Live GMO MakeShop into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to GMO MakeShop from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live GMO MakeShop.

• How to Query FTP in MySQL Workbench

  Execute MySQL queries against live FTP Servers from MySQL Workbench.

• Edit and Search Instagram External Objects in Salesforce Connect (API Server)

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

• DataBind Sybase IQ to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Sybase IQ with the DevExpress Windows Forms and Web controls to provide Sybase IQ to a chart.

• SingleStore Cloud Connectivity

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

• Object-Relational Mapping (ORM) with Epicor Kinetic 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 Epicor Kinetic into a Java-based ORM framework, Hibernate.

• Explore Geographical Relationships in Snapchat Ads with Power Map

  Create data visualizations with Snapchat Ads in Power Map.

• Build a Singer.io Tap for Salesforce Marketing With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Salesforce Marketing data using

• Viewing EventBrite in RAD Studio Data Explorer

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

• Automated Continuous Printify Replication to Databricks

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

• How to connect to NetSuite in DBVisualizer

  Integrate NetSuite CRM & ERP with visual data analysis tools and data connection wizards in DBVisualizer

• Publish Google Contacts-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Google Contacts.

• How to Design Microsoft Planner Power Apps with Database-Like Connectivity

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

• Integrate Adobe Target in Pentaho Data Integration

  Build ETL pipelines based on Adobe Target in the Pentaho Data Integration tool.

• Integrate Phoenix in the Pentaho Report Designer

  Publish reports based on Apache Phoenix in the Pentaho BI tool.

• How to Connect to & Open Cosmos DB in Microsoft Excel

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

• Automated Continuous Paylocity Replication to Amazon Redshift

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

• Automated Continuous Azure Data Lake Storage Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to SQL Server.

• Connect to Snapchat Ads from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Snapchat Ads from Crystal Reports.

• Connect and Query Live Zoho Inventory Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live Zoho Inventory into Databricks

• How to Design Act-On Power Apps with Database-Like Connectivity

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

• Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy

  Connect to eBay Analytics in MicroStrategy Developer using the CData Software ODBC Driver for eBay Analytics.

• Access SingleStore from MySQL in Amazon QuickSight

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

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

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

• Create SSAS Tabular Models from Act CRM

  How to build a SQL Server Analysis Service Tabular Model from Act CRM using CData drivers.

• DataBind Controls to Certinia in Delphi

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

• Create Datasets from Shopify in Domo Workbench and Build Visualizations of Shopify in Domo

  Use the CData Software ODBC Driver for Shopify to create datasets from Shopify in Domo Workbench and then build visualizations in the Domo service.

• Build MVC Applications with Connectivity to ADP

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

• How to work with FHIR in Apache Spark using SQL

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

• How to pipe Cvent to CSV in PowerShell

  Use standard PowerShell cmdlets to access Cvent tables.

• Create IBM Informix-Connected Business Apps in AppSheet

  Connect to IBM Informix via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to IBM Informix.

• Stream Azure Data Catalog into Apache Kafka Topics

  Access and stream Azure Data Catalog in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Query Salesloft using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Salesloft entities in PHP by modeling them as objects.

• Design BIRT Reports on Reckon

  Provide current Reckon to your embedded analytics.

• Integrate Instagram with External Services using SnapLogic

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

• How to publish and share Google Drive dashboards with Tableau Server

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

• Publish WooCommerce-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live WooCommerce.

• Using the CData Software ODBC Driver for Twitter Ads in PyCharm

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

• Create Power BI Reports on Real-Time Jira

  Use the CData ODBC Driver for Jira to visualize Atlassian Jira in Power BI Desktop.

• Connect to SendGrid from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live SendGrid from Filemaker Pro on Mac.

• Build Cloudant-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to IBM Cloudant and build web apps with connectivity to live IBM Cloudant.

• How to Connect to & Open TaxJar in Microsoft Excel

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

• Visualize Adobe Commerce in TIBCO Spotfire through ADO.NET

  Integrate Adobe Commerce into dashboards in TIBCO Spotfire.

• Replicate Multiple Excel Online Accounts

  Replicate multiple Excel Online accounts to one or many databases.

• Replicate Multiple Coinbase Accounts

  Replicate multiple Coinbase accounts to one or many databases.

• Validate Asana with QuerySurge

  Access and validate Asana in QuerySurge using the CData JDBC Driver.

• How to connect and process OData from Azure Databricks

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

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

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

• How to Use a Microsoft Access Database to Update Instagram in Real Time

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

• Build MVC Applications with Connectivity to Google Drive

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

• View Reports on Real-Time BigQuery in Power BI Report Server

  Use the CData ODBC Driver for BigQuery to visualize Google BigQuery in Power BI Desktop and then publish them to Power BI Report Server.

• Seamlessly Bring API into Retool Using CData Connect Cloud

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

• Create Dynamic Tableau CRM Analytics Grids Using the Infragistics XamDataGrid

  Learn how you can connect Tableau CRM Analytics to Infragistics XamDataGrid to build dynamic grids.

• Create BigCommerce-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to BigCommerce from Klipfolio and build custom visualizations using live BigCommerce.

• Natively Connect to Oracle Sales in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Oracle Sales. Leverage the native support for ODBC in PHP.

• Analyze Reckon Accounts Hosted in Infragistics Reveal

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

• Create SingleStore-Connected Applications in Appsmith

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

• Connect to SAP Business One from PowerBuilder via ODBC

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

• Integrate Real-Time Access to MarkLogic in SAPUI5 MVC Apps

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

• «
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• »