CData Software - Knowledge Base
Recent Articles
-
Use Biml to Build SSIS Tasks to Replicate Reckon Accounts Hosted to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Reckon Accounts Hosted to SQL Server.
-
Migrating data from Active Directory to Snowflake using CData SSIS Components.
Easily push Active Directory to Snowflake using the CData SSIS Tasks for Active Directory and Snowflake.
-
How to Access Outreach.io Using Entity Framework
This article shows how to access Outreach.io using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Model Act CRM Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Act CRM, enabling the direct import of real-time Act CRM.
-
Create Reports with Zoho CRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho CRM.
-
How to pipe BigQuery to CSV in PowerShell
Use standard PowerShell cmdlets to access BigQuery tables.
-
Access SAP from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP ERP/NetWeaver from HeidiSQL.
-
Automate Stripe Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Stripe and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build SAP Concur-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Concur and create custom apps in Mendix.
-
Visualize PostgreSQL in Tableau
The CData ODBC driver for PostgreSQL enables you integrate PostgreSQL into Tableau dashboards.
-
Build Automated Workflows with Live BigCommerce in Workato
Use CData Connect AI to connect to live BigCommerce and build automated workflows in Workato.
-
Establish a Live Connection with Snapchat Ads using Tableau Bridge
The CData ODBC Driver for Snapchat Ads enables you to integrate live Snapchat Ads into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live IBM Informix in Excel 365 Online (Excel for the web)
Connect to IBM Informix from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Dynamic JotForm Grids Using the Infragistics XamDataGrid
Learn how you can connect JotForm to Infragistics XamDataGrid to build dynamic grids.
-
Use Biml to Build SSIS Tasks to Replicate eBay to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate eBay to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Parquet
Provide connectivity to Apache Parquet through an SAP BusinessObjects universe.
-
SAP: How to Install a Custom Read Table RFC Function Module
In this entry, you will find the steps how to install the Z_CUSTOM_READ_TABLE function module
-
Integrate GitHub into Automated Tasks with Power Automate
Use CData Connect AI to connect to GitHub and integrate live GitHub into your Power Automate tasks.
-
Connect and Visualize Live Blackbaud FE NXT Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Blackbaud FE NXT into the Databricks platform and create visualization dashboards with real-time Blackbaud FE NXT.
-
Visualize Live Power BI XMLA in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Power BI XMLA into custom reports in Power BI.
-
Connecting Agentforce with Exact Online via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Exact Online for you.
-
Getting Started with the CData Python Connector for PayPal
Learn to install and license the CData Python Connector
-
Creating BigCommerce-Connected Applications in Unqork
You can use CData Connect AI to feed BigCommerce to Unqork and build custom business apps.
-
How to connect PolyBase to Google Campaign Manager 360
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Campaign Manager 360.
-
A PostgreSQL Interface for Trello using the CData ODBC Driver
Use the SQL Gateway and Trello ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Drift with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Drift with External Services.
-
Connect to Google Analytics in Google Apps Script via Connect AI
Use CData Connect AI to access Google Analytics in Google Apps Script.
-
Build Stripe-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Stripe.
-
How to Create Power BI Visual Reports with Real-Time SAP ByDesign
Use CData Power BI Connectors to visualize SAP Business ByDesign in Power BI.
-
Write a Simple Go Application to work with Office 365 on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Office 365.
-
Integrate with Google Sheets in JReport Designer
Create charts and reports based on Google Sheets in JReport Designer.
-
Connect to Unbounce in CloverDX (formerly CloverETL)
Transfer Unbounce using the visual workflow in the CloverDX data integration tool.
-
Integrate with Unbounce using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Unbounce to a JSON file on disk.
-
Publish Reports with Adobe Target in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Target.
-
Build an OLAP Cube in SSAS from Facebook
Establish a connection to Facebook data from SQL Server Analysis Services, and use the Facebook Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Data Visualizations in Cognos BI with DB2
Access IBM DB2 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to HarperDB from a Connection Pool in JBoss
Integrate HarperDB into Java servlets: Use the Management Console in JBoss to install the HarperDB JDBC Driver.
-
Integrate Office 365 in Pentaho Data Integration
Build ETL pipelines based on Microsoft Office 365 in the Pentaho Data Integration tool.
-
Use Dash to Build to Web Apps on CockroachDB
Create Python applications that use pandas and Dash to build CockroachDB-connected web apps.
-
Build AlloyDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google AlloyDB.
-
How to Query Live FTP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live FTP Servers data in natural language using Python.
-
How to import Adobe Experience Manager into Apache Solr
Use the CData Software JDBC Driver for Adobe Experience Manager in Data Import Handler and create an automated import of Adobe Experience Manager to Apache Solr Enterprise Search platform.
-
Visualize Zuora in TIBCO Spotfire through ADO.NET
Integrate Zuora into dashboards in TIBCO Spotfire.
-
Automated Continuous Google Calendar Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Calendar replication to Google BigQuery.
-
Use Dash to Build to Web Apps on Avro
Create Python applications that use pandas and Dash to build Avro-connected web apps.
-
Analyze Google Calendar in Looker
Use CData Connect AI to connect to Google Calendar from Looker and build custom apps using live Google Calendar.
-
Query ADP through ODBC in Node.js
Use node-odbc to execute SQL queries against ADP from Node.js.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed FHIR to Power BI dashboards. Simply drag and drop FHIR into data visuals on the Power BI canvas.
-
Connect to FTP from a Connection Pool in JBoss
Integrate FTP Servers into Java servlets: Use the Management Console in JBoss to install the FTP JDBC Driver.
-
Enable the EnterpriseDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with EnterpriseDB.
-
Automated Continuous Square Replication to SQLite
Use CData Sync for automated, continuous, customizable Square replication to SQLite.
-
Replicate Multiple IBM Cloud Object Storage Accounts
Replicate multiple IBM Cloud Object Storage accounts to one or many databases.
-
Automated Continuous SQL Server Replication to MySQL
Use CData Sync for automated, continuous, customizable SQL Server replication to MySQL.
-
Connect to Live Instagram in PostGresSQL Interface through CData Connect AI
Create a live connection to Instagram in CData Connect AI and connect to your Instagram from PostgreSQL.
-
Query Oracle SCM through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle SCM from Node.js.
-
Seamlessly Bring ServiceNow into Retool Using CData Connect AI
Integrate ServiceNow data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to GraphQL as an External Source in Dremio
Use the CData JDBC Driver to connect to GraphQL as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for GitHub
Provide connectivity to GitHub through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Instagram
Use the CData ODBC Driver for Instagram to visualize Instagram in Power BI Desktop.
-
Extract, Transform, and Load Highrise in Informatica PowerCenter
Create a simple Workflow for Highrise CRM in Informatica PowerCenter.
-
Connect to Google Cloud Storage in RapidMiner
Integrate Google Cloud Storage with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Shopify in CloverDX (formerly CloverETL)
Transfer Shopify using the visual workflow in the CloverDX data integration tool.
-
Build a PostgreSQL Interface for Presto using the CData JDBC Driver
Use the Remoting features of the Presto JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Oracle Financials Cloud Using Azure Data Factory
Use CData Connect AI to connect to Oracle Financials Cloud from Azure Data Factory and import live Oracle Financials Cloud.
-
Connect to Shopify in DBArtisan
Use wizards in DBArtisan to configure Shopify as a data source.
-
Use the CData Software JDBC Driver for Redis in MicroStrategy
Connect to Redis in MicroStrategy Developer using the CData Software JDBC Driver for Redis.
-
How to Work with Typeform in ETL Validator JDBC
Connect to Typeform from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Google Contacts in Google Apps Script via Connect AI
Use CData Connect AI to access Google Contacts in Google Apps Script.
-
Use Azure AI Foundry to Talk to Your Square via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Square for you.
-
Automated Continuous Workday Replication to SQLite
Use CData Sync for automated, continuous, customizable Workday replication to SQLite.
-
Access Trello from MySQL in Amazon QuickSight
Connect to Trello and build visualizations of Trello using a MySQL Connection in Amazon QuickSight.
-
Publish Crystal Reports on Google Ad Manager
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Ad Manager.
-
Integrating Slack in Talend Cloud Data Management Platform
-