CData Software - Knowledge Base

Recent Articles

• «
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• »

• Connect to SAP Ariba Source in NetBeans

  Connect to SAP Ariba Source in NetBeans with the data source configuration wizard.

• Prepare, Blend, and Analyze Dynamics 365 in Alteryx Designer

  Build workflows to access live Microsoft Dynamics 365 for self-service data analytics.

• ETL Slack in Oracle Data Integrator

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

• Using AngularJS to Build Dynamic Web Pages with Klaviyo

  Use the CData Connect Server to create Klaviyo OData feeds and build single-page applications with live Klaviyo.

• Automate CouchDB Replication to SAP HANA

  Use CData Sync to customize and automate Apache CouchDB replication to SAP HANA.

• Load Typeform to a Database Using Embulk

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

• Build MVC Applications with Connectivity to Tableau CRM Analytics

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

• Connect to SAP ByDesign from a Connection Pool in JBoss

  Integrate SAP Business ByDesign into Java servlets: Use the Management Console in JBoss to install the SAP ByDesign JDBC Driver.

• PowerShell Scripting to Replicate Dynamics 365 Business Central to MySQL

  Write a simple PowerShell script to replicate Dynamics 365 Business Central to a MySQL database.

• Integrate Raisers Edge NXT into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Raisers Edge NXT and integrate live Raisers Edge NXT into your Power Automate tasks.

• Salesforce Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Salesforce facts in real time.

• Edit and Search External Zenefits Objects in Salesforce Connect

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

• Visualize Act CRM from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Act CRM.

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

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

• Integrate Zuora into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Zuora and integrate live Zuora into your Power Automate tasks.

• Automate Snowflake Replication to Azure Data Lake

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

• Use the CData Software JDBC Driver for Raisers Edge NXT in MicroStrategy

  Connect to Raisers Edge NXT in MicroStrategy Developer using the CData Software JDBC Driver for Raisers Edge NXT.

• ETL Todoist in Oracle Data Integrator

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

• How to integrate Gmail with Apache Airflow

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

• Automated Continuous Bing Search Replication to MongoDB

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Wave Financial

  Provide connectivity to Wave Financial through an SAP BusinessObjects universe.

• Access SQL Server from MySQL in Amazon QuickSight

  Connect to SQL Server and build visualizations of Microsoft SQL Server using a MySQL Connection in Amazon QuickSight.

• How to Connect DBeaver to Avalara AvaTax via a JDBC Driver

  Manage Avalara AvaTax with visual tools in DBeaver like the query browser.

• Connect to Dynamics CRM in DBArtisan

  Use wizards in DBArtisan to configure Microsoft Dynamics CRM as a data source.

• Enable the Jira JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Atlassian Jira.

• Automated Continuous Splunk Replication to SingleStore

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

• Using the CData Software ODBC Driver for SAS Data Sets in PyCharm

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

• Integrate with live Azure Analysis Services in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Azure Analysis Services in Jitterbit.

• Query CSV through ODBC in Node.js

  Use node-odbc to execute SQL queries against CSV/TSV Files from Node.js.

• Integrate WooCommerce with External Services using SnapLogic

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

• Integrate WooCommerce into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to WooCommerce and integrate live WooCommerce into your Power Automate tasks.

• Visualize Live SAP Business One in the Power BI Service

  Use CData Connect Cloud to connect to live SAP Business One and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to work with ActiveCampaign in Apache Spark using SQL

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

• Explore Geographical Relationships in Amazon DynamoDB with Power Map

  Create data visualizations with Amazon DynamoDB in Power Map.

• Replicate Azure DevOps from PowerShell

  Write a quick PowerShell script to query Azure DevOps. Use connectivity to the live data to replicate Azure DevOps to SQL Server.

• How to connect to LinkedIn Ads from Spring Boot

  Connect to LinkedIn Ads in a Spring Boot Application using CData JDBC LinkedIn Ads Driver

• Access Live Aha in Coginiti Pro

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

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

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

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

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

• Connect to Slack in NetBeans

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

• Import Real-Time Jira Service Management in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Atlassian Jira Service Management in ColdFusion.

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

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

• Edit and Search External HubSpot Objects in Salesforce Connect

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

• Access Live Azure Active Directory in AWS Lambda (with IntelliJ IDEA)

  Connect to live Azure Active Directory in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Use the CData Software JDBC Driver for Stripe in MicroStrategy

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

• Explore Geographical Relationships in HubDB with Power Map

  Create data visualizations with HubDB in Power Map.

• Connect to Twitter in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Establish a Live Connection with TigerGraph using Tableau Bridge

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

• Model, Search, and Visualize Live Facebook in ThoughtSpot

  Use CData Connect Cloud to connect to live Facebook for modeling, searching, and visualizing.

• Use CData Connect Cloud to Access SurveyMonkey in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live SurveyMonkey in the Power Pivot business intelligence tool.

• Create Paylocity-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Paylocity from OutSystems and build custom enterprise apps using live Paylocity.

• Design BIRT Reports on Exact Online

  Provide current Exact Online to your embedded analytics.

• Analyze eBay in R

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

• Build Freshdesk-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Freshdesk.

• Connect to EventBrite in Ruby

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

• Connect to Twitter Ads in the Denodo Platform

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

• Integrate Bullhorn CRM in the Pentaho Report Designer

  Publish reports based on Bullhorn CRM in the Pentaho BI tool.

• Connect to NetSuite from PowerBuilder

  This article demonstrates how to access NetSuite CRM & ERP from Appeon PowerBuilder using the CData ADO.NET Provider for NetSuite.

• Build Salesforce Pardot-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Salesforce Pardot.

• Create Teradata-Connected Visualizations in Klipfolio

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

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

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

• How to update Paylocity from Excel

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

• How to connect to Neo4J in DBVisualizer

  Integrate Neo4J with visual data analysis tools and data connection wizards in DBVisualizer

• Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy Desktop

  Connect to Dynamics 365 Business Central in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics 365 Business Central.

• Analyze CockroachDB in Cognos Analytics

  Use CData Connect Cloud to connect to CockroachDB from Cognos Analytics and analyze live CockroachDB.

• Automated Continuous Google Calendar Replication to Local Delimited Files

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

• Back Up Atlassian Jira to SQL Server through SSIS

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

• How to connect to ActiveCampaign with Squirrel SQL client

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

• Automated Continuous Salesloft Replication to SQLite

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

• Build Automated Workflows with Live Airtable in Workato

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

• Automated Continuous Azure Data Lake Storage Replication to Azure SQL

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

• Visualize Live Sage Cloud Accounting of Power BI Report Builder in Power BI Service

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

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

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

• How to connect and process Oracle SCM from Azure Databricks

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

• PowerShell Scripting to Replicate Excel to MySQL

  Write a simple PowerShell script to replicate Microsoft Excel to a MySQL database.

• Access Live HDFS in AWS Lambda (with IntelliJ IDEA)

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

• Automated Continuous Aha Replication to PostgreSQL

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

• Using AngularJS to Build Dynamic Web Pages with SAP Netweaver Gateway

  Use the CData Connect Server to create SAP Netweaver Gateway OData feeds and build single-page applications with live SAP Netweaver Gateway.

• Load PayPal to a Database Using Embulk

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

• Publish TaxJar-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live TaxJar.

• Replicate SAP Netweaver Gateway to Multiple Databases

  Replicate SAP Netweaver Gateway to disparate databases with a point-and-click configuration.

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

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

• DataBind Charts to Sybase

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

• How to connect to Klaviyo in DBVisualizer

  Integrate Klaviyo with visual data analysis tools and data connection wizards in DBVisualizer

• Build Adobe Analytics-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Adobe Analytics.

• Automated Continuous DocuSign Replication to Azure SQL

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

• How to connect to ShipStation from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for ShipStation and work with ShipStation in Microsoft Excel on Mac OS X.

• Analyze Klaviyo in R

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

• Explore Geographical Relationships in Amazon Athena with Power Map

  Create data visualizations with Amazon Athena in Power Map.

• How to Work with Reckon Accounts Hosted in AWS Glue Jobs Using JDBC

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

• Analyze OData Services in Cognos Analytics

  Use CData Connect Cloud to connect to OData Services from Cognos Analytics and analyze live OData.

• How to Access Live IBM Cloud Object Storage in Power Automate Desktop via ODBC

  The CData ODBC Driver for IBM Cloud Object Storage enables you to integrate IBM Cloud Object Storage into workflows built using Microsoft Power Automate Desktop.

• Query XML in ColdFusion

  Write standard ColdFusion data access code to connect to XML Files.

• Connect to Redis through External Services in Salesforce

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

• How to update MariaDB from Excel

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

• Build Charts with LDAP Objects in Clear Analytics

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

• Connect to Shopify in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Shopify and connect to Shopify in Akorbi Digital RunMyProcess.

• How to connect to SingleStore with Squirrel SQL client

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

• Connect to Shopify in as an External Source in Dremio

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

• Analyze Microsoft Dataverse in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Microsoft Dataverse (CDS) and visualize Microsoft Dataverse (CDS) in SAP Analytics Cloud.

• «
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• »