CData Software - Knowledge Base

Recent Articles

• «
• 236
• 237
• 238
• 239
• 240
• 241
• 242
• 243
• 244
• 245
• »

• Add Active Directory to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Active Directory with the Informatica Enterprise Data Catalog to classify and organize data.

• Back Up Authorize.Net to SQL Server through SSIS

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

• Operational Reporting on Dynamics CRM from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Dynamics CRM.

• PowerShell Scripting to Replicate SAP Business One to MySQL

  Write a simple PowerShell script to replicate SAP Business One to a MySQL database.

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

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

• Natively Connect to Dynamics 365 Business Central in PHP

  The CData ODBC driver for Dynamics 365 Business Central enables you to create PHP applications with connectivity to Dynamics 365 Business Central. Leverage the native support for ODBC in PHP.

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

  Connect to Microsoft Teams from a connection pool in Tomcat.

• Stream ShipStation into Apache Kafka Topics

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

• Connect to Azure Data Lake Storage in Google Apps Script

  Use CData Connect Cloud to access Azure Data Lake Storage in Google Apps Script.

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

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

• Create SFTP Dashboards in Bold BI

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

• Manage BigCommerce in DBArtisan as a JDBC Source

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

• Create Neo4J-Connected Nintex Workflows

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

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

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

• Build Zoho Creator-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Zoho Creator from Zoho Analytics and import live Zoho Creator.

• Connect to Databricks in Google Apps Script

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

• Import and Visualize Azure DevOps in Power View

  Create data visualizations based on Azure DevOps in Excel.

• Process & Analyze Google Spanner in Databricks (AWS)

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

• Access Live Salesforce Pardot in Excel (Desktop)

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

• Work with Stripe in FoxPro

  Load Stripe into a FoxPro database. This article includes full code and a walk-through of the process.

• Model Outreach.io Using Azure Analysis Services

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

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

• Automated Continuous Airtable Replication to Azure SQL

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

• How to Connect to SAP Netweaver Gateway in Using Python: 6 Steps

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

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

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

• Choosing the Best Method to Connect Oracle Financials Cloud to SQL Server: 5 Options Explained

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

• Create SSAS Tabular Models from Zoho Projects

  How to build a SQL Server Analysis Service Tabular Model from Zoho Projects using CData drivers.

• Create Coinbase-Connected Nintex Workflows

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

• Perform Batch Operations with Microsoft Dataverse in Apache NiFi

  Connect to Microsoft Dataverse (CDS) and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Query OData Services through ODBC in Node.js

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

• Use the CData Software JDBC Driver for Bitbucket in MicroStrategy

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

• Visualize Live Bing Search Results in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Bing Search.

• Connect to Live Facebook Ads in MicroStrategy through CData Connect Cloud

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

• Access Avro from MySQL in HeidiSQL

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

• DataBind Wijmo Grid to Twitter Ads

  Provide real-time Twitter Ads to interactive controls.

• Use the CData Software JDBC Driver for Drip in MicroStrategy

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

• Connect to Oracle in Airbyte ELT Pipelines

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

• Replicate MongoDB for Use in Salesforce Connect

  Replicate MongoDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect to IBM Cloud Object Storage as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Cloud Object Storage.

• Configure a One-Way Send Port for the CData BizTalk Adapter for Salesforce

  Use the CData BizTalk Adapter for Salesforce with a one-way send port to execute updategrams and data manipulation SQL in BizTalk.

• Automated Continuous Authorize.Net Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Authorize.Net replication to Google BigQuery.

• Connect to Tableau CRM Analytics from a Connection Pool in Jetty

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

• How to update Dynamics 365 Business Central from Excel

  This article explains how to transfer data from Excel to Dynamics 365 Business Central using the Excel Add-In for Dynamics 365 Business Central.

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

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

• Use the CData Software ODBC Driver for Active Directory in MicroStrategy

  Connect to Active Directory in MicroStrategy Developer using the CData Software ODBC Driver for Active Directory.

• Feed Act CRM into FineReport

  How to set Act CRM as a JDBC data source in FineReport.

• Automate Bing Ads Replication to Couchbase

  Use CData Sync to Customize and automate Bing Ads replication to Couchbase.

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

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

• Build Snapchat Ads Visualizations in Tableau Cloud

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

• Connect to HarperDB in Google Apps Script

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

• Visualize Live SurveyMonkey in the Power BI Service

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

• Design BIRT Reports on Paylocity

  Provide current Paylocity to your embedded analytics.

• Create a Data Access Object for SAP SuccessFactors using JDBI

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

• Use the CData ODBC Driver for MySQL in Microsoft Power Query

  You can use the CData MySQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MySQL into Microsoft Power Query.

• Establish a Live Connection with Redshift using Tableau Bridge

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

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

  Connect to Oracle Eloqua from a connection pool in Tomcat.

• Automate JotForm Replication to Azure Synapse

  Use CData Sync to customize and automate JotForm replication to Azure Synapse.

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

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

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

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

• Connect to Wave Financial in HULFT Integrate

  Connect to Wave Financial as a JDBC data source in HULFT Integrate

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

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

• How to Query Twitter in MySQL Workbench

  Execute MySQL queries against live Twitter from MySQL Workbench.

• Visualize Live Splunk in the Power BI Service

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

• Explore Geographical Relationships in Bing Search Results with Power Map

  Create data visualizations with Bing Search in Power Map.

• Feed Sage 200 into FineReport

  How to set Sage 200 as a JDBC data source in FineReport.

• How to load Couchbase data into Elasticsearch via Logstash

  Introducing a simple method to load Couchbase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Connect to Twilio in DBArtisan

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

• Process & Analyze Azure Data Catalog in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Data Catalog .

• Design BIRT Reports on Excel Online

  Provide current Microsoft Excel Online to your embedded analytics.

• Connecting to Any ODBC Data Source as a Linked Server

  Use the TDS Remoting feature of the SQL Gateway to set up a linked server for any CData ODBC data source.

• Integrate with live SAP Business One in Jitterbit

  Use CData Connect Cloud to connect to and integrate live SAP Business One in Jitterbit.

• Connect to Quickbase in RazorSQL

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

• How to integrate Certinia with Apache Airflow

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

• Analyze API in Looker

  Use CData Connect Cloud to connect to API from Looker and build custom apps using live API.

• Connect to Live Sage Intacct in MicroStrategy through CData Connect Cloud

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

• Visualize Procore in Sisense

  Create an ElastiCube in Sisense app with access to Procore.

• Analyze ConstantContact in R

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

• Integrate Oracle into Power Automate Desktop using CData Connect

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

• Manage Amazon Athena in DBArtisan as a JDBC Source

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

• Automated Continuous Parquet Replication to Local Delimited Files

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

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

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

• How to publish and share Authorize.Net dashboards with Tableau Server

  The CData ODBC driver for Authorize.Net enables you integrate Authorize.Net into Tableau dashboards.

• How to create an RPA flow for Highrise in UiPath Studio

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

• Feed Dynamics NAV into FineReport

  How to set Microsoft Dynamics NAV as a JDBC data source in FineReport.

• Edit and Search External Zoom Objects in Salesforce Connect

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

• Analyze Power BI XMLA with Power Pivot

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

• Connect to CouchDB from a Connection Pool in JBoss

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

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

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

• Object-Relational Mapping (ORM) with Oracle SCM Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Oracle SCM into a Java-based ORM framework, Hibernate.

• Connect to LinkedIn Ads in HULFT Integrate

  Connect to LinkedIn Ads as a JDBC data source in HULFT Integrate

• Create Snapchat Ads-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Snapchat Ads from Klipfolio and build custom visualizations using live Snapchat Ads.

• Build Visualizations of Blackbaud FE NXT in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Blackbaud FE NXT in Birst.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Automated Continuous Azure Data Lake Storage Replication to SingleStore

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

• Prepare, Blend, and Analyze Square in Alteryx Designer

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

• Connect to SAP Hybris C4C in SpagoBI

  Create reports featuring live SAP Hybris C4C in SpagoBI Studio. Host SAP Hybris C4C reports on SpagoBI Server.

• Create Zuora-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Zuora from Klipfolio and build custom visualizations using live Zuora.

• Connect to Blackbaud FE NXT from PowerBuilder

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

• Back Up Google Ad Manager to SQL Server through SSIS

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

• Replicate SAP from PowerShell

  Write a quick PowerShell script to query SAP ERP/NetWeaver. Use connectivity to the live data to replicate SAP ERP/NetWeaver to SQL Server.

• «
• 236
• 237
• 238
• 239
• 240
• 241
• 242
• 243
• 244
• 245
• »