CData Software - Knowledge Base

Recent Articles

• «
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• »

• Use the Connect Server to Access Zoom in Microsoft Power Pivot

  Use the Connect Server to connect to live Zoom in the Power Pivot business intelligence tool.

• Automated Continuous SuiteCRM Replication to SQLite

  Use CData Sync for automated, continuous, customizable SuiteCRM replication to SQLite.

• Connect to Google Campaign Manager 360 as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Google Campaign Manager 360.

• How to connect to eBay Analytics with Squirrel SQL client

  Connect to eBay Analytics and execute queries in the Squirrel SQL Client.

• How to load BigQuery data into Elasticsearch via Logstash

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

• Access Live SingleStore in AWS Lambda

  Connect to live SingleStore in AWS Lambda using the CData JDBC Driver.

• Create Apps from Basecamp in Qlik Sense Cloud

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

• LINQ to Facebook Ads

  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 Facebook Ads Data Provider.

• Build Interactive Dashboards from Drift in Amazon QuickSight

  Create a virtual SQL Server database for Drift in CData Software Connect Server and import Drift into Amazon QuickSight SPICE to build interactive dashboards.

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

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

• Back Up Odoo ERP to SQL Server through SSIS

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

• Access Live Amazon S3 in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Amazon S3 from your Google Sheets.

• Access Cosmos DB from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Azure Cosmos DB from HeidiSQL.

• Automated Continuous Zoho Books Replication to Vertica

  Use CData Sync for automated, continuous, customizable Zoho Books replication to Vertica.

• Import and Visualize BigQuery in Power View

  Create data visualizations based on Google BigQuery in Excel.

• Create Clio Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Clio to build custom dashboards in Bold BI.

• Use the CData Software ODBC Driver for OData in MicroStrategy

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

• Visualize Live BigCommerce in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live BigCommerce into custom reports in Power BI.

• Validate Outreach.io with QuerySurge

  Access and validate Outreach.io in QuerySurge using the CData JDBC Driver.

• Build Dashboards with Invoiced in Dundas BI

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

• Access Bitbucket from MySQL in Amazon QuickSight

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

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

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

• Integrate Amazon DynamoDB into Power Automate Desktop using CData Connect

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

• How to Query eBay Analytics in MySQL Workbench

  Execute MySQL queries against live eBay Analytics from MySQL Workbench.

• Use the CData Software ODBC Driver for Azure Table in MicroStrategy Desktop

  Connect to Azure Table Storage in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Table.

• Connect to WordPress as an External Source in Dremio

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

• Importing Referenced Files in AWS Glue with Boto3

  In this entry, you will learn how to use boto3 to download referenced files, such as RSD files, from S3 to the AWS Glue executor. Doing so will allow the JDBC driver to reference and use the necessary files.

• Import and Visualize Workday in Power View

  Create data visualizations based on Workday in Excel.

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

  Provide connectivity to Microsoft Office 365 through an SAP BusinessObjects universe.

• Build Oracle Eloqua-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Oracle Eloqua and create custom apps in Mendix.

• Use the CData Software ODBC Driver for SAP SuccessFactors in MicroStrategy

  Connect to SAP SuccessFactors in MicroStrategy Developer using the CData Software ODBC Driver for SAP SuccessFactors.

• Access Azure Data Catalog from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Azure Data Catalog from HeidiSQL.

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

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

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

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

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

• Automated Continuous QuickBooks Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable QuickBooks replication to Google Cloud SQL.

• Build Oracle Eloqua-Connected ETL Processes in Google Data Fusion

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

• Access Live Tableau CRM Analytics in Google Sheets through Connect Spreadsheets

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

• Build OneNote-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for OneNote and create custom apps in Bubble.

• Connect to Excel in Aqua Data Studio

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

• Build MYOB AccountRight-Connected Dashboards Using Zoho Analytics

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

• Automated Continuous ShipStation Replication to Amazon Redshift

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

• Create Data Visualizations Based On Cassandra in Mode

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

• Use the CData Software JDBC Driver for ServiceNow in MicroStrategy Desktop

  Connect to ServiceNow in MicroStrategy Desktop using the CData Software JDBC Driver for ServiceNow.

• Publish Reports with Sybase in SAP Crystal Reports

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

• Automated Continuous ClickUp Replication to SingleStore

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

• How to Connect to Salesforce Marketing in Using Python: 6 Steps

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

• Access Live Microsoft Teams in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Microsoft Teams from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Edit and Search External ServiceNow Objects in Salesforce Connect

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

• Build JotForm-Connected Web Apps in Servoy

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

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

  Use CData Software Connect Server to create a virtual SQL Server Database for Procore and integrate live Procore into apps built in Microsoft Power Apps.

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

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

• How to create Visio diagrams from Exact Online

  Automatically update Exact Online with the changes you make to Visio master shapes.

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

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

• Author and Share Power BI Reports on Real-Time BambooHR

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

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

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

• Visualize Live Typeform in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Typeform.

• Establish a Live Connection with Epicor Kinetic using Tableau Bridge

  The CData ODBC Driver for Epicor Kinetic enables you to integrate live Epicor Kinetic into Tableau Cloud dashboards using the Tableau Bridge.

• Use the CData Software ODBC Driver for Tableau CRM Analytics in MicroStrategy Desktop

  Connect to Tableau CRM Analytics in MicroStrategy Desktop using the CData Software ODBC Driver for Tableau CRM Analytics.

• How to connect Amazon QuickSight to Zoho Inventory

  Create a connection to Zoho Inventory in CData Connect Cloud and insert Zoho Inventory into Amazon QuickSight SPICE to build interactive dashboards.

• Use Biml to Build SSIS Tasks to Replicate Dynamics GP to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Dynamics GP to SQL Server.

• Feed Dynamics 365 Business Central into FineReport

  How to set Dynamics 365 Business Central as a JDBC data source in FineReport.

• Use Biml to Build SSIS Tasks to Replicate Sage Cloud Accounting to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage Business Cloud Accounting to SQL Server.

• How to connect to Bing Search Results from IntelliJ

  Integrate connectivity to Bing Search with wizards in IntelliJ.

• Visualize Live SAS xpt in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live SAS XPORT.

• Build Automated Oracle Sales-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Oracle Sales and build automated workflows in Zapier.

• Access XML 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 XML Files.

• Access Live Oracle SCM in Excel (Desktop) via Connect Cloud

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

• Automate CSV Integration Tasks from PowerShell

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

• Automated Continuous Zuora Replication to IBM DB2

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

• DataBind Controls to Sybase IQ in Delphi

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

• How to Build Dynamic React Apps with Azure Table

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

• Connect to Bing Ads in Ruby

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

• Visualize CouchDB in Tableau Desktop (through CData Connect)

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

• How to import Raisers Edge NXT into Apache Solr

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

• Import Teradata into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Teradata and create custom reports in the Power BI Service.

• How to create Microsoft Teams federated tables in MySQL

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

• Integrate Klipfolio with External Services using SnapLogic

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

• Build Charts with Basecamp in Clear Analytics

  Create dynamic charts and perform analytics based on Basecamp in Clear Analytics.

• Query GitHub in DataGrip

  Create a Data Source for GitHub in DataGrip and use SQL to query live GitHub.

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

  Create an ODBC connection to Sage Intacct in Informatica and browse and transfer Sage Intacct.

• Back Up Amazon S3 to SQL Server through SSIS

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

• Integrate Google Data Catalog with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Google Data Catalog with External Services.

• How to Work with Zoho CRM in ETL Validator JDBC

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

• Create Google Data Catalog-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Google Data Catalog from AppSheet and build custom business apps using live Google Data Catalog.

• Automate Exact Online Replication to Azure Data Lake

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

• Automated Continuous RSS Replication to Apache Cassandra

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

• Visualize Live Microsoft Teams of Power BI Report Builder in Power BI Service

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

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

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

• Connect to SharePoint as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Microsoft SharePoint.

• Query BigCommerce in ColdFusion

  Write standard ColdFusion data access code to connect to BigCommerce.

• Query Microsoft Exchange in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft Exchange.

• Automated Continuous Microsoft Teams Replication to Databricks

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

• How to import Drip into Apache Solr

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

• Viewing DocuSign in RAD Studio Data Explorer

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

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

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

• Connect to Greenplum in HULFT Integrate

  Connect to Greenplum as a JDBC data source in HULFT Integrate

• Build Data Flows from Invoiced to SQL Server using SSIS

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

• Access Live Zoho Projects in Google Sheets via Connect Cloud

  Use CData Connect Cloud to gain access to live Zoho Projects from your Google Sheets.

• Process & Analyze SQL Server in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SQL Server .

• «
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• »