CData Software - Knowledge Base

Recent Articles

• «
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• »

• Automated Continuous Google Search Replication to Google BigQuery

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

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

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

• Automated Continuous Splunk Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Splunk replication to Google Cloud SQL.

• Connect to Live Cosmos DB in MicroStrategy through CData Connect Cloud

  Create a live connection to Cosmos DB in CData Connect Cloud and connect to your Azure Cosmos DB from MicroStrategy.

• Access Live Twitter Ads in Coginiti Pro

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

• Process & Analyze Epicor Kinetic in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Epicor Kinetic .

• Integrate Impala in Pentaho Data Integration

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

• Visualize Basecamp from Tableau

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

• Create Reports from Smartsheet in Looker Studio

  Use CData Connect Cloud to gain access to live Smartsheet and create custom reports in Looker Studio.

• Build Data Flows from SQL Server to SuiteCRM through SSIS

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

• Visualize Live Splunk in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Splunk.

• Import BigCommerce Using Azure Data Factory

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

• Deploy the ADO.NET Provider for LDAP on an SSRS Report Server

  Connect to LDAP from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Use Dash to Build to Web Apps on Azure Active Directory

  Create Python applications that use pandas and Dash to build Azure Active Directory-connected web apps.

• How to Connect DBeaver to Teradata via a JDBC Driver

  Manage Teradata with visual tools in DBeaver like the query browser.

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

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

• Access Google Contacts from MySQL in HeidiSQL

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

• How to Create Power BI Visual Reports with Real-Time Google Cloud Storage

  Use CData Power BI Connectors to visualize Google Cloud Storage in Power BI.

• Explore Geographical Relationships in YouTube Analytics with Power Map

  Create data visualizations with YouTube Analytics in Power Map.

• Use JayDeBeApi to access Trello in Python

  Use standard Python scripting and the development environment of your choice to access live Trello.

• Automated Continuous Dynamics 365 Business Central Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to IBM DB2.

• Create Tableau CRM Analytics-Connected Applications in Appsmith

  Connect to Tableau CRM Analytics via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Tableau CRM Analytics.

• Analyze ClickUp in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of ClickUp and visualize live ClickUp in Ingragistics Reveal.

• A PostgreSQL Interface for Cassandra (MySQL Remoting via JDBC)

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

• How to Access SAS xpt Using Entity Framework

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

• Automate Amazon DynamoDB Integration Tasks from PowerShell

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

• Load Salesforce Data Cloud to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce Data Cloud to a database.

• Create Apps from Amazon DynamoDB in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Amazon DynamoDB and build apps from live Amazon DynamoDB in Qlik Sense Cloud.

• Automated Continuous Google Sheets Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Google Sheets replication to Apache Kafka.

• Connect to Bullhorn CRM from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Bullhorn CRM to connect to Bullhorn CRM and execute queries in PowerBuilder.

• Create Datasets from Cosmos DB in Domo Workbench and Build Visualizations of Cosmos DB in Domo

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

• Integrate Drip in Pentaho Data Integration

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

• Query Google Ads in ColdFusion

  Write standard ColdFusion data access code to connect to Google Ads.

• Access Live GraphQL in Google Sheets via Connect Cloud

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

• How to load Azure Synapse data into Elasticsearch via Logstash

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

• Edit and Search External Google Ad Manager Objects in Salesforce Connect

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

• How to work with Snapchat Ads in Apache Spark using SQL

  Access and process Snapchat Ads in Apache Spark using the CData Software JDBC Driver.

• Explore Geographical Relationships in ShipStation with Power Map

  Create data visualizations with ShipStation in Power Map.

• Add Oracle Eloqua to Informatica Enterprise Data Catalog

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

• Connect to SQL Analysis Services in Aqua Data Studio

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

• Connect to PayPal as a Linked Server via SQL Gateway

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

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

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

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

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

• Access Greenhouse from MySQL in Amazon QuickSight

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

• Access Twitter Ads from MySQL in PHP

  Connect to Twitter Ads through the standard MySQL libraries in PHP.

• DataBind Controls to Kintone in Delphi

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

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

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

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

  Provide connectivity to Aha! through an SAP BusinessObjects universe.

• Create Adobe Commerce-Connected Dashboards in Grafana

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

• Process & Analyze Trello in Databricks (AWS)

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

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

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

• Visualize Live Raisers Edge NXT of Power BI Report Builder in Power BI Service

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

• Build QuickBooks Online Visualizations in Tableau Desktop

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

• Automated Continuous Twitter Replication to Databricks

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

• Prepare, Blend, and Analyze Azure Active Directory in Alteryx Designer (ODBC)

  Build workflows to access live Azure Active Directory for self-service data analytics.

• Build Zoho Projects-Connected Apps in Mendix

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

• Deploy the ADO.NET Provider for SingleStore on an SSRS Report Server

  Connect to SingleStore from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Query Bullhorn CRM in MySQL Workbench

  Create a virtual MySQL database for Bullhorn CRM in CData Software Connect (or Connect Server) and work with live Bullhorn CRM in MySQL Workbench.

• How to connect to Azure Data Lake Storage from IntelliJ

  Integrate connectivity to Azure Data Lake Storage with wizards in IntelliJ.

• Connect to Office 365 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 Microsoft Office 365.

• Publish Crystal Reports on Elasticsearch

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

• Query SQL Analysis Services in MySQL Workbench

  Create a virtual MySQL database for SQL Analysis Services in CData Software Connect (or Connect Server) and work with live SQL Analysis Services in MySQL Workbench.

• Prepare, Blend, and Analyze ConstantContact in Alteryx Designer (ODBC)

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

• Replicate CData Connect Cloud to Multiple Databases

  Replicate CData Connect Cloud to disparate databases with a point-and-click configuration.

• Automated Continuous Raisers Edge NXT Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Amazon S3.

• Provide OData Services of Freshdesk from a WCF Application

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

• Connect to Azure Synapse as an External Source in Dremio

  Use the CData JDBC Driver to connect to Azure Synapse as an External Source in Dremio.

• Create Power BI XMLA Reports on JasperReports Server

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

• How to publish and share LDAP Objects dashboards with Tableau Server

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

• Enable the FTP JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with FTP Servers.

• 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

• Automated Continuous eBay Analytics Replication to SingleStore

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

• Viewing Klipfolio in RAD Studio Data Explorer

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

• Query Cosmos DB as a SQL Server Database in Node.js

  Execute SQL Server queries against Azure Cosmos DB from Node.js.

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

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

• How to connect to Kintone in DBVisualizer

  Integrate Kintone with visual data analysis tools and data connection wizards in DBVisualizer

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

• How to work with Facebook in Apache Spark using SQL

  Access and process Facebook in Apache Spark using the CData Software JDBC Driver.

• Prepare, Blend, and Analyze Google Spanner in Alteryx Designer (ODBC)

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

• Visualize Monday.com in TIBCO Spotfire through ADO.NET

  Integrate Monday.com into dashboards in TIBCO Spotfire.

• Connect to LinkedIn Ads in DBeaver

  Use the CData ODBC Driver to connect to LinkedIn Ads in DBeaver.

• Access Live Raisers Edge NXT in Excel 365 Online (Excel for the web)

  Connect to Raisers Edge NXT from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Connect to Workday in RunMyProcess through Connect Cloud

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

• Integrate Spark in Pentaho Data Integration

  Build ETL pipelines based on Apache Spark SQL in the Pentaho Data Integration tool.

• Connect to and Visualize Live Oracle SCM in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle SCM.

• Import Dynamics 365 Business Central into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Dynamics 365 Business Central and provide access to live Dynamics 365 Business Central for custom reports in the Power BI Service.

• Access Live Dynamics GP in Coginiti Pro

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

• Connect to Zoho Inventory in CloverDX (formerly CloverETL)

  Transfer Zoho Inventory using the visual workflow in the CloverDX data integration tool.

• Connect to SharePoint from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for SharePoint to connect to Microsoft SharePoint and execute queries in PowerBuilder.

• Automated Continuous Microsoft Exchange Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Microsoft Access.

• Create Exact Online-Connected Visualizations in Klipfolio

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

• Use CData Connect Cloud to Access Google Spanner in Microsoft Power Pivot

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

• Connect to Certinia in Google Apps Script via SQL Gateway

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

• Build AI/ML Models with Live Monday.com Data using Dataiku

• «
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• »