CData Software - Knowledge Base

Recent Articles

• «
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• 117
• 118
• »

• Connect Splunk to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Splunk using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Use the CData Software ODBC Driver for Salesforce Data Cloud in MicroStrategy Desktop

  Connect to Salesforce Data Cloud in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce Data Cloud.

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

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

• Edit and Search Google Search External Objects in Salesforce Connect (API Server)

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

• Connect to Drift from a Connection Pool in Jetty

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

• Automated Continuous Avro Replication to Snowflake

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

• Connect to Clio in Aqua Data Studio

  Access Clio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Model Amazon Marketplace Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Amazon Marketplace, enabling the direct import of real-time Amazon Marketplace.

• Connect to JDBC-ODBC Bridge in HULFT Integrate

  Connect to JDBC-ODBC Bridge as a JDBC data source in HULFT Integrate

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

• Use the CData Software JDBC Driver for IBM Informix in MicroStrategy Desktop

  Connect to IBM Informix in MicroStrategy Desktop using the CData Software JDBC Driver for IBM Informix.

• Connect to Airtable from Blazor Apps

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

• How to connect to Slack from Spring Boot

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

• Publish IBM Cloud Object Storage-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live IBM Cloud Object Storage.

• Connect to Twitter in RunMyProcess through Connect Cloud

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

• Automated Continuous Box Replication to Databricks

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

• Automated Continuous Monday.com Replication to Apache Cassandra

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

• Integrate with RSS Feeds using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy RSS Feeds to a JSON file on disk.

• Connect to TigerGraph in RapidMiner

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

• Replicate Multiple SAP ByDesign Accounts

  Replicate multiple SAP ByDesign accounts to one or many databases.

• Manage Certinia in DBArtisan as a JDBC Source

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

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

  Execute SQL Server queries against Apache Spark SQL from Node.js.

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

  Provide connectivity to Zoho Inventory through an SAP BusinessObjects universe.

• Automated Continuous Marketo Replication to Amazon Redshift

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

• How to Work with Sage 50 UK in ETL Validator JDBC

  Connect to Sage 50 UK from ETL Validator jobs using the CData Software JDBC Driver.

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

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

• Use Biml to Build SSIS Tasks to Replicate Authorize.Net to SQL Server

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

• Excel Spreadsheet Automation on Tableau CRM Analytics with the QUERY Formula

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

• Build Dashboards with ActiveCampaign in DBxtra

  Create dynamic dashboards and perform analytics based on ActiveCampaign in DBxtra.

• Replicate MYOB AccountRight from PowerShell

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

• Integrate Salesforce Data Cloud with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Salesforce Data Cloud with External Services.

• Connect to Adobe Target as an External Source in Dremio

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

• Build a PostgreSQL Interface for Presto using the CData JDBC Driver

  Use the Remoting features of the Presto JDBC Driver to create a PostgreSQL entry-point for data access.

• Connect to Live Yahoo! Japan Data Solution in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Yahoo! Japan Data Solution in CData Connect Cloud and connect to your Yahoo! Japan Data Solution from PostgreSQL.

• Edit and Search External Sage 200 Objects in Salesforce Connect

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

• Connect to Tableau CRM Analytics in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Tableau CRM Analytics and the SQL Gateway to access Tableau CRM Analytics from Google Apps Script.

• Connect to Active Directory in SpagoBI

  Create reports featuring live Active Directory in SpagoBI Studio. Host Active Directory reports on SpagoBI Server.

• Automated Continuous SAP HANA XS Advanced Replication to SQLite

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to SQLite.

• How to pipe Sage 300 to CSV in PowerShell

  Use standard PowerShell cmdlets to access Sage 300 tables.

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

• Connect to Snapchat Ads as a Linked Server via SQL Gateway

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

• Stream PostgreSQL into Apache Kafka Topics

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

• Build Charts with Google Analytics in Clear Analytics

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

• Automate Google Ad Manager Replication to Azure Data Lake

  Use CData Sync to customize and automate Google Ad Manager replication to Azure Data Lake.

• Use the CData Software JDBC Driver for Tally in MicroStrategy Desktop

  Connect to Tally ERP in MicroStrategy Desktop using the CData Software JDBC Driver for Tally.

• Use Dash to Build to Web Apps on Zoom

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

• Visualize Couchbase from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Couchbase.

• Visualize SAS xpt in TIBCO Spotfire through ODBC

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

• How to connect to IBM Informix with Squirrel SQL client

  Connect to IBM Informix and execute queries in the Squirrel SQL Client.

• Automate Amazon S3 Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Amazon S3 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Connect to SharePoint in NetBeans

  Connect to Microsoft SharePoint in NetBeans with the data source configuration wizard.

• Integrate Typeform in Pentaho Data Integration

  Build ETL pipelines based on Typeform in the Pentaho Data Integration tool.

• Publish Crystal Reports on SAP Concur

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Concur.

• Use Biml to Build SSIS Tasks to Replicate Bing Ads to SQL Server

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

• Connect to Live GraphQL in MicroStrategy through CData Connect Cloud

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

• ETL Snowflake in Oracle Data Integrator

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

• How to integrate Act CRM with Apache Airflow

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

• How to connect to Snapchat Ads in DBVisualizer

  Integrate Snapchat Ads with visual data analysis tools and data connection wizards in DBVisualizer

• Use the CData Software ODBC Driver for IBM Informix in MicroStrategy Desktop

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

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

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

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

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

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

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

• Automated Continuous Odoo Replication to Apache Cassandra

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

• Connect to Freshdesk from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Freshdesk from Filemaker Pro on Mac.

• Configure the CData JDBC Driver for Authorize.Net in a Connection Pool in Tomcat

  Connect to Authorize.Net from a connection pool in Tomcat.

• Integrate Paylocity with External Services using SnapLogic

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

• Connect to NetSuite in NetBeans

  Connect to NetSuite CRM & ERP in NetBeans with the data source configuration wizard.

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

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

• Automated Continuous Salesforce Replication to MongoDB

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

• Consume Gmail OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Gmail feeds that reflect any changes in SAP Lumira.

• Feed Bing Ads into FineReport

  How to set Bing Ads as a JDBC data source in FineReport.

• Operational Reporting on Parquet from Spotfire Server

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

• Create Bullhorn CRM-Connected Nintex Workflows

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

• Connect to Workday in ACL Analytics

  Connect to Workday via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Workday.

• Analyze EventBrite with Power Pivot

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

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

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

• Integrate with Vault CRM using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Veeva Vault & Vault CRM to a JSON file on disk.

• Connect to Dropbox from Blazor Apps

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

• Connect to Sage 300 in RazorSQL

  Connect to Sage 300 from wizards and query Sage 300 from the GUI in the RazorSQL database management tool.

• Build Xero-Connected Web Apps in Servoy

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

• ETL Authorize.Net in Oracle Data Integrator

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

• Access Live SAP Concur Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live SAP Concur data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Connect to and Query Adobe Target in QlikView over ODBC

  Create data visualizations with Adobe Target in QlikView.

• How to create an RPA flow for Microsoft OneDrive in UiPath Studio

  Use the Microsoft OneDrive ODBC Driver to create workflows that access real-time Microsoft OneDrive without any coding.

• Connect to Dynamics 365 from a Connection Pool in JBoss

  Integrate Microsoft Dynamics 365 into Java servlets: Use the Management Console in JBoss to install the Dynamics 365 JDBC Driver.

• Build AI/ML Models with Live Okta Data using Dataiku

• «
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• 117
• 118
• »