CData Software - Knowledge Base

Recent Articles

• «
• 102
• 103
• 104
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• »

• Connect to Jira Assets in HULFT Integrate

  Connect to Jira Assets as a JDBC data source in HULFT Integrate

• Use the CData Software JDBC Driver for SAP ByDesign in MicroStrategy Desktop

  Connect to SAP Business ByDesign in MicroStrategy Desktop using the CData Software JDBC Driver for SAP ByDesign.

• Connect to Google Campaign Manager 360 from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Campaign Manager 360, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Automated Continuous Oracle Sales Replication to Oracle

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

• Connect to EventBrite from PowerBuilder via ADO.NET

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

• Perform Batch Operations with Oracle in Apache NiFi

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

• Access Salesforce Data Cloud as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce Data Cloud from your Oracle system.

• Connect to Azure Synapse as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Azure Synapse.

• Build HBase-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Apache HBase and build web apps with connectivity to live Apache HBase.

• Create Microsoft Exchange Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Exchange data access from reports, embedded analytics, and more.

• ETL Power BI XMLA in Oracle Data Integrator

  This article shows how to transfer Power BI XMLA into a data warehouse using Oracle Data Integrator.

• Analyze Live OData Services in SAS Viya

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

• Build Apps with Live Outreach.io in Adalo using CData Connect Cloud

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

• How to Build an ETL App for Google Campaign Manager 360 in Python with CData

  Create ETL applications and real-time data pipelines for Google Campaign Manager 360 in Python with petl.

• Analyze Hive with Power Pivot

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

• Access HarperDB from MySQL in Amazon QuickSight

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

• How to Query Jira Service Management in MySQL Workbench

  Execute MySQL queries against live Atlassian Jira Service Management from MySQL Workbench.

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

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

• Create IBM Cloud Data Engine Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time IBM Cloud Data Engine data access from reports, embedded analytics, and more.

• Access SAP Concur from MySQL in HeidiSQL

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

• Manage SAP Hybris C4C in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SAP Hybris C4C.

• Connect to Wave Financial in RazorSQL

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

• Integrate Office 365 into Power Automate Desktop using CData Connect

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

• Easily Integrate Certinia in Lazarus Pascal IDE

  Learn how to easily integrate live Certinia in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Validate Facebook Ads with QuerySurge

  Access and validate Facebook Ads in QuerySurge using the CData JDBC Driver.

• How to use SQLAlchemy ORM to access Microsoft Exchange in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Exchange.

• Connect to Zoom in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Import Outreach.io Using Azure Data Factory

  Use CData Connect Cloud to connect to Outreach.io from Azure Data Factory and import live Outreach.io.

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

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

• Replicate Google Spanner to Multiple Databases via the CData Sync CLI

  Replicate Google Spanner to disparate databases with a single configuration.

• Connect to Zoho Projects from a Connection Pool in WebLogic

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

• Build Automated Workflows with Live FHIR in Workato

  Use CData Connect Cloud to connect to live FHIR and build automated workflows in Workato.

• Build Charts with Email in Clear Analytics

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

• Visualize Live Twitter in the Power BI Service

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

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

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

• Process & Analyze Authorize.Net in Databricks (AWS)

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

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

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

• How to connect PolyBase to Act-On

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

• Connect to Veeva Vault from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Veeva Vault & Vault CRM using standard SQL.

• Analyze TaxJar in R via JDBC

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

• PowerShell Scripting to Replicate Airtable to MySQL

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

• Integrate with live Cloudant in Jitterbit

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

• How to work with Jira Service Management in Apache Spark using SQL

  Access and process Jira Service Management in Apache Spark using the CData Software JDBC Driver.

• Analyze YouTube Analytics in SAP Analytics Cloud

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

• Connect to Kintone from AWS Glue

  Use CData Connect Cloud to gain access to live Kintone from your AWS Glue jobs.

• DataBind Charts to Reckon

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

• Build Visualizations of Live Dynamics GP in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Microsoft Dynamics GP and build custom reports in Power BI.

• Build MVC Applications with Connectivity to Calendly

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Calendly from an ASP.NET MVC application.

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

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

• Work with Live Paylocity in Power Query

  Use CData Connect Cloud to connect to Paylocity and work with live Paylocity in Microsoft Power Query.

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

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

• Visualize Live HBase in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Apache HBase and create custom reports in the Power BI Service.

• DBAmp: Serial Number Expiration Date Shows 1999 or Expired

  Handling an expiration date of 1999 in DBAmp.

• DataBind CouchDB to the DevExpress Data Grid

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

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

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

• Replicate Multiple Salesforce Marketing Accounts

  Replicate multiple Salesforce Marketing accounts to one or many databases.

• Automated Continuous OData Services Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable OData replication to OneLake in Microsoft Fabric.

• Connect to Spark in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Apache Spark SQL in Google Apps Script.

• How to Query Veeva Vault in MySQL Workbench

  Execute MySQL queries against live Veeva Vault & Vault CRM from MySQL Workbench.

• Extract, Transform, and Load Bullhorn CRM in Informatica PowerCenter

  Create a simple Workflow for Bullhorn CRM in Informatica PowerCenter.

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

  Connect to LDAP from a connection pool in Tomcat.

• Add Google Drive to Informatica Enterprise Data Catalog

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

• Automated Continuous Azure DevOps Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Azure DevOps replication to Amazon S3.

• A PostgreSQL Interface for Databricks using the CData ODBC Driver

  Use the SQL Gateway and Databricks ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to Google Spanner from PowerBuilder via JDBC

  This article demonstrates how to access Google Spanner from PowerBuilder using the Google Spanner JDBC Driver.

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

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

• How to import SAS Data Sets into Apache Solr

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

• Visualize Sybase in Tableau

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

• Connect to IBM Cloud Object Storage from a Connection Pool in WebLogic

  Use the CData JDBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage from Web applications running on WebLogic.

• Automated Continuous ConstantContact Replication to Oracle

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

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

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

• Connect to and Query SAP Hybris C4C in QlikView over ODBC

  Create data visualizations with SAP Hybris C4C in QlikView.

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

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

• Automate Azure Active Directory Integration Tasks from PowerShell

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

• Access Epicor Kinetic 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 Epicor Kinetic.

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

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

• Access EventBrite in PHP through Connect Server

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

• Access Live Google Drive in Excel (Desktop) via Connect Cloud

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

• Connect to Microsoft OneDrive in RapidMiner

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

• Connect to Couchbase in Airbyte ELT Pipelines

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

• Connect to IBM Informix from Crystal Reports

  Use CData Connect Cloud to connect to and report on live IBM Informix from Crystal Reports.

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

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

• How to Work with ShipStation in ETL Validator JDBC

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

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

  Use the CData Connector for Google Spanner in APOS Live Data Gateway to build Semantic Layer Views for Google Spanner.

• Visualize LinkedIn in TIBCO Spotfire through OData

  Integrate LinkedIn into dashboards in TIBCO Spotfire.

• Connect to Access in DBArtisan

  Use wizards in DBArtisan to configure Microsoft Access as a data source.

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

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

• Integrate Salesloft in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesloft from Informatica Cloud.

• Feed Kintone into FineReport

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

• Bidirectional Access to Slack from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Slack in Filemaker Pro for Mac or Windows.

• Query eBay in DataGrip

  Create a Data Source for eBay in DataGrip and use SQL to query live eBay.

• Create a Data Access Object for Oracle Financials Cloud using JDBI

  A brief overview of creating a SQL Object API for Oracle Financials Cloud in JDBI.

• Integrating Adobe Analytics in Talend Cloud Data Management Platform

• «
• 102
• 103
• 104
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• »