CData Software - Knowledge Base

Recent Articles

• «
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• »

• Connect to Pipedrive in the Denodo Platform

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

• How to Work with Invoiced in ETL Validator JDBC

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

• Process & Analyze ServiceNow in Databricks (AWS)

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

• Connect to Drip from a Connection Pool in Jetty

  The Drip JDBC Driver supports connection pooling: This article shows how to connect faster to Drip from Web apps in Jetty.

• Automated Continuous DB2 Replication to SingleStore

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

• Publish XML-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live XML Files.

• How to import Google Search Results into Apache Solr

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

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

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

• Process & Analyze ActiveCampaign in Databricks (AWS)

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

• Power BI Connector Getting Started Guide

  A basic guide to connecting Power BI to data from anywhere using the CData Power BI Connector.

• How to Connect the Power BI Service to Wave Financial: Complete Guide

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

• Integrate Oracle Sales in the Pentaho Report Designer

  Publish reports based on Oracle Sales in the Pentaho BI tool.

• Connect to Zoho Books from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Zoho Books to connect to Zoho Books and execute queries in PowerBuilder.

• Connect to Presto in DBArtisan

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

• Automated Continuous Sage 50 UK Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Apache Kafka.

• Integrate Live Salesforce Pardot into Custom Business Apps Built in Power Apps

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

• Use JayDeBeApi to access Oracle SCM in Python

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

• Create Dynamics 365 Business Central-Connected Business Apps in AppSheet

  Connect to Dynamics 365 Business Central via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Dynamics 365 Business Central.

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

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

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

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

• Integrate with Live SharePoint in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to SharePoint from the MuleSoft Anypoint Platform to integrate live Microsoft SharePoint into custom reports and dashboards.

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

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

• Build Semantic Layer Views for Google Search Results in APOS Live Data Gateway

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

• Integrate with Live QuickBooks Time in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to QuickBooks Time from the MuleSoft Anypoint Platform to integrate live QuickBooks Time into custom reports and dashboards.

• Automated Continuous Printify Replication to Apache Kafka

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

• Build Excel Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Microsoft Excel and build visualizations in Tableau Cloud.

• How to Visualize Dynamics 365 Business Central Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Dynamics 365 Business Central in Python.

• Automate Shopify Integration Tasks from PowerShell

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

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

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

• Automated Continuous Splunk Replication to MongoDB

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

• Automate Cloudant Replication to Couchbase

  Use CData Sync to Customize and automate IBM Cloudant replication to Couchbase.

• Visualize Adobe Commerce in TIBCO Spotfire through ADO.NET

  Integrate Adobe Commerce into dashboards in TIBCO Spotfire.

• Analyze SingleStore in R

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

• Create Reports with Jira Service Management in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Atlassian Jira Service Management.

• Query Coinbase as a MySQL Database in Node.js

  Execute MySQL queries against Coinbase from Node.js.

• Model, Search, and Visualize Live Zoho Creator in ThoughtSpot

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

• Oracle SCM Reporting in OBIEE with the Oracle SCM JDBC Driver

  Deploy the Oracle SCM JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• How to Use CData Connect to Access Live SAP in Power Automate

  CData Connect for SAP enables you to integrate SAP ERP/NetWeaver into workflows built using Microsoft Power Automate Desktop.

• Export Data from SQL Server to eBay through SSIS

  Easily push SQL Server data to eBay using the CData SSIS Tasks for eBay.

• Visualize LDAP Objects in Sisense

  Create an ElastiCube in Sisense app with access to LDAP.

• Build an OLAP Cube in SSAS from REST

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

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

• Integrate with live MySQL in Jitterbit

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

• Publish Reports with Zoom in SAP Crystal Reports

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

• Use Biml to Build SSIS Tasks to Replicate Microsoft Project to SQL Server

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

• Create Apps from Dynamics NAV in Qlik Sense Cloud

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

• How to create Phoenix federated tables in MySQL

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

• Create Dynamic Facebook Ads Grids Using the Infragistics XamDataGrid

  Learn how you can connect Facebook Ads to Infragistics XamDataGrid to build dynamic grids.

• Feed Avro into FineReport

  How to set Apache Avro as a JDBC data source in FineReport.

• Connect to Dropbox in HULFT Integrate

  Connect to Dropbox as a JDBC data source in HULFT Integrate

• DataBind Avro to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Avro with the DevExpress Windows Forms and Web controls to provide Apache Avro to a chart.

• Use Dash to Build to Web Apps on EventBrite

  Create Python applications that use pandas and Dash to build EventBrite-connected web apps.

• Build Apps with Live MYOB AccountRight in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live MYOB AccountRight into the Adalo platform and build custom mobile and web applications with real-time MYOB AccountRight.

• Publish Reports with Drift in SAP Crystal Reports

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

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

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

• Create Splunk-Connected Business Apps in AppSheet

  Connect to Splunk via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Splunk.

• Visualize Live Bitbucket in Tableau

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

• Connect to Box in RapidMiner

  Integrate Box with standard components and data source configuration wizards in RapidMiner Studio.

• Automate Google Ad Manager Integration Tasks from PowerShell

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

• Access Neo4J from MySQL in Amazon QuickSight

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

• Build Veeva-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Veeva from Choreo and build custom apps using live Veeva Vault.

• Query, Visualize, and Share live Zoho Projects in Redash

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

• Import BigQuery into the Power BI Service for Visualizations

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

• How to connect to SAP ByDesign from Spring Boot

  Connect to SAP ByDesign in a Spring Boot Application using CData JDBC SAP ByDesign Driver

• How to work with ServiceNow in Apache Spark using SQL

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

• How to connect to Zoho CRM from IntelliJ

  Integrate connectivity to Zoho CRM with wizards in IntelliJ.

• Create Informatica Mappings From/To a JDBC Data Source for Dynamics 365 Business Central

  Create Dynamics 365 Business Central data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Build a Simple VCL Application for eBay Analytics

  How to build a simple VCL Application to view eBay Analytics in RAD Studio using the CData ODBC Driver for eBay Analytics.

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

  Execute SQL Server queries against MailChimp from Node.js.

• How to connect to MariaDB with Squirrel SQL client

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

• How to Connect to Cvent in Using Python: 6 Steps

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

• Import Real-Time Databricks in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Databricks in ColdFusion.

• Import Real-Time PostgreSQL in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use PostgreSQL in ColdFusion.

• Connect to Oracle Eloqua from a Connection Pool in JBoss

  Integrate Oracle Eloqua into Java servlets: Use the Management Console in JBoss to install the Oracle Eloqua JDBC Driver.

• Build Xero-Connected ETL Processes in Google Data Fusion

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

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

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

• Bridge GitHub Connectivity with Apache NiFi

  Access and process GitHub in Apache NiFi using the CData JDBC Driver.

• How to connect to Aha in DBVisualizer

  Integrate Aha! with visual data analysis tools and data connection wizards in DBVisualizer

• How to Connect DBeaver to HDFS via a JDBC Driver

  Manage Apache HDFS with visual tools in DBeaver like the query browser.

• Integrate QuickBooks Online in the Pentaho Report Designer

  Publish reports based on QuickBooks Online in the Pentaho BI tool.

• Import and Visualize QuickBooks Time in Power View

  Create data visualizations based on QuickBooks Time in Excel.

• Access Live SQL Analysis Services in TIBCO Data Virtualization

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

• Automated Continuous YouTube Analytics Replication to Apache Kafka

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

• Connect to ClickUp in Google Apps Script

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

• How to Query CSV in MySQL Workbench

  Execute MySQL queries against live CSV/TSV Files from MySQL Workbench.

• LINQ to Azure DevOps

  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 Azure DevOps Data Provider.

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

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

• Integrate Live Blackbaud FE NXT into Amazon SageMaker Canvas with RDS

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

• Connect to and Visualize Live Drift in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Drift.

• How to Connect to MySQL in Using Python: 6 Steps

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

• Replicate SQL Server to Multiple Databases

  Replicate Microsoft SQL Server to disparate databases with a point-and-click configuration.

• Automated Continuous Twitter Ads Replication to Amazon Redshift

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

• Replicate Google Search Results to Multiple Databases

  Replicate Google Search to disparate databases with a point-and-click configuration.

• PowerShell Scripting to Replicate Smartsheet to MySQL

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

• Visualize Live Oracle Financials Cloud in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle Financials Cloud.

• Access REST from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live REST from HeidiSQL.

• Enable the Reckon JDBC Driver in KNIME

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

• Connect to Facebook in SpagoBI

  Create reports featuring live Facebook in SpagoBI Studio. Host Facebook reports on SpagoBI Server.

• Analyze Live Cassandra in SAS Viya

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

• Viewing SAP ByDesign in RAD Studio Data Explorer

  How to view SAP Business ByDesign in RAD Studio Data Explorer using the CData ODBC Driver for SAP ByDesign.

• «
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• »