CData Software - Knowledge Base

Recent Articles

• «
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• 231
• 232
• 233
• »

• Load Greenplum to a Database Using Embulk

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

• Visualize XML in Tableau

  The CData ODBC driver for XML enables you integrate XML Files into Tableau dashboards.

• Connect to Twilio in DBeaver

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

• Create Datasets from Databricks in Domo Workbench and Build Visualizations of Databricks in Domo

  Use the CData Software ODBC Driver for Databricks to create datasets from Databricks in Domo Workbench and then build visualizations in the Domo service.

• Author and Share Power BI Reports on Real-Time Marketo

  Use the CData ODBC Driver for Marketo to visualize Marketo in Power BI Desktop and then upload to the Power BI service.

• Connect to Clio in CloverDX (formerly CloverETL)

  Transfer Clio using the visual workflow in the CloverDX data integration tool.

• Automated Continuous Confluence Replication to SingleStore

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

• Connect to Live Snowflake in MicroStrategy through CData Connect Cloud

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

• Visualize Couchbase in TIBCO Spotfire through OData

  Integrate Couchbase into dashboards in TIBCO Spotfire.

• Integrate Microsoft Project into Power Automate Desktop using CData Connect

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

• Automated Continuous Stripe Replication to Oracle

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

• How to pipe EnterpriseDB to CSV in PowerShell

  Use standard PowerShell cmdlets to access EnterpriseDB tables.

• Automated Continuous Zoho Creator Replication to Amazon S3

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

• Integrate Live SAP Business One into Custom Business Apps Built in Power Apps

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

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

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

• Build MYOB AccountRight-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for MYOB AccountRight and create custom apps in Bubble.

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

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

• Connect to Printify as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Printify.

• Visualize Twitter Ads from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Twitter Ads.

• Access Oracle HCM Cloud in PHP through Connect Server

  Connect to Oracle HCM Cloud through the standard SQL Server libraries in PHP.

• Connect to Snowflake from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Snowflake to connect to Snowflake from Web applications running on WebLogic.

• Connect to GitHub in Airbyte ELT Pipelines

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

• Creating PayPal-Connected Applications in Unqork

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

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

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

• Import and Visualize Amazon Athena in Power View

  Create data visualizations based on Amazon Athena in Excel.

• Access Live LDAP Objects in Coginiti Pro

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

• Process & Analyze Zoho Inventory in Databricks (AWS)

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

• Automated Continuous Salesforce Pardot Replication to Oracle

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Oracle.

• Natively Connect to Twitter in PHP

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

• How to Work with Amazon Athena in ETL Validator JDBC

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

• Automated Continuous AlloyDB Replication to Apache Cassandra

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

• How to create Azure Data Catalog federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Data Catalog in MySQL .

• Integrate with SAP Ariba Procurement in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live SAP Ariba Procurement in SnapLogic.

• How to publish and share Google Calendar dashboards with Tableau Server

  The CData ODBC driver for Google Calendar enables you integrate Google Calendar into Tableau dashboards.

• Analyze Neo4J in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Neo4J and visualize Neo4J in SAP Analytics Cloud.

• Build WooCommerce Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live WooCommerce and build visualizations in Tableau Cloud.

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

  Connect to Marketo from a connection pool in Tomcat.

• Query Dynamics 365 Business Central in ColdFusion

  Write standard ColdFusion data access code to connect to Dynamics 365 Business Central.

• Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy Desktop

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

• How to connect PolyBase to XML

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

• Connect to Amazon S3 in DBArtisan

  Use wizards in DBArtisan to configure Amazon S3 as a data source.

• Automated Continuous Dynamics 365 Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Snowflake.

• Operational Reporting on Kintone from Spotfire Server

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

• Access EnterpriseDB from MySQL in HeidiSQL

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

• 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.

• Integrate Reckon into Automated Tasks with Power Automate

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

• Automated Continuous CouchDB Replication to Local Delimited Files

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

• Connect to Aha in RazorSQL

  Connect to Aha from wizards and query Aha! from the GUI in the RazorSQL database management tool.

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

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

• How to create Freshdesk federated tables in MySQL

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

• Connect to Live Oracle Sales in MicroStrategy through CData Connect Cloud

  Create a live connection to Oracle Sales in CData Connect Cloud and connect to your Oracle Sales from MicroStrategy.

• Create Redis-Connected Dashboards in Grafana

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

• Access Dynamics CRM from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics CRM from HeidiSQL.

• Integrate Twitter Ads into Power Automate Desktop using CData Connect

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

• Back Up Salesforce Data Cloud to SQL Server through SSIS

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

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

  Create an ODBC connection to Cassandra in Informatica and browse and transfer Apache Cassandra.

• Connect to Sage Cloud Accounting in SpagoBI

  Create reports featuring live Sage Business Cloud Accounting in SpagoBI Studio. Host Sage Cloud Accounting reports on SpagoBI Server.

• Use the CData Software JDBC Driver for JotForm in MicroStrategy

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

• Connect to and Query ActiveCampaign in QlikView over ODBC

  Create data visualizations with ActiveCampaign in QlikView.

• Visualize Live Reckon of Power BI Report Builder in Power BI Service

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

• How to pipe Stripe to CSV in PowerShell

  Use standard PowerShell cmdlets to access Stripe tables.

• Build Data Flows from SAP Ariba Source to SQL Server using SSIS

  Easily back up SAP Ariba Source to SQL Server using the SSIS components for SAP Ariba Source.

• Establish a Live Connection with Dropbox using Tableau Bridge

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

• Replicate OneNote to Multiple Databases

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

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

  Execute SQL Server queries against PayPal from Node.js.

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

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

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

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

• Connect to GraphQL in Google Apps Script via SQL Gateway

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

• Create ShipStation-Connected Nintex Workflows

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

• Connect to Microsoft Dataverse from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Microsoft Dataverse to connect to Microsoft Dataverse (CDS) and execute queries in PowerBuilder.

• Write a Simple Go Application to work with Odoo on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Odoo ERP.

• Use Dash to Build to Web Apps on Procore

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

• Create a Data Access Object for Veeva Vault using JDBI

  A brief overview of creating a SQL Object API for Veeva Vault & Vault CRM in JDBI.

• Connect to Microsoft OneDrive as an External Source in Dremio

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

• Create Dynamic Dynamics 365 Business Central Grids Using the Infragistics XamDataGrid

  Learn how you can connect Dynamics 365 Business Central to Infragistics XamDataGrid to build dynamic grids.

• Integrate Google Contacts in the Pentaho Report Designer

  Publish reports based on Google Contacts in the Pentaho BI tool.

• How to Work with OneNote in AWS Glue Jobs Using JDBC

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

• Build Data Flows from SQL Server to Wave Financial through SSIS

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

• Analyze XML with Power Pivot

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

• Connect to Live Salesforce in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Salesforce in CData Connect Cloud and connect to your Salesforce & Force.com from PostgreSQL.

• Access Live Oracle Financials Cloud in AWS Lambda (with IntelliJ IDEA)

  Connect to live Oracle Financials Cloud in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

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

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

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

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

• Stream Aha into Apache Kafka Topics

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

• Create Dynamics CRM-Connected Enterprise Applications in OutSystems

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

• How to Connect to & Open XML in Microsoft Excel

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

• Create Dashboards and Visualize Live API in Geckoboard

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

• Manage xBase in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for xBase.

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

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

• Publish Couchbase-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Couchbase.

• How to Query Live SingleStore Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live SingleStore data in natural language using Python.

• Query Zoho Inventory through ODBC in Node.js

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

• How to Access Power BI XMLA Using Entity Framework

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

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

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

• Viewing Monday.com in RAD Studio Data Explorer

  How to view Monday.com in RAD Studio Data Explorer using the CData ODBC Driver for Monday.com.

• Access Tableau CRM Analytics from MySQL in Amazon QuickSight

  Connect to Tableau CRM Analytics and build visualizations of Tableau CRM Analytics using a MySQL Connection in Amazon QuickSight.

• ConstantContact Reporting and Star Schemas in OBIEE

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

• Feed Twitter into FineReport

  How to set Twitter as a JDBC data source in FineReport.

• Query Veeva Vault as a MySQL Database in Node.js

  Execute MySQL queries against Veeva Vault & Vault CRM from Node.js.

• Access GraphQL in PHP through Connect Server

  Connect to GraphQL through the standard SQL Server libraries in PHP.

• «
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• 231
• 232
• 233
• »