CData Software - Knowledge Base

Recent Articles

• «
• 427
• 428
• 429
• 430
• 431
• 432
• 433
• 434
• 435
• 436
• »

• Integrate Marketo into Automated Tasks with Power Automate

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

• Automated Continuous Zoho Books Replication to Apache Cassandra

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

• How to publish and share Teradata dashboards with Tableau Server

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

• Access Live Avalara AvaTax in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Avalara AvaTax into the statistical analysis tools available in SAS JMP. This article shows how to use Avalara AvaTax in the Graph Builder and Query Builder.

• Replicate MySQL to Multiple Databases via the CData Sync CLI

  Replicate MySQL to disparate databases with a single configuration.

• Automated Continuous Redis Replication to AlloyDB

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

• DataBind Charts to Pinterest

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

• Automated Continuous AlloyDB Replication to SQL Server

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

• Connect to ShipStation in DBeaver

  Use the CData ODBC Driver to connect to ShipStation in DBeaver.

• Connect to Trello in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Trello in Google Apps Script.

• Connect to Twitter Ads from AWS Glue

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

• Integrate Live Google Ads into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Google Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Ads.

• Use Biml to Build SSIS Tasks to Replicate Excel Online to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Excel Online to SQL Server.

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

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

• Build Semantic Layer Views for Presto in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Presto.

• How to pipe Avro to CSV in PowerShell

  Use standard PowerShell cmdlets to access Avro tables.

• Build an OLAP Cube in SSAS from Monday.com

  Establish a connection to Monday.com data from SQL Server Analysis Services, and use the Monday.com Data Provider to build OLAP cubes for use in analytics and reporting.

• Extend Google Sheets with Todoist

  Make calls to the API Server from Google Apps Script.

• Integrate Zenefits in Your Informatica Cloud Instance

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

• Automated Continuous Blackbaud FE NXT Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to SingleStore.

• Use the CData API Server to Access Zoho CRM in Microsoft PowerPivot

  Use the CData API Server to connect to live Zoho CRM in the Power Pivot business intelligence tool.

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

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

• Create Microsoft Exchange-Connected Visualizations in Klipfolio

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

• How to Connect DBeaver to Google Cloud Storage via a JDBC Driver

  Manage Google Cloud Storage with visual tools in DBeaver like the query browser.

• Automated Continuous Square Replication to OneLake in Microsoft Fabric

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

• Build Apps with Live Apache Hive in Adalo using CData Connect Cloud

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

• Build Semantic Layer Views for Clio in APOS Live Data Gateway

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

• Create Informatica Mappings From/To a JDBC Data Source for Workday

  Create Workday data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Create Dashboards and Visualize Live Greenplum in Geckoboard

  Use CData Connect Cloud to connect to live Pivotal GreenPlum and create dashboards for real-time monitoring and visualization in Geckoboard.

• Connect to MYOB AccountRight in HULFT Integrate

  Connect to MYOB AccountRight as a JDBC data source in HULFT Integrate

• Import Real-Time Azure Analysis Services via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Azure Analysis Services in ColdFusion.

• DataBind Salesforce Marketing to the DevExpress Data Grid

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cloudant

  Provide connectivity to IBM Cloudant through an SAP BusinessObjects universe.

• How to Connect to & Open Raisers Edge NXT in Microsoft Excel

  This article uses the CData ODBC driver for Raisers Edge NXT to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Connect to Azure Analysis Services from HeidiSQL

  Use CData Connect Cloud to connect to and query live Azure Analysis Services from HeidiSQL.

• Seamlessly Bring QuickBooks Online into Retool Using CData Connect Cloud

  Integrate QuickBooks Online data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Connect to Impala as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Apache Impala.

• Build a Simple VCL Application for HBase

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

• How to use SQLAlchemy ORM to access Act-On in Python

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

• Build a Simple VCL Application for Office 365

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

• Automated Continuous Avalara AvaTax Replication to Snowflake

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

• Replicate Multiple SAP HANA Accounts

  Replicate multiple SAP HANA accounts to one or many databases.

• How to Import Data from REST into Google Sheets

  Import REST into a Google spreadsheet that is automatically refreshed.

• Integrate with Act-On using Apache Camel2

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

• Edit and Search External Snapchat Ads Objects in Salesforce Connect

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

• Connect to Google Sheets in RunMyProcess through Connect Cloud

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

• How to import Elasticsearch into Apache Solr

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

• Building Dynamic Web Pages with HBase Using AngularJS

  Create single-page applications with live connectivity to HBase using the CData API Server.

• Automate ADP Integration Tasks from PowerShell

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

• Integrate with live IBM Informix in Jitterbit

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

• DataBind Controls to Act CRM in C++Builder

  DataBind to Act CRM in C++Builder with standard components and controls.

• Use the CData Software JDBC Driver for Exact Online in MicroStrategy

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

• Automated Continuous BambooHR Replication to SingleStore

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

• Prepare, Blend, and Analyze SharePoint Excel Services in Alteryx Designer (ODBC)

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

• Validate SFTP with QuerySurge

  Access and validate SFTP in QuerySurge using the CData JDBC Driver.

• Use the CData API Server to Access SAP ByDesign in Microsoft PowerPivot

  Use the CData API Server to connect to live SAP Business ByDesign in the Power Pivot business intelligence tool.

• Visualize Live Yahoo! Japan Data Solution in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Yahoo! Japan Data Solution into custom reports in Power BI.

• Integrate Redis in the Pentaho Report Designer

  Publish reports based on Redis in the Pentaho BI tool.

• Connect to Acumatica as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Acumatica ERP.

• Build Automated OneNote-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Microsoft OneNote and build automated workflows in Zapier.

• Extend Google Sheets with Tally

  Make calls to the API Server from Google Apps Script.

• Migrating data from DB2 to Databricks using CData SSIS Components.

  Easily push IBM DB2 to Databricks using the CData SSIS Tasks for DB2 and Databricks.

• Visualize Redis from Tableau

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

• How to connect to Odoo from Spring Boot

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

• How to Create Power BI Visual Reports with Real-Time Zoho Creator

  Use CData Power BI Connectors to visualize Zoho Creator in Power BI.

• Build Wave Financial-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Wave Financial.

• Build Oracle HCM Cloud-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Oracle HCM Cloud and create custom apps in Bubble.

• PowerShell Scripting to Replicate CockroachDB to MySQL

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

• Automated Continuous ServiceNow Replication to Microsoft Access

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

• Integrate Real-Time Access to Salesforce Pardot in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Pardot in real time.

• Connect to EventBrite as a Linked Server via SQL Gateway

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

• DataBind Controls to Asana in Delphi

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

• Migrating data from SAP Ariba Procurement to Google BigQuery using CData SSIS Components.

  Easily push SAP Ariba Procurement to Google BigQuery using the CData SSIS Tasks for SAP Ariba Procurement and Google BigQuery.

• Analyze LDAP Objects in Infragistics Reveal

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

• Automated Continuous Printify Replication to SingleStore

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

• Import Real-Time Teradata via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Teradata in ColdFusion.

• Migrating data from Snapchat Ads to Snowflake using CData SSIS Components.

  Easily push Snapchat Ads to Snowflake using the CData SSIS Tasks for Snapchat Ads and Snowflake.

• Build Charts with Paylocity in Clear Analytics

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

• Access Live Azure Data Lake Storage Data in Tableau with CData API Server

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

• PowerShell Scripting to Replicate MarkLogic to MySQL

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

• Build Dashboards with Bing Ads in DBxtra

  Create dynamic dashboards and perform analytics based on Bing Ads in DBxtra.

• Integrate with HBase in JReport Designer

  Create charts and reports based on Apache HBase in JReport Designer.

• Automate CockroachDB Replication to SAP HANA

  Use CData Sync to customize and automate CockroachDB replication to SAP HANA.

• Automate Adobe Analytics Replication to Azure Synapse

  Use CData Sync to customize and automate Adobe Analytics replication to Azure Synapse.

• Visualize Live Redshift in the Power BI Service

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

• Automated Continuous Google Analytics Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Google Analytics replication to IBM DB2.

• How to connect PolyBase to Hive

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Hive.

• Migrating data from Presto to Snowflake using CData SSIS Components.

  Easily push Presto to Snowflake using the CData SSIS Tasks for Presto and Snowflake.

• Create a Data Access Object for SingleStore using JDBI

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

• Build SAP BusinessObjects BI-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP BusinessObjects BI.

• Build SAP Ariba Procurement-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live SAP Ariba Procurement.

• Work with Live Reckon in Power Query

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

• Query ADP through ODBC in Node.js

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

• Edit and Search External SAP Ariba Procurement Objects in Salesforce Connect

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

• Building Dynamic Web Pages with HarperDB Using AngularJS

  Create single-page applications with live connectivity to HarperDB using the CData API Server.

• Create SSAS Tabular Models from Power BI XMLA

  How to build a SQL Server Analysis Service Tabular Model from Power BI XMLA using CData drivers.

• How to connect to Google Search Results from Spring Boot

  Connect to Google Search in a Spring Boot Application using CData JDBC Google Search Driver

• Connect to SAP Ariba Source in HULFT Integrate

  Connect to SAP Ariba Source as a JDBC data source in HULFT Integrate

• Create Apps from Google Calendar in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Google Calendar and build apps from live Google Calendar in Qlik Sense Cloud.

• Create Apps from Sansan in Qlik Sense Cloud

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

• «
• 427
• 428
• 429
• 430
• 431
• 432
• 433
• 434
• 435
• 436
• »