CData Software - Knowledge Base

Recent Articles

• «
• 274
• 275
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• »

• Create Informatica Mappings From/To an ODBC Data Source for Sage Cloud Accounting

  Create an ODBC connection to Sage Cloud Accounting in Informatica and browse and transfer Sage Business Cloud Accounting.

• Update Required: HubSpot Connectivity

  HubSpot is modifying the contacts scope of their API and CData has updated the OAuth implentation for their HubSpot connectivity solutions to accommodate.

• ETL Sage Intacct in Oracle Data Integrator

  This article shows how to transfer Sage Intacct into a data warehouse using Oracle Data Integrator.

• Connect to Procore in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Marketo in HULFT Integrate

  Connect to Marketo as a JDBC data source in HULFT Integrate

• Create a Data Access Object for Avalara AvaTax using JDBI

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

• Automated NetSuite Replication to Teradata

  Use CData Sync to Customize and automate NetSuite CRM & ERP replication to Teradata.

• Create Square-Connected Visualizations in Klipfolio

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

• How to Import Data from Twitter into Google Sheets

  Import Twitter into a Google spreadsheet that is automatically refreshed.

• Create Dynamic Sage 300 Grids Using the Infragistics XamDataGrid

  Learn how you can connect Sage 300 to Infragistics XamDataGrid to build dynamic grids.

• Access Live NetSuite in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for NetSuite to create a NetSuite CRM & ERP source in TIBCO Data Virtualization Studio and gain access to live NetSuite CRM & ERP from your TDV Server.

• Automated Continuous Impala Replication to SQL Server

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

• Connect to Printify in Google Apps Script via SQL Gateway

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

• How to connect to QuickBooks Online in DBVisualizer

  Integrate QuickBooks Online with visual data analysis tools and data connection wizards in DBVisualizer

• How to use SQLAlchemy ORM to access Excel in Python

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

• How to Connect DBeaver to Dynamics 365 Business Central via a JDBC Driver

  Manage Dynamics 365 Business Central with visual tools in DBeaver like the query browser.

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

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

• Visualize Neo4J in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Neo4J into TIBCO Spotfire.

• Use the CData ODBC Driver for Snapchat Ads from SharePoint Excel Services

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

• Import and Visualize Greenplum in Power View

  Create data visualizations based on Pivotal GreenPlum in Excel.

• Automate TaxJar Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live TaxJar and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• How to Connect to Snapchat Ads in Using Python: 6 Steps

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

• Use the CData Software ODBC Driver for Salesloft in SAS for Real-Time Reporting and Analytics

  Connect to real-time Salesloft in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesloft.

• How to import Cloudant into Apache Solr

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

• Connect to MariaDB in JRuby

  Create a simple JRuby app with access to live MariaDB.

• Connect to Oracle Financials Cloud as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Financials Cloud.

• Trigger Adobe Commerce IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Add Smartsheet to Informatica Enterprise Data Catalog

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

• Validate HBase with QuerySurge

  Access and validate Apache HBase in QuerySurge using the CData JDBC Driver.

• Connect to ConstantContact in Jaspersoft Studio

  Execute SQL to remote ConstantContact in Jaspersoft Studio.

• Connect to SAP Concur from a Connection Pool in JBoss

  Integrate SAP Concur into Java servlets: Use the Management Console in JBoss to install the SAP Concur JDBC Driver.

• How to connect to JotForm with Squirrel SQL client

  Connect to JotForm and execute queries in the Squirrel SQL Client.

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

  Use CData ODBC drivers to import and use IBM Cloudant in ColdFusion.

• LINQ to SQL Analysis Services

  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 SQL Analysis Services Data Provider.

• Automated Continuous Twilio Replication to Google Cloud SQL

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

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

  Connect to Gmail from a connection pool in Tomcat.

• View Reports on Real-Time SAS Data Sets in Power BI Report Server

  Use the CData ODBC Driver for SAS Data Sets to visualize SAS Data Sets in Power BI Desktop and then publish them to Power BI Report Server.

• Connect to MongoDB in Jaspersoft Studio

  Execute SQL to remote MongoDB in Jaspersoft Studio.

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

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

• Connect to Zoho Books from HeidiSQL

  Use CData Connect Cloud to connect to and query live Zoho Books from HeidiSQL.

• Build Asana-Connected Apps in Bubble

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

• Working with Vault CRM in LINQPad

  Execute LINQ queries to Veeva Vault & Vault CRM in LINQPad.

• Automate Oracle Eloqua Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Oracle Eloqua and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Connect to PostgreSQL from a Connection Pool in WebLogic

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

• Build Dashboards with Presto in DBxtra

  Create dynamic dashboards and perform analytics based on Presto in DBxtra.

• Access Live RSS Data in Tableau with CData API Server

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

• Access Parquet as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Parquet from your Oracle system.

• Provide OData Services of Adobe Target from a WCF Application

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

• Working with Impala in LINQPad

  Execute LINQ queries to Apache Impala in LINQPad.

• Automated JSON Services Replication to Teradata

  Use CData Sync to Customize and automate JSON replication to Teradata.

• Connect JSON to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live JSON using the CData Python MCP Server.

• Automate Adobe Commerce Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Adobe Commerce and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Consume Salesforce Pardot OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Salesforce Pardot feeds that reflect any changes in SAP Lumira.

• Connect to Databricks in RapidMiner

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

• Visualize Sage 300 in TIBCO Spotfire through ADO.NET

  Integrate Sage 300 into dashboards in TIBCO Spotfire.

• Connect to BambooHR from PowerBuilder via JDBC

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

• Connect to SAP BusinessObjects BI in RazorSQL

  Connect to SAP BusinessObjects BI from wizards and query SAP BusinessObjects BI from the GUI in the RazorSQL database management tool.

• How to Connect to & Open Marketo in Microsoft Excel

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

• Automated Continuous Salesforce Pardot Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to PostgreSQL.

• Publish Google Calendar-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Google Calendar.

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

  Connect to CockroachDB 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.

• Build Pipelines with Live Asana in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Asana from Google Cloud Data Fusion, enabling the integration of live Asana into the building and management of effective data pipelines.

• How to connect and process Teradata from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Teradata.

• Access Live Zoho Books in Coginiti Pro

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

• Viewing Access in RAD Studio Data Explorer

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

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

  Use CData JDBC drivers to import and use SAS XPORT in ColdFusion.

• Build AI/ML Models with Live Oracle Eloqua Data using Dataiku

• «
• 274
• 275
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• »