CData Software - Knowledge Base

Recent Articles

• «
• 217
• 218
• 219
• 220
• 221
• 222
• 223
• 224
• 225
• 226
• »

• How to pipe OneNote to CSV in PowerShell

  Use standard PowerShell cmdlets to access OneNote tables.

• Automate Trello Replication to Couchbase

  Use CData Sync to Customize and automate Trello replication to Couchbase.

• Publish Greenplum-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Pivotal GreenPlum.

• Build Dynamics CRM-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Microsoft Dynamics CRM and build web apps with connectivity to live Microsoft Dynamics CRM.

• Create Microsoft Exchange Dataflows on PowerBI.com

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

• Automated Continuous GraphQL Replication to MongoDB

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

• Connect to Zenefits from Blazor Apps

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

• Automated Continuous Azure Active Directory Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Amazon Redshift.

• Build Visualizations of SAP SuccessFactors in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP SuccessFactors in Birst.

• Create Dashboards and Visualize Live Backlog in Geckoboard

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

• Prepare, Blend, and Analyze Clio in Alteryx Designer (ODBC)

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

• Connect to Bullhorn CRM in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Bullhorn CRM in Airbyte.

• How to Build an ETL App for SAP Business One in Python with CData

  Create ETL applications and real-time data pipelines for SAP Business One in Python with petl.

• Access Live Cassandra in Coginiti Pro

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

• Connect to Zoho Books as an External Source in Dremio

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

• Prepare, Blend, and Analyze Pipedrive in Alteryx Designer (ODBC)

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

• Create Avalara AvaTax Dataflows on PowerBI.com

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

• Connect to Oracle SCM in Ruby

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

• Connect to eBay in RunMyProcess through Connect Cloud

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

• Use the CData Software ODBC Driver for FTP in MicroStrategy Web

  Connect to FTP Servers in MicroStrategy Web using the CData Software ODBC Driver for FTP.

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

  Use CData Power BI Connectors to visualize Microsoft Excel in Power BI.

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

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

• Build a Simple VCL Application for Greenplum

  How to build a simple VCL Application to view Pivotal GreenPlum in RAD Studio using the CData ODBC Driver for Greenplum.

• Connect to BigCommerce from PowerBuilder via ODBC

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

• Working with Microsoft Exchange in LINQPad

  Execute LINQ queries to Microsoft Exchange in LINQPad.

• Natively Connect to Microsoft Teams in PHP

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

• Visualize Trello in TIBCO Spotfire through ODBC

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

• Connect to Oracle Eloqua in RazorSQL

  Connect to Oracle Eloqua from wizards and query Oracle Eloqua from the GUI in the RazorSQL database management tool.

• Automated Sybase IQ Replication to Teradata

  Use CData Sync to Customize and automate Sybase IQ replication to Teradata.

• Create Apps from Pinterest in Qlik Sense Cloud

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

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

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

• Create Data Visualizations in Cognos BI with Clio

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

• Build Visualizations of SAP HANA in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA in Birst.

• Build Phoenix-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Apache Phoenix and build visualizations and dashbaords from Apache Phoenix in Redash.

• How to connect PolyBase to Smartsheet

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

• Automated Continuous DB2 Replication to Azure SQL

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

• Query XML as a MySQL Database in Node.js

  Execute MySQL queries against XML Files from Node.js.

• Bridge Salesforce Marketing Connectivity with Apache NiFi

  Access and process Salesforce Marketing Cloud in Apache NiFi using the CData JDBC Driver.

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

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

• Use Biml to Build SSIS Tasks to Replicate Jira Service Management to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Atlassian Jira Service Management to SQL Server.

• Replicate Office 365 to Multiple Databases via the CData Sync CLI

  Replicate Microsoft Office 365 to disparate databases with a single configuration.

• Bridge Sage Intacct Connectivity with Apache NiFi

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

• Perform Batch Operations with Snowflake in Apache NiFi

  Connect to Snowflake and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Create Workday Dashboards in Bold BI

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

• Operational Reporting on BigQuery from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Google BigQuery.

• Query Procore through ODBC in Node.js

  Use node-odbc to execute SQL queries against Procore from Node.js.

• DataBind Charts to Oracle Sales

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

• Analyze Sage 300 in Infragistics Reveal

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

• Use the CData Software JDBC Driver for Elasticsearch in MicroStrategy Web

  Connect to Elasticsearch in MicroStrategy Web using the CData Software JDBC Driver for Elasticsearch.

• How to Connect the Power BI Service to EnterpriseDB: Complete Guide

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

• Query Microsoft Planner in MySQL Workbench

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

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

  Provide connectivity to Email through an SAP BusinessObjects universe.

• Create a Data Access Object for REST using JDBI

  A brief overview of creating a SQL Object API for REST in JDBI.

• Excel Spreadsheet Automation on Google Campaign Manager 360 with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Create Act-On-Connected Business Apps in AppSheet

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

• Import Act CRM into the Power BI Service for Visualizations

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

• Use Dash to Build to Web Apps on Kintone

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

• Visualize FTP in Tableau

  The CData ODBC driver for FTP enables you integrate FTP Servers into Tableau dashboards.

• How to Access Live Twitter in Power Automate Desktop via ODBC

  The CData ODBC Driver for Twitter enables you to integrate Twitter into workflows built using Microsoft Power Automate Desktop.

• Visualize Google Ad Manager in TIBCO Spotfire through OData

  Integrate Google Ad Manager into dashboards in TIBCO Spotfire.

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

• Import Real-Time Parquet via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Apache Parquet in ColdFusion.

• How to connect to Access with Squirrel SQL client

  Connect to Microsoft Access and execute queries in the Squirrel SQL Client.

• How to Access Live BambooHR in Power Automate Desktop via ODBC

  The CData ODBC Driver for BambooHR enables you to integrate BambooHR into workflows built using Microsoft Power Automate Desktop.

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

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

• Automated Continuous Databricks Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Databricks replication to SQL Server.

• How to Work with Drip in ETL Validator JDBC

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

• Automated Continuous Act-On Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Act-On replication to Google Cloud SQL.

• Connect to and Visualize Live Facebook in Tableau Prep

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

• Connect to Salesloft from PowerBuilder via ADO.NET

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

• Working with Asana in LINQPad

  Execute LINQ queries to Asana in LINQPad.

• Access Google Calendar from MySQL in HeidiSQL

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

• Build Salesforce Marketing-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Salesforce Marketing Cloud and build web apps with connectivity to live Salesforce Marketing Cloud.

• Integrate Live Oracle Financials Cloud into Custom Business Apps Built in Power Apps

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

• How to connect PolyBase to Todoist

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

• Bridge Bitbucket Connectivity with Apache NiFi

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

• Create a Data Access Object for Google Analytics using JDBI

  A brief overview of creating a SQL Object API for Google Analytics in JDBI.

• Natively Connect to Sybase IQ in PHP

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

• Using the CData Software ODBC Driver for SharePoint in PyCharm

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

• Access Act-On 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 Act-On.

• Use the CData ODBC Driver for Dynamics NAV from SharePoint Excel Services

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

• Visualize Spark in TIBCO Spotfire through ODBC

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

• Access Live Oracle Service Cloud in Coginiti Pro

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

• Automate Airtable Replication to Couchbase

  Use CData Sync to Customize and automate Airtable replication to Couchbase.

• Automated Continuous Greenplum Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Greenplum replication to AlloyDB.

• How to connect to Drift from Spring Boot

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

• Import Real-Time SAP Netweaver Gateway via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use SAP Netweaver Gateway in ColdFusion.

• Build Printify-Connected ETL Processes in Google Data Fusion

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

• How to integrate DocuSign with Apache Airflow

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

• Build Data Flows from Freshdesk to SQL Server using SSIS

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

• How to Access Live Sybase in Power Automate Desktop via ODBC

  The CData ODBC Driver for Sybase enables you to integrate Sybase into workflows built using Microsoft Power Automate Desktop.

• Automated Continuous HubSpot Replication to SQLite

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

• Creating JSON-Connected Applications in Unqork

  You can use CData Connect to feed JSON to Unqork and build custom business apps.

• Model, Search, and Visualize Live Excel Online in ThoughtSpot

  Use CData Connect Cloud to connect to live Microsoft Excel Online for modeling, searching, and visualizing.

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

• How to connect to Reckon from IntelliJ

  Integrate connectivity to Reckon with wizards in IntelliJ.

• Connect to ShipStation in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for ShipStation in Airbyte.

• Query Azure DevOps as a SQL Server Database in Node.js

  Execute SQL Server queries against Azure DevOps from Node.js.

• Access Live Azure Analysis Services in TIBCO Data Virtualization

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

• Use the CData Software JDBC Driver for Bing Ads in MicroStrategy Desktop

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

• «
• 217
• 218
• 219
• 220
• 221
• 222
• 223
• 224
• 225
• 226
• »