CData Software - Knowledge Base

Recent Articles

• «
• 319
• 320
• 321
• 322
• 323
• 324
• 325
• 326
• 327
• 328
• »

• Perform Batch Operations with Bing Ads in Apache NiFi

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

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

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

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

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

• Enable the Zoho Creator JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Zoho Creator.

• DataBind Controls to Jira Assets in Delphi

  DataBind to Jira Assets in Delphi with standard data access components and controls.

• How to Access Live Facebook Ads in Power Automate Desktop via ODBC

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

• Automated Blackbaud FE NXT Replication to Teradata

  Use CData Sync to Customize and automate Blackbaud FE NXT replication to Teradata.

• How to use SQLAlchemy ORM to access Dropbox in Python

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

• How to create Visio diagrams from Dynamics 365

  Automatically update Microsoft Dynamics 365 with the changes you make to Visio master shapes.

• Connect to Microsoft Project from HeidiSQL

  Use CData Connect Cloud to connect to and query live Microsoft Project from HeidiSQL.

• DataBind Wijmo Grid to BambooHR

  Provide real-time BambooHR to interactive controls.

• How to Query TaxJar in MySQL Workbench

  Execute MySQL queries against live TaxJar from MySQL Workbench.

• Add Couchbase to Informatica Enterprise Data Catalog

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

• Automated Continuous Drip Replication to Local Delimited Files

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

• How to connect PolyBase to SAP Ariba Source

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

• Connect to Databricks from AWS Glue

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

• Integrate API into Automated Tasks with Power Automate

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

• DataBind Wijmo Grid to Coinbase

  Provide real-time Coinbase to interactive controls.

• A PostgreSQL Interface for Authorize.Net

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

• Creating Active Directory-Connected Applications in Unqork

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

• Stream FTP into Apache Kafka Topics

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

• Connect to Cosmos DB from Asprova with CData Software ODBC Driver for Cosmos DB

  This article shows how to connect faster to Cosmos DB data from Asprova.

• How to create Visio diagrams from Workday

  Automatically update Workday with the changes you make to Visio master shapes.

• Connect to Drift in RapidMiner

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

• Import Real-Time Redshift in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Amazon Redshift in ColdFusion.

• Connect to Sage 300 in Ruby

  Connect to Sage 300 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Work with Google Campaign Manager 360 in FoxPro

  Load Google Campaign Manager 360 into a FoxPro database. This article includes full code and a walk-through of the process.

• Object-Relational Mapping (ORM) with BigQuery 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 Google BigQuery into a Java-based ORM framework, Hibernate.

• Build MVC Applications with Connectivity to Confluence

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

• Design BIRT Reports on Greenplum

  Provide current Pivotal GreenPlum to your embedded analytics.

• Access Live Oracle HCM Cloud in Google Sheets

  Use CData Connect Cloud to gain access to live Oracle HCM Cloud from your Google Sheets.

• Visualize Jira Assets in TIBCO Spotfire through ADO.NET

  Integrate Jira Assets into dashboards in TIBCO Spotfire.

• Prepare, Blend, and Analyze SharePoint in Alteryx Designer

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

• How to create EventBrite federated tables in MySQL

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

• Import Azure DevOps into the Power BI Service for Visualizations

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

• Create Datasets from SAP HANA XS Advanced in Domo Workbench and Build Visualizations of SAP HANA XS Advanced in Domo

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

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

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

• Connect to Amazon DynamoDB from a Connection Pool in WebLogic

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

• Analyze Azure Active Directory in Cognos Analytics

  Use CData Connect Cloud to connect to Azure Active Directory from Cognos Analytics and analyze live Azure Active Directory.

• Publish SAS Data Sets-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAS Data Sets.

• Build Twitter Visualizations in Tableau Cloud

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

• ServiceNow Reporting and Star Schemas in OBIEE

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

• How to Import Avalara AvaTax into SQL Server using SSIS

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

• Connect to IBM Cloud Data Engine in RazorSQL

  Connect to IBM Cloud Data Engine from wizards and query IBM Cloud Data Engine from the GUI in the RazorSQL database management tool.

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

  Create an ODBC connection to SAP in Informatica and browse and transfer SAP ERP/NetWeaver.

• How to connect to SAP from Spring Boot

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

• Automated Continuous Paylocity Replication to MySQL

  Use CData Sync for automated, continuous, customizable Paylocity replication to MySQL.

• How to use SQLAlchemy ORM to access Printful in Python

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

• How to Import Clio into SQL Server using SSIS

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

• Analyze SAP HANA in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of SAP HANA and visualize live SAP HANA in Infragistics Reveal.

• Load Sybase IQ to a Database Using Embulk

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

• Using the CData Software ODBC Driver for Printify in PyCharm

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

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

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

• How to use SQLAlchemy ORM to access Salesloft in Python

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

• Analyze Oracle Eloqua in Looker

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

• Viewing Slack in RAD Studio Data Explorer

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

• How to Build Dynamic React Apps with Amazon S3

  Use the CData Connect and React to Build Dynamic Web Apps with Live Amazon S3 .

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

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

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

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

• Replicate FHIR to Multiple Databases

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

• Build Apps with Live MongoDB in Adalo using CData Connect Cloud

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

• Connect to Microsoft OneDrive in Aqua Data Studio

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

• Access xBase from MySQL in HeidiSQL

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

• Analyze Splunk in Looker

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

• Edit and Search External Acumatica Objects in Salesforce Connect

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

• Build a Simple VCL Application for Todoist

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

• Create Data Visualizations Based On Oracle Sales in Mode

  Use CData Connect Cloud to connect to Oracle Sales from Mode and build visualizations using live

• Query Impala in DataGrip

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

• Automated Continuous HubSpot Replication to SQL Server

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

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

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

• Create Reports with SAP SuccessFactors in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors.

• Build Azure Synapse-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Azure Synapse and create custom apps in Mendix.

• How to pipe Sage 50 UK to CSV in PowerShell

  Use standard PowerShell cmdlets to access Sage 50 UK tables.

• Build Slack-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Slack.

• Automated Continuous Stripe Replication to SQL Server

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

• A PostgreSQL Interface for Tableau CRM Analytics

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

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

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

• Build Dashboards with Tally in Dundas BI

  Create dynamic dashboards and perform analytics based on Tally ERP in Dundas BI.

• Import NetSuite into the Power BI Service for Visualizations

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

• Analyze Google Calendar in R

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

• Automated Continuous Twilio Replication to Local Delimited Files

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

• Visualize Zuora in Sisense

  Create an ElastiCube in Sisense app with access to Zuora.

• Access EnterpriseDB in PHP through Connect Server

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

• Visualize Azure Synapse in TIBCO Spotfire through OData

  Integrate Azure Synapse into dashboards in TIBCO Spotfire.

• Analyze ServiceNow in Looker

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

• Analyze Google Directory in Cognos Analytics

  Use CData Connect Cloud to connect to Google Directory from Cognos Analytics and analyze live Google Directory.

• Connect to SingleStore as a Linked Server

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

• Use the CData Software ODBC Driver for Zoho CRM in MicroStrategy Web

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

• Build Dashboards with Bitbucket in Dundas BI

  Create dynamic dashboards and perform analytics based on Bitbucket in Dundas BI.

• How to connect to Cosmos DB with Squirrel SQL client

  Connect to Azure Cosmos DB and execute queries in the Squirrel SQL Client.

• Connect to Workday in RapidMiner

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

• How to connect PolyBase to Azure Active Directory

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

• LINQ to SAS Data Sets

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SAS Data Sets Data Provider.

• Visualize Pinterest from Tableau

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

• Create SSAS Tabular Models from XML

  How to build a SQL Server Analysis Service Tabular Model from XML Files using CData drivers.

• Automated Continuous Google Calendar Replication to AlloyDB

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

• Publish Reports with Phoenix in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Apache Phoenix.

• Provide OData Services of Zoho Projects from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Zoho Projects by developing a WCF Service Application.

• Automated Continuous SAP Concur Replication to Databricks

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

• Access Live Raisers Edge NXT in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Raisers Edge NXT from your Excel spreadsheets.

• «
• 319
• 320
• 321
• 322
• 323
• 324
• 325
• 326
• 327
• 328
• »