CData Software - Knowledge Base

Recent Articles

• «
• 350
• 351
• 352
• 353
• 354
• 355
• 356
• 357
• 358
• 359
• »

• Access Act CRM from MySQL in Amazon QuickSight

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

• Create Reports from Azure Data Lake Storage in Looker Studio

  Use CData Connect Cloud to gain access to live Azure Data Lake Storage and create custom reports in Looker Studio.

• Automated Continuous HubSpot Replication to SQLite

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

• Connect to IBM Cloud Object Storage in Google Apps Script via SQL Gateway

  Use the ODBC Driver for IBM Cloud Object Storage and the SQL Gateway to access IBM Cloud Object Storage from Google Apps Script.

• How to connect Amazon QuickSight to Databricks

  Create a connection to Databricks in CData Connect Cloud and insert Databricks into Amazon QuickSight SPICE to build interactive dashboards.

• Query LinkedIn Ads in DataGrip

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

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

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

• Visualize Live MySQL in Tableau

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

• Integrate with Live Presto in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Presto from the MuleSoft Anypoint Platform to integrate live Presto into custom reports and dashboards.

• Enable the MongoDB JDBC Driver in KNIME

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

• Automated Continuous Exact Online Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Exact Online replication to Snowflake.

• Connect to Cassandra through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Cassandra using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Connect to TaxJar from PowerBuilder via ODBC

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

• Automated Continuous SAP Ariba Procurement Replication to SQL Server

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to SQL Server.

• Automate Vertica Replication to Azure Synapse

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

• Connect to Salesforce Pardot from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce Pardot using standard SQL.

• Connect to Couchbase from Excel & GoogleSheets!

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

• Connect to Jira Service Management as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Atlassian Jira Service Management.

• Build SingleStore Visualizations in Tableau Cloud

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

• Connect to TaxJar from a Connection Pool in WebLogic

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

• DataBind Controls to Neo4J in Delphi

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

• How to Connect the Power BI Service to Box: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Create a Data Access Object for PayPal using JDBI

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

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

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

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

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

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

  Create an ODBC connection to Typeform in Informatica and browse and transfer Typeform.

• Use the CData Software JDBC Driver for Sage 300 in MicroStrategy

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

• Build Zoho CRM-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Zoho CRM and build web apps with connectivity to live Zoho CRM.

• Operational Reporting on PostgreSQL from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote PostgreSQL.

• Work with Klaviyo in FoxPro

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

• Automated Continuous Phoenix Replication to Oracle

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

• Connect to Adobe Commerce from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Commerce using standard SQL.

• How to Access Cloudant Using Entity Framework

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

• Automated Continuous SAP Concur Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable SAP Concur replication to Azure SQL Database.

• Import Real-Time Google Spanner via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Google Spanner in ColdFusion.

• Excel Spreadsheet Automation on Facebook with the QUERY Formula

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

• Use JayDeBeApi to access Reckon Accounts Hosted in Python

  Use standard Python scripting and the development environment of your choice to access live Reckon Accounts Hosted.

• Connect to Oracle Financials Cloud in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Oracle Financials Cloud in Google Apps Script.

• Work with Live Power BI XMLA in Power Query

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

• Extract, Transform, and Load YouTube Analytics in Informatica PowerCenter

  Create a simple Workflow for YouTube Analytics in Informatica PowerCenter.

• Automated Continuous Tableau CRM Analytics Replication to IBM DB2

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

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

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

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

  Create an ODBC connection to Klaviyo in Informatica and browse and transfer Klaviyo.

• Build Amazon S3-Connected Visualizations in datapine

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

• How to work with Google Sheets in Apache Spark using SQL

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

• Migrating data from Microsoft Planner to Databricks using CData SSIS Components.

  Easily push Microsoft Planner to Databricks using the CData SSIS Tasks for Microsoft Planner and Databricks.

• A PostgreSQL Interface for Zoho CRM (MySQL Remoting via JDBC)

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

• Connect to Access in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to Work with Teradata in AWS Glue Jobs Using JDBC

  Connect to Teradata from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Publish Procore-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Procore.

• Build PostgreSQL-Connected ETL Processes in Google Data Fusion

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

• Connect to Shippo from a Connection Pool in Jetty

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

• Integrate with JSON Services in JReport Designer

  Create charts and reports based on JSON in JReport Designer.

• DataBind Charts to Jira Assets

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

• How to connect PolyBase to SAP Netweaver Gateway

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

• Automated Continuous PayPal Replication to Snowflake

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

• How to Easily Query Unbounce in OpenOffice Base

• «
• 350
• 351
• 352
• 353
• 354
• 355
• 356
• 357
• 358
• 359
• »