CData Software - Knowledge Base

Recent Articles

• «
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• »

• Create OneNote-Connected Dashboards in Grafana

  Connect to OneNote via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Microsoft OneNote.

• Automated Continuous TaxJar Replication to MySQL

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

• How to Connect the Power BI Service to Avalara AvaTax: Complete Guide

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

• Automated Continuous Sage Intacct Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Sage Intacct replication to Google BigQuery.

• Access Live WordPress in Excel (Desktop) via Connect Cloud

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

• Connect to Salesforce Marketing from a Connection Pool in JBoss

  Integrate Salesforce Marketing Cloud into Java servlets: Use the Management Console in JBoss to install the Salesforce Marketing JDBC Driver.

• Connect to Salesforce Data Cloud from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Salesforce Data Cloud to connect to Salesforce Data Cloud from Web applications running on WebLogic.

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

• Create Salesforce Pardot-Connected Applications in Appsmith

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

• Automated Continuous Zoho Inventory Replication to Oracle

  Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Oracle.

• Replicate IBM Cloud Object Storage for Use in Salesforce Connect

  Replicate IBM Cloud Object Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Back Up OData to SQL Server through SSIS

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

• Build MVC Applications with Connectivity to Aha

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

• How to connect to Clio from Spring Boot

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

• Create Reports with Google Cloud Storage in SAP Crystal Reports

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

• Query Clio as a SQL Server in Node.js

  Execute SQL Server queries against Clio from Node.js.

• A PostgreSQL Interface for Tableau CRM Analytics using the CData ODBC Driver

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

• Configure the CData JDBC Driver for Epicor Kinetic in a Connection Pool in Tomcat

  Connect to Epicor Kinetic from a connection pool in Tomcat.

• Import Act CRM Using Azure Data Factory

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

• How to Query Klipfolio in MySQL Workbench

  Execute MySQL queries against live Klipfolio from MySQL Workbench.

• How to Build Dynamic React Apps with Access

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

• Automated Continuous Marketo Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Marketo replication to Google BigQuery.

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

• Connect to Adobe Analytics 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 Adobe Analytics.

• Integrate GraphQL in the Pentaho Report Designer

  Publish reports based on GraphQL in the Pentaho BI tool.

• Query Smaregi as a SQL Server Database in Node.js

  Execute SQL Server queries against Smaregi from Node.js.

• Create Dashboards and Visualize Live Slack in Geckoboard

  Use CData Connect Cloud to connect to live Slack and create dashboards for real-time monitoring and visualization in Geckoboard.

• Access Live Instagram in Coginiti Pro

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

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

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

• Publish Reports with FTP in SAP Crystal Reports

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

• Connect to eBay Analytics as an External Source in Dremio

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

• Analyze Cloudant with Power Pivot

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

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

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

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

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

• How to integrate Jira Service Management with Apache Airflow

  Access and process Atlassian Jira Service Management in Apache Airflow using the CData JDBC Driver.

• MarkLogic: SQL-NOCOLUMN: Column Not Found Error

  In this entry you will find information relating to MarkLogic's "SQL-NOCOLUMN" error.

• Integrate Azure Synapse into Power Automate Desktop using CData Connect

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

• Use Biml to Build SSIS Tasks to Replicate Monday.com to SQL Server

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

• Back Up Veeva Vault & Vault CRM to SQL Server through SSIS

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

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

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

• Analyze Jira Service Management in Cognos Analytics

  Use CData Connect Cloud to connect to Jira Service Management from Cognos Analytics and analyze live Atlassian Jira Service Management.

• Create Bing Ads Dashboards in Bold BI

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

• Build Automated Workflows with Live Stripe in Workato

  Use CData Connect Cloud to connect to live Stripe and build automated workflows in Workato.

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

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

• How to connect to SendGrid from Spring Boot

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

• Use the CData ODBC Driver for HDFS from SharePoint Excel Services

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

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

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

• Automated Continuous Sage 200 Replication to MySQL

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

• Access Live Confluence in SAS JMP via ODBC

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

• Integrate Real-Time Access to Authorize.Net in SAPUI5 MVC Apps

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

• How to import Airtable into Apache Solr

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

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

• Integrate SAS Data Sets with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate SAS Data Sets with External Services.

• Prepare, Blend, and Analyze Snapchat Ads in Alteryx Designer (Connect Cloud)

  Build workflows to access live Snapchat Ads for self-service data analytics.

• How to import MYOB AccountRight into Apache Solr

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

• Automated Continuous Aha Replication to SingleStore

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

• Connect to SAP as an External Source in Dremio

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

• Integrate Wave Financial with External Services using SnapLogic

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

• Connect and Visualize Live SAP Business One Data in Databricks Lakehouse Federation with CData Connect Cloud

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

• Using the CData Software ODBC Driver for Unbounce in PyCharm

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

• Create Data Visualizations in Cognos BI with Snapchat Ads

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

• Automated Continuous Slack Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Slack replication to MongoDB.

• Automated Continuous Elasticsearch Replication to Amazon S3

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

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

• Connect to Zoho CRM 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 Zoho CRM.

• Integrate Square in the Pentaho Report Designer

  Publish reports based on Square in the Pentaho BI tool.

• Connect to Typeform in NetBeans

  Connect to Typeform in NetBeans with the data source configuration wizard.

• Automate Google Campaign Manager 360 Replication to Azure Synapse

  Use CData Sync to customize and automate Google Campaign Manager 360 replication to Azure Synapse.

• Work with Reckon in FoxPro

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

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

  Use CData Power BI Connectors to visualize MongoDB in Power BI.

• Query Sage 50 UK in MySQL Workbench

  Create a virtual MySQL database for Sage 50 UK in CData Software Connect (or Connect Server) and work with live Sage 50 UK in MySQL Workbench.

• Connect to Sybase IQ in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Sybase IQ in the Denodo Virtual DataPort Administrator.

• Zoho CRM: "Invalid_Client" Error After Successful OAuth Authorization

  In this entry, you will find the resolution to the most common cause of the "Invalid_Client" error, despite seeing a successful OAuth authorization in the browser.

• Access Live SAP Netweaver Gateway in TIBCO Data Virtualization

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

• Build Pipelines with Live Snapchat Ads in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Snapchat Ads from Google Cloud Data Fusion, enabling the integration of live Snapchat Ads into the building and management of effective data pipelines.

• Access Live Outreach.io in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

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

• How to Connect DBeaver to eBay via a JDBC Driver

  Manage eBay with visual tools in DBeaver like the query browser.

• Connect to ClickUp in JRuby

  Create a simple JRuby app with access to live ClickUp.

• How to Access Sage 300 Using Entity Framework

  This article shows how to access Sage 300 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Automated Continuous Pipedrive Replication to Apache Kafka

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

• Stream Todoist into Apache Kafka Topics

  Access and stream Todoist in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automate Sage 300 Replication to Azure Synapse

  Use CData Sync to customize and automate Sage 300 replication to Azure Synapse.

• Automated Continuous Presto Replication to Apache Kafka

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

• Connect to Harvest in DBArtisan

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

• PowerShell Scripting to Replicate Zendesk to MySQL

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

• How to integrate Metabase with ADP

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

• Replicate Jira for Use in Salesforce Connect

  Replicate Atlassian Jira to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Visualize Outreach.io in TIBCO Spotfire through OData

  Integrate Outreach.io into dashboards in TIBCO Spotfire.

• Build ADP-Connected Web Apps in Servoy

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

• Access Live GraphQL in Google Sheets through Connect Spreadsheets

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

• Import Clio into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Clio. In this article, you will use the OData format to import Clio into Microsoft Power Query.

• Extract, Transform, and Load Redis in Informatica PowerCenter

  Create a simple Workflow for Redis in Informatica PowerCenter.

• Connect to Live Odoo in MicroStrategy through CData Connect Cloud

  Create a live connection to Odoo in CData Connect Cloud and connect to your Odoo ERP from MicroStrategy.

• Create SuiteCRM-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to SuiteCRM from Klipfolio and build custom visualizations using live SuiteCRM.

• Import SAP Concur Using Azure Data Factory

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

• Use the CData ODBC Driver for Calendly from SharePoint Excel Services

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

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

  Use CData Power BI Connectors to visualize BambooHR in Power BI.

• How to Connect to & Open Avro in Microsoft Excel

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

• DataBind Wijmo Grid to Raisers Edge NXT

  Provide real-time Raisers Edge NXT to interactive controls.

• Operational Reporting on SAP Ariba Procurement from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote SAP Ariba Procurement.

• «
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• »