CData Software - Knowledge Base

Recent Articles

• «
• 145
• 146
• 147
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• »

• SSIS Components: Source Output ColumnName Does Not Match the Data Type "System.String" of the Source Column

  In this entry, you will find the steps to resolve the SSIS Source output data type mismatch error.

• Replicate Multiple Snowflake Accounts

  Replicate multiple Snowflake accounts to one or many databases.

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

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

• Visualize Google Directory from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google Directory.

• Natively Connect to MYOB AccountRight in PHP

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

• Edit and Search External Amazon Athena Objects in Salesforce Connect

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

• Connect to Salesforce Pardot in Google Apps Script

  Use CData Connect Cloud to access Salesforce Pardot in Google Apps Script.

• How to Connect DBeaver to SharePoint Excel Services via a JDBC Driver

  Manage SharePoint Excel Services with visual tools in DBeaver like the query browser.

• Visualize IBM Informix in TIBCO Spotfire through ADO.NET

  Integrate IBM Informix into dashboards in TIBCO Spotfire.

• Natively Connect to Google Ads in PHP

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

• Automated LinkedIn Replication to Teradata

  Use CData Sync to Customize and automate LinkedIn replication to Teradata.

• Connect to OData Services in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automate MYOB AccountRight Replication to SAP HANA

  Use CData Sync to customize and automate MYOB AccountRight replication to SAP HANA.

• Query SAP SuccessFactors as a MySQL Database in Node.js

  Execute MySQL queries against SAP SuccessFactors from Node.js.

• How to Work with SAP Netweaver Gateway in AWS Glue Jobs Using JDBC

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

• Load HCL Domino to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HCL Domino to a database.

• Connect to ServiceNow in DBArtisan

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

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

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Odoo

  Provide connectivity to Odoo ERP through an SAP BusinessObjects universe.

• Analyze eBay in R

  Use standard R functions and the development environment of your choice to analyze eBay with the CData JDBC Driver for eBay.

• Query Microsoft Project in DataGrip

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

• Load Azure Active Directory to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Active Directory to a database.

• Use the CData ODBC Driver for Workday in Microsoft Power Query

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

• How to Import Google Search Results into SQL Server using SSIS

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

• Automate Shippo Replication to SAP HANA

  Use CData Sync to customize and automate Shippo replication to SAP HANA.

• Connect to BambooHR as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for BambooHR.

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

• Automated Continuous NetSuite Replication to Google Cloud SQL

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

• Model Azure Data Lake Storage Using Azure Analysis Services

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

• Create Act-On Dashboards in Bold BI

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

• Visualize Sybase IQ in TIBCO Spotfire through OData

  Integrate Sybase IQ into dashboards in TIBCO Spotfire.

• Connect to MongoDB from a Connection Pool in WebLogic

  Use the CData JDBC Driver for MongoDB to connect to MongoDB from Web applications running on WebLogic.

• Build Semantic Layer Views for Microsoft Planner in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Planner.

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

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

• Analyze Live Trello in SAS Viya

  Use CData Connect Cloud to connect to Trello from SAS Viya and deploy self-service analytics using live Trello.

• Access HubSpot as a Remote Oracle Database

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

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

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

• Import GraphQL Using Azure Data Factory

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

• Publish Reports with Google Sheets in SAP Crystal Reports

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

• Integrate QuickBooks Online in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks Online from Informatica Cloud.

• Analyze Dropbox with Power Pivot

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

• Build SAP Netweaver Gateway Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for SAP Netweaver Gateway and build visualizations in Tableau Cloud.

• Integrate Real-Time Access to Power BI XMLA in SAPUI5 MVC Apps

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

• Access Live Pinterest in Coginiti Pro

  Connect to and query live Pinterest from the GUI in the Coginiti Pro: SQL Analytics Tool.

• How to connect to Zuora with Squirrel SQL client

  Connect to Zuora and execute queries in the Squirrel SQL Client.

• Access Live Facebook in Excel (Desktop)

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

• DataBind Charts to Unbounce

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

• Build an OLAP Cube in SSAS from Access

  Establish a connection to Microsoft Access data from SQL Server Analysis Services, and use the Access Data Provider to build OLAP cubes for use in analytics and reporting.

• How to integrate Smartsheet with Apache Airflow

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

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

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

• Write a Simple Go Application to work with Authorize.Net on Linux

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

• DataBind Controls to Reckon in Delphi

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

• Automated Continuous Blackbaud FE NXT Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Apache Kafka.

• Design BIRT Reports on Amazon Athena

  Provide current Amazon Athena to your embedded analytics.

• Connect to Redshift in Aqua Data Studio

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

• How to connect and process Certinia from Azure Databricks

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

• Design BIRT Reports on Azure Table

  Provide current Azure Table Storage to your embedded analytics.

• Automated Continuous Parquet Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Parquet replication to delimited files (CSV/TSV).

• How to update Google Sheets from Excel

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

• Build Oracle-Connected Dashboards Using Zoho Analytics

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

• Visualize Microsoft Exchange in TIBCO Spotfire through ADO.NET

  Integrate Microsoft Exchange into dashboards in TIBCO Spotfire.

• Natively Connect to Zoom in PHP

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

• Connect to Sage 300 in CloverDX (formerly CloverETL)

  Transfer Sage 300 using the visual workflow in the CloverDX data integration tool.

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

• Automated Continuous Klaviyo Replication to Google Cloud SQL

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

• How to Connect the Power BI Service to SAP ByDesign: Complete Guide

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

• Access Live Smartsheet in Excel for the Web (Excel 365/Online)

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

• Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy Desktop

  Connect to Sage Business Cloud Accounting in MicroStrategy Desktop using the CData Software ODBC Driver for Sage Cloud Accounting.

• Visualize Live Sage 50 UK in the Power BI Service

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

• Viewing SharePoint Excel Services in RAD Studio Data Explorer

  How to view SharePoint Excel Services in RAD Studio Data Explorer using the CData ODBC Driver for SharePoint Excel Services.

• How to Build Dynamic React Apps with Basecamp

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

• Automated Continuous SharePoint Excel Services Replication to SQLite

  Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to SQLite.

• LINQ to Dynamics CRM

  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 Dynamics CRM Data Provider.

• Connect to Amazon DynamoDB through External Services in Salesforce

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

• Integrate with live Microsoft Planner in Jitterbit

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

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

• Process & Analyze Azure Data Catalog in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Data Catalog .

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

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

• ETL PayPal in Oracle Data Integrator

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

• Use the CData Software JDBC Driver for Veeva in MicroStrategy

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

• Access Live Splunk in Google Sheets

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

• Connect to Reckon Accounts Hosted in Google Apps Script

  Use the ODBC Driver for Reckon Accounts Hosted and the SQL Gateway to access Reckon Accounts Hosted from Google Apps Script.

• Process & Analyze Google Cloud Storage in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Google Cloud Storage .

• Connect to Excel from PowerBuilder

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

• DataBind Wijmo Grid to Microsoft Exchange

  Provide real-time Microsoft Exchange to interactive controls.

• Automate LinkedIn Replication to Azure Synapse

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Xero

  Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.

• Query, Visualize, and Share live Amazon Marketplace in Redash

  Use CData Connect Cloud to connect to live Amazon Marketplace in Redash for querying, visualizing, and sharing.

• How to Work with Oracle in ETL Validator JDBC

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

• Create Informatica Mappings From/To a JDBC Data Source for MarkLogic

  Create MarkLogic data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Import Splunk Using Azure Data Factory

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

• Connect to WordPress from AWS Glue

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

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

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

• A PostgreSQL Interface for GraphQL

  Use the Remoting features of the GraphQL ODBC Driver to create a PostgreSQL entry-point for data access.

• Create Informatica Mappings From/To a JDBC Data Source for Microsoft Dataverse

  Create Microsoft Dataverse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Use the CData Software ODBC Driver for MYOB AccountRight in MicroStrategy Desktop

  Connect to MYOB AccountRight in MicroStrategy Desktop using the CData Software ODBC Driver for MYOB AccountRight.

• Process & Analyze Highrise in Databricks (AWS)

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

• Automate Act-On Replication to Azure Synapse

  Use CData Sync to customize and automate Act-On replication to Azure Synapse.

• How to Query Facebook in MySQL Workbench

  Execute MySQL queries against live Facebook from MySQL Workbench.

• Visualize MariaDB in TIBCO Spotfire through ODBC

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

• «
• 145
• 146
• 147
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• »