CData Software - Knowledge Base

Recent Articles

• «
• 246
• 247
• 248
• 249
• 250
• 251
• 252
• 253
• 254
• 255
• »

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

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

• How to Query Live HubDB Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live HubDB data in natural language using Python.

• Work with Live GitHub in Power Query

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

• How to Query Live Azure Table Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Azure Table Storage data in natural language using Python.

• How to Seamlessly Import JSON Data into IBM SPSS Modeler

  Integrate JSON data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• How to Visualize SAP HANA XS Advanced Data in Python with pandas

  Use pandas and other modules to analyze and visualize live SAP HANA XS Advanced in Python.

• Connect to Okta in RazorSQL

  Connect to Okta from wizards and query Okta from the GUI in the RazorSQL database management tool.

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

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

• Replicate Multiple Access Accounts

  Replicate multiple Access accounts to one or many databases.

• Migrating data from SAS Data Sets to Databricks using CData SSIS Components.

  Easily push SAS Data Sets to Databricks using the CData SSIS Tasks for SAS Data Sets and Databricks.

• How to connect to Access from Spring Boot

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

• Create Gmail-Connected Visualizations in Klipfolio

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

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

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

• Operational Reporting on JSON Services from Spotfire Server

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

• Access CouchDB as a Remote Oracle Database

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

• How to connect SharePoint with Google Contacts through external lists

  Provide Google Contacts to SharePoint users as an external list.

• Provide OData Services of Sage 300 from a WCF Application

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

• Integrate with BigCommerce in JReport Designer

  Create charts and reports based on BigCommerce in JReport Designer.

• Analyze WordPress in Looker

  Use CData Connect Cloud to connect to WordPress from Looker and build custom apps using live WordPress.

• Automate WordPress Replication to Azure Synapse

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

• Automated Continuous XML Replication to MySQL

  Use CData Sync for automated, continuous, customizable XML replication to MySQL.

• How to integrate LinkedIn Ads with Apache Airflow

  Access and process LinkedIn Ads in Apache Airflow using the CData JDBC Driver.

• Visualize Live Sage 200 in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Sage 200.

• Using the CData Software ODBC Driver for Quickbase in PyCharm

  Connect to Quickbase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Quickbase.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Data Cloud

  Provide connectivity to Salesforce Data Cloud through an SAP BusinessObjects universe.

• Use the CData Software ODBC Driver for Twilio in MicroStrategy Desktop

  Connect to Twilio in MicroStrategy Desktop using the CData Software ODBC Driver for Twilio.

• How to connect to Spark from Spring Boot

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

• Integrate Real-Time Access to Vault CRM in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Veeva Vault & Vault CRM in real time.

• How to use SQLAlchemy ORM to access MailChimp in Python

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

• Natively Connect to Salesforce Marketing in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Marketing Cloud. Leverage the native support for ODBC in PHP.

• Access Live ADP in AWS Lambda (with IntelliJ IDEA)

  Connect to live ADP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Build an OLAP Cube in SSAS from Microsoft Teams

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

• Connect to Instagram from a Connection Pool in WebLogic

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

• DataBind Charts to Stripe

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

• Visualize Oracle in Sisense

  Create an ElastiCube in Sisense app with access to Oracle Database.

• Build MVC Applications with Connectivity to SuiteCRM

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SuiteCRM from an ASP.NET MVC application.

• Build Charts with HarperDB in Clear Analytics

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

• How to Visualize Adobe Commerce Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Adobe Commerce in Python.

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

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

• Automate Typeform Replication to Azure Synapse

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

• Automated Continuous Monday.com Replication to OneLake in Microsoft Fabric

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

• Access Live HCL Domino in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to HCL Domino from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Automated Continuous FHIR Replication to SQL Server

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

• Import Real-Time Sage 50 UK via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Sage 50 UK in ColdFusion.

• Access QuickBooks in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for QuickBooks Desktop.

• Connect to Gmail in RunMyProcess through Connect Cloud

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

• How to Create Power BI Visual Reports with Real-Time Excel Online

  Use CData Power BI Connectors to visualize Microsoft Excel Online in Power BI.

• Back Up SAP Ariba Source to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Ariba Source. In this article, we will employ an SSIS workflow to populate a database with SAP Ariba Source data.

• Rapidly Develop Salesforce Pardot-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Edit and Search External Salesforce Marketing Objects in Salesforce Connect

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

• Automated Continuous Neo4J Replication to Apache Kafka

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

• Connect to Excel from PowerBuilder via ADO.NET

  This article demonstrates how to access Microsoft Excel from Appeon PowerBuilder using the CData ADO.NET Provider for Excel.

• Process & Analyze ActiveCampaign in Databricks (AWS)

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

• How to connect to Azure Synapse in DBVisualizer

  Integrate Azure Synapse with visual data analysis tools and data connection wizards in DBVisualizer

• Build a PostgreSQL Interface for SingleStore using the CData JDBC Driver

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

• How to pipe SAP SuccessFactors to CSV in PowerShell

  Use standard PowerShell cmdlets to access SAP SuccessFactors tables.

• Integrate AlloyDB into Power Automate Desktop using CData Connect

  CData Connect for AlloyDB enables you to integrate Google AlloyDB into workflows built using Microsoft Power Automate Desktop.

• Automated Continuous Salesforce Marketing Replication to MySQL

  Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to MySQL.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Automated Continuous Twilio Replication to Google BigQuery

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

• Connect to Google Spanner in Ruby

  Connect to Google Spanner in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Automated Continuous Salesforce Replication to Apache Cassandra

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

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

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

• Create Data Visualizations in Cognos BI with Google Spanner

  Access Google Spanner as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

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

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

• Manage Epicor Kinetic in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Epicor Kinetic.

• Connect to WordPress in Claris FileMaker Pro

• «
• 246
• 247
• 248
• 249
• 250
• 251
• 252
• 253
• 254
• 255
• »