CData Software - Knowledge Base

Recent Articles

• «
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• »

• Build MVC Applications with Connectivity to SAS xpt

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

• Import Real-Time Microsoft Planner in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Microsoft Planner in ColdFusion.

• Analyze AlloyDB in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Google AlloyDB and visualize Google AlloyDB in SAP Analytics Cloud.

• Use CData Connect Cloud to Access Twitter in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Twitter in the Power Pivot business intelligence tool.

• Validate Stripe with QuerySurge

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

• Query, Visualize, and Share live PostgreSQL in Redash

  Use CData Connect Cloud to connect to live PostgreSQL in Redash for querying, visualizing, and sharing.

• Build Airtable-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Airtable from Choreo and build custom apps using live Airtable.

• Visualize Cloudant in Tableau

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

• Automated Continuous Salesforce Replication to Google Cloud SQL

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

• How to publish and share Office 365 dashboards with Tableau Server

  The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.

• Analyze Live MySQL in SAS Viya

  Use CData Connect Cloud to connect to MySQL from SAS Viya and deploy self-service analytics using live MySQL.

• Connect to Google Directory in Jaspersoft Studio

  Execute SQL to remote Google Directory in Jaspersoft Studio.

• Automated Continuous Amazon S3 Replication to Oracle

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

• Perform Batch Operations with Excel in Apache NiFi

  Connect to Microsoft Excel and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Query Twitter Ads in DataGrip

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

• Automated Continuous Shopify Replication to PostgreSQL

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

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

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

• Rapidly Develop Elasticsearch-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.

• How to import ClickUp into Apache Solr

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

• Visualize Live LinkedIn in the Power BI Service

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

• Add Veeva to Informatica Enterprise Data Catalog

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

• Work with MarkLogic in FoxPro

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

• Viewing Oracle in RAD Studio Data Explorer

  How to view Oracle Database in RAD Studio Data Explorer using the CData ODBC Driver for Oracle.

• Using AngularJS to Build Dynamic Web Pages with Act-On

  Use the CData Connect Server to create Act-On OData feeds and build single-page applications with live Act-On.

• Using AngularJS to Build Dynamic Web Pages with Redis

  Use the CData Connect Server to create Redis OData feeds and build single-page applications with live Redis.

• Automated Continuous SAP Hybris C4C Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Apache Kafka.

• Query Jira Service Management in DataGrip

  Create a Data Source for Jira Service Management in DataGrip and use SQL to query live Atlassian Jira Service Management.

• Integrate Live Odoo into Amazon SageMaker Canvas with RDS

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

• Feed Shopify into FineReport

  How to set Shopify as a JDBC data source in FineReport.

• Integrate Twitter Ads in the Pentaho Report Designer

  Publish reports based on Twitter Ads in the Pentaho BI tool.

• Import Real-Time Snapchat Ads in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Snapchat Ads in ColdFusion.

• How to Query Zoho Creator in MySQL Workbench

  Execute MySQL queries against live Zoho Creator from MySQL Workbench.

• Use the CData ODBC Driver for Greenplum in SAS JMP

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

• Stream Workday into Apache Kafka Topics

  Access and stream Workday in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automated Continuous Stripe Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Stripe replication to Amazon S3.

• Automated Continuous Freshdesk Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Freshdesk replication to Amazon Redshift.

• Create Typeform-Connected Nintex Workflows

  Use CData Software Connect Server to connect to Typeform from Nintex Workflow Cloud and build custom workflows using live Typeform.

• Design BIRT Reports on MarkLogic

  Provide current MarkLogic to your embedded analytics.

• How to pipe Zoho Projects to CSV in PowerShell

  Use standard PowerShell cmdlets to access Zoho Projects tables.

• Visualize Live Bullhorn CRM of Power BI Report Builder in Power BI Service

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

• Automate SingleStore Replication to Azure Data Lake

  Use CData Sync to customize and automate SingleStore replication to Azure Data Lake.

• Work with Oracle Sales in FoxPro

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

• Replicate Multiple SendGrid Accounts

  Replicate multiple SendGrid accounts to one or many databases.

• Explore Geographical Relationships in xBase with Power Map

  Create data visualizations with xBase in Power Map.

• How to create an RPA flow for Zendesk in UiPath Studio

  Use the Zendesk ODBC Driver to create workflows that access real-time Zendesk without any coding.

• Work with ClickUp in FoxPro

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

• Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy

  Connect to Zoho Projects in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Projects.

• Build Visualizations of Oracle HCM Cloud in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle HCM Cloud in Birst.

• Replicate Multiple MongoDB Accounts

  Replicate multiple MongoDB accounts to one or many databases.

• DataBind Wijmo Grid to eBay Analytics

  Provide real-time eBay Analytics to interactive controls.

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

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

• Connect to Twitter Ads in CloverDX (formerly CloverETL)

  Transfer Twitter Ads using the visual workflow in the CloverDX data integration tool.

• Connect to MongoDB in DBArtisan

  Use wizards in DBArtisan to configure MongoDB as a data source.

• Replicate Sage 50 UK to Multiple Databases

  Replicate Sage 50 UK to disparate databases with a single configuration.

• Create Data Visualizations in Cognos BI with Sage 300

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

• Build Dashboards with Trello in DBxtra

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

• Use the CData Software ODBC Driver for GraphQL in MicroStrategy Web

  Connect to GraphQL in MicroStrategy Web using the CData Software ODBC Driver for GraphQL.

• Create Apps from MariaDB in Qlik Sense Cloud

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

• How to pipe Hive to CSV in PowerShell

  Use standard PowerShell cmdlets to access Hive tables.

• Access IBM Cloud Data Engine as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access IBM Cloud Data Engine from your Oracle system.

• Explore Geographical Relationships in Splunk with Power Map

  Create data visualizations with Splunk in Power Map.

• How to connect to SuiteCRM from Google Apps Script

  Use CData Software Connect Server to access SuiteCRM in Google Apps Script.

• Build MVC Applications with Connectivity to XML

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

• Configure a Solicit-Response Send Port for the CData BizTalk Adapter for Salesforce

  Use the CData BizTalk Adapter for Salesforce with a solicit-response send port to execute updategrams and data manipulation SQL in BizTalk.

• Create Reports with Splunk in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Splunk.

• DataBind Wijmo Grid to Invoiced

  Provide real-time Invoiced to interactive controls.

• Create Reports with Wave Financial in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Wave Financial.

• Connect to Blackbaud FE NXT in Aqua Data Studio

  Access Blackbaud FE NXT from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• IBM Cloud Data Engine Reporting in OBIEE with the IBM Cloud Data Engine JDBC Driver

  Deploy the IBM Cloud Data Engine JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Build Oracle HCM Cloud-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Oracle HCM Cloud from Choreo and build custom apps using live Oracle HCM Cloud.

• Visualize Twilio in TIBCO Spotfire through OData

  Integrate Twilio into dashboards in TIBCO Spotfire.

• Connect to Zendesk in NetBeans

  Connect to Zendesk in NetBeans with the data source configuration wizard.

• How to create an RPA flow for Office 365 in UiPath Studio

  Use the Office 365 ODBC Driver to create workflows that access real-time Microsoft Office 365 without any coding.

• Connect to Cloudant from Crystal Reports

  Use CData Connect Cloud to connect to and report on live IBM Cloudant from Crystal Reports.

• Validate Zoho Books with QuerySurge

  Access and validate Zoho Books in QuerySurge using the CData JDBC Driver.

• How to pipe Splunk to CSV in PowerShell

  Use standard PowerShell cmdlets to access Splunk tables.

• Connect to OData Services in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for OData in Airbyte.

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

  Provide connectivity to Stripe through an SAP BusinessObjects universe.

• Working with Facebook in LINQPad

  Execute LINQ queries to Facebook in LINQPad.

• Automated Continuous Dynamics 365 Business Central Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to SingleStore.

• Access Oracle from MySQL in Amazon QuickSight

  Connect to Oracle and build visualizations of Oracle Database using a MySQL Connection in Amazon QuickSight.

• Automated Continuous Salesforce Marketing Replication to Databricks

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

• How to connect to ActiveCampaign in DBVisualizer

  Integrate ActiveCampaign with visual data analysis tools and data connection wizards in DBVisualizer

• Use the CData ODBC Driver for Tally from SharePoint Excel Services

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

• Visualize Live Monday.com of Power BI Report Builder in Power BI Service

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

• How to Create Power BI Visual Reports with Real-Time IBM Cloud Object Storage

  Use CData Power BI Connectors to visualize IBM Cloud Object Storage in Power BI.

• Back Up Slack to SQL Server through SSIS

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

• Use CData Connect Cloud to Access ShipStation in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live ShipStation in the Power Pivot business intelligence tool.

• Connect to SharePoint in Aqua Data Studio

  Access Microsoft SharePoint from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

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

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

• Connect to Real-Time Azure Data Catalog Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• »