CData Software - Knowledge Base

Recent Articles

• «
• 300
• 301
• 302
• 303
• 304
• 305
• 306
• 307
• 308
• 309
• »

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

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

• Connect and Query Live Azure Active Directory Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live Azure Active Directory into Databricks

• Integrate Redis with External Services using SnapLogic

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

• Visualize Live Avalara AvaTax of Power BI Report Builder in Power BI Service

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

• Connect to Twitter Ads from PowerBuilder via ADO.NET

  This article demonstrates how to access Twitter Ads from Appeon PowerBuilder using the CData ADO.NET Provider for Twitter Ads.

• Visualize Live Office 365 in the Power BI Service

  Use CData Connect Cloud to connect to live Microsoft Office 365 and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Microsoft Project in ACL Analytics

  Connect to Microsoft Project via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Project.

• Use the CData Software ODBC Driver for Avalara AvaTax in MicroStrategy

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

• How to connect Amazon QuickSight to SAP ByDesign

  Create a connection to SAP Business ByDesign in CData Connect Cloud and insert SAP Business ByDesign into Amazon QuickSight SPICE to build interactive dashboards.

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

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

• How to Import Data from Snowflake into Google Sheets

  Import Snowflake into a Google spreadsheet that is automatically refreshed.

• Edit and Search External Sugar CRM Objects in Salesforce Connect

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

• Build QuickBooks Online-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live QuickBooks Online and build QuickBooks Online-connected web apps with Axios.

• Use JayDeBeApi to access BigCommerce in Python

  Use standard Python scripting and the development environment of your choice to access live BigCommerce.

• Access Live Bing Ads in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live Bing Ads from your Excel spreadsheets.

• DataBind Charts to SAP Ariba Source

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

• Replicate Google Cloud Storage from PowerShell

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

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

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

• Connect to Live Hive in MicroStrategy through CData Connect Cloud

  Create a live connection to Hive in CData Connect Cloud and connect to your Apache Hive from MicroStrategy.

• How to connect SharePoint with Asana through external lists

  Provide Asana to SharePoint users as an external list.

• Access MYOB AccountRight from MySQL in PHP

  Connect to MYOB AccountRight through the standard MySQL libraries in PHP.

• Validate JDBC-ODBC Bridge with QuerySurge

  Access and validate JDBC-ODBC Bridge in QuerySurge using the CData JDBC Driver.

• Replicate Multiple Jira Accounts via the CData Sync CLI

  Replicate multiple Jira accounts to one or many databases.

• Use the CData ODBC Driver for Avalara AvaTax from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Avalara AvaTax to connect to Avalara AvaTax from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Avalara AvaTax in Excel.

• Connect to and Query Jira Assets in QlikView over ODBC

  Create data visualizations with Jira Assets in QlikView.

• How to connect and process Salesforce & Force.com from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce & Force.com.

• Analyze WooCommerce in Infragistics Reveal

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

• Automated Continuous Oracle HCM Cloud Replication to Local Delimited Files

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

• Create Data Visualizations in Cognos BI with Facebook

  Access Facebook as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• How to Import Data from RSS into Google Sheets

  Import RSS Feeds into a Google spreadsheet that is automatically refreshed.

• Connect QuickBooks to SQL Server through SSIS

  Easily back up QuickBooks data to SQL Server using the QuickBooks Data Provider for ADO.NET. This example uses an SSIS workflow to populate a database with QuickBooks data using the QuickBooks ADO.NET Data Provider.

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

  Connect to Veeva Vault & Vault CRM 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.

• Automated Continuous Cosmos DB Replication to Vertica

  Use CData Sync for automated, continuous, customizable Cosmos DB replication to Vertica.

• Operational Reporting on Office 365 from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Office 365.

• Access Live CSV in SAS JMP via ODBC

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

• Connect to XML in Google Apps Script via SQL Gateway

  Use the ODBC Driver for XML and the SQL Gateway to access XML Files from Google Apps Script.

• Visualize Live SAP Netweaver Gateway of Power BI Report Builder in Power BI Service

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

• Build Semantic Layer Views for Odoo in APOS Live Data Gateway

  Use the CData Connector for Odoo in APOS Live Data Gateway to build Semantic Layer Views for Odoo ERP.

• Build Charts with Klipfolio in Clear Analytics

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

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

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

• Create Oracle Financials Cloud-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Oracle Financials Cloud from Nintex Workflow Cloud and build custom workflows using live Oracle Financials Cloud.

• DataBind Controls to Zoho Inventory in Delphi

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

• Integrate Live Act-On into Custom Business Apps Built in Power Apps

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

• Connect to EventBrite in DBeaver

  Use the CData ODBC Driver to connect to Eventbrite in DBeaver.

• Create Informatica Mappings From/To an ODBC Data Source for Jira Service Management

  Create an ODBC connection to Jira Service Management in Informatica and browse and transfer Atlassian Jira Service Management.

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

  Create an ODBC connection to TaxJar in Informatica and browse and transfer TaxJar.

• Automated Continuous WooCommerce Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable WooCommerce replication to Azure SQL Database.

• Build Microsoft Dataverse-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Microsoft Dataverse from Choreo and build custom apps using live Microsoft Dataverse (CDS).

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

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

• Access Live SAP Hybris C4C in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for SAP Hybris C4C to create a SAP Hybris C4C source in TIBCO Data Virtualization Studio and gain access to live SAP Hybris C4C from your TDV Server.

• Bidirectional Access to Azure Data Catalog from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Azure Data Catalog in Filemaker Pro for Mac or Windows.

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

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

• Access Live Avalara AvaTax in AWS Lambda (with IntelliJ IDEA)

  Connect to live Avalara AvaTax in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Using the CData Software ODBC Driver for Reckon in PyCharm

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

• Automate Kafka Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Apache Kafka and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Natively Connect to Email in PHP

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

• How to connect PolyBase to Azure Analysis Services

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Analysis Services.

• Build Microsoft Dataverse-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Microsoft Dataverse (CDS) and build Microsoft Dataverse-connected web apps with Axios.

• How to Work with Sybase in ETL Validator JDBC

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

• Access SAP ByDesign as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Business ByDesign from your Oracle system.

• Automated Continuous Neo4J Replication to IBM DB2

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

• Analyze Blackbaud FE NXT in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Blackbaud FE NXT in Microsoft R Open.

• Connect to Bullhorn CRM from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Bullhorn CRM using standard SQL.

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

  Use the LinkedIn ODBC Driver to create workflows that access real-time LinkedIn without any coding.

• Consume Freshdesk OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Freshdesk feeds that reflect any changes in SAP Lumira.

• Integrate Zendesk with External Services using SnapLogic

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

• Choosing the Best Method to Connect Sage Cloud Accounting to SQL Server: 5 Options Explained

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

• Enable the Google Analytics JDBC Driver in KNIME

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

• DataBind Controls to eBay in Delphi

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

• How to integrate Metabase with Oracle SCM

  Use CData Connect Cloud to connect to live Oracle SCM and create an interactive dashboard in Metabase from Oracle SCM.

• Automate Cassandra Replication to Couchbase

  Use CData Sync to Customize and automate Apache Cassandra replication to Couchbase.

• Build MVC Applications with Connectivity to SAP SuccessFactors

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

• Query SAP Business One through ODBC in Node.js

  Use node-odbc to execute SQL queries against SAP Business One from Node.js.

• A PostgreSQL Interface for YouTube Analytics (MySQL Remoting via JDBC)

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

• Integrate Live Sage Intacct into Amazon SageMaker Canvas with RDS

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

• Connect to Clio from PowerBuilder via JDBC

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

• Build MVC Applications with Connectivity to Azure DevOps

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

• A PostgreSQL Interface for SingleStore using the CData ODBC Driver

  Use the SQL Gateway and SingleStore ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Build an ETL App for Marketo in Python with CData

  Create ETL applications and real-time data pipelines for Marketo in Python with petl.

• How to create Visio diagrams from WooCommerce

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

• Analyze Hive in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Apache Hive and visualize Apache Hive in SAP Analytics Cloud.

• Connect to SAP SuccessFactors in Aqua Data Studio

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

• Connect to Reckon Accounts Hosted in Aqua Data Studio

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

• Create Paylocity-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Paylocity from Nintex Workflow Cloud and build custom workflows using live Paylocity.

• Automated Continuous Shippo Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Shippo replication to Apache Kafka.

• Create FHIR Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Process & Analyze Redis in Databricks (AWS)

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

• Analyze MYOB AccountRight in Infragistics Reveal

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

• How to Build an ETL App for Todoist in Python with CData

  Create ETL applications and real-time data pipelines for Todoist in Python with petl.

• Build Cosmos DB-Connected ETL Processes in Google Data Fusion

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

• Back Up Google Ad Manager to SQL Server through SSIS

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

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

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

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

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

• Build Automated Workflows with Live Excel Online in Workato

  Use CData Connect Cloud to connect to live Microsoft Excel Online and build automated workflows in Workato.

• Create Informatica Mappings From/To an ODBC Data Source for Adobe Commerce

  Create an ODBC connection to Adobe Commerce in Informatica and browse and transfer Adobe Commerce.

• Integrate with OneNote using Apache Camel2

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

• Building Dynamic Web Pages with Oracle Financials Cloud Using AngularJS

  Create single-page applications with live connectivity to Oracle Financials Cloud using the CData API Server.

• Connect to ServiceNow in Aqua Data Studio

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

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

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

• Import ShipStation into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to ShipStation and provide access to live ShipStation for custom reports in the Power BI Service.

• «
• 300
• 301
• 302
• 303
• 304
• 305
• 306
• 307
• 308
• 309
• »