connectivity

SQLServerCentral Article

Analyze Live Salesforce Data in Infragistics Reveal 

  • Article

Infragistics Reveal is a data visualization solution that simplifies the way you add embedded analytics and visualizations to your apps. Reveal supports connecting to OData APIs, but many enterprise APIs are not built using the OData standard. By combining Reveal with CData solutions, you can instantly build dynamic dashboards from live enterprise data sources like Salesforce. […]

You rated this post out of 5. Change rating

2022-01-07

363 reads

SQLServerCentral Article

Run Queries Across Many Data Sources at Once with the CData Query Federation Driver

  • Article

The CData Query Federation Driver, allows you to federate and aggregate data across drivers as a single database connection. You can combine the Query Federation Driver with other CData JDBC Drivers or CData ADO.NET Providers to access all your SaaS, Big Data, and NoSQL sources as if they were one database. You can query or update data from a single […]

You rated this post out of 5. Change rating

2021-12-31

685 reads

SQLServerCentral Article

CData Connect: Derived Views and Query Federation

  • Article

Enterprise-scale data integration demands scalable tools to not only centralize and curate data at scale, but also efficiently explore and analyze data at large-scale. CData Connect solves the challenge of data exploration and discovery through virtualized connectivity to data distributed across many data sources. In this article, we explore the Derived Views and Query Federation features […]

You rated this post out of 5. Change rating

2021-12-24

491 reads

SQLServerCentral Article

Editing API Driver API Profiles

  • Article

RESTful APIs offer a straightforward way for businesses to work with external data and offer access to their own data. With more than 24,000 public APIs providing access to limitless data and the typical enterprise leveraging more than 200 applications, teams and developers need more efficient ways to query API data. With the CData API […]

5 (1)

You rated this post out of 5. Change rating

2021-12-17

630 reads

SQLServerCentral Article

Creating API Driver API Profiles

  • Article

RESTful APIs offer a straightforward way for businesses to work with external data and offer access to their own data. With more than 24,000 public APIs providing access to limitless data and the typical enterprise leveraging more than 200 applications, teams and developers need more efficient ways to query API data. With the CData API […]

You rated this post out of 5. Change rating

2021-12-10

930 reads

SQLServerCentral Article

Access All Your Data in Google Data Studio with CData Connect Cloud 

  • Article

Google Data Studio helps you create comprehensive reports and data visualizations. When combined with CData Connect Cloud, you get instant, cloud-to-cloud access to data from supported SaaS, Big Data and NoSQL sources for visualizations, dashboards, and more. CData Connect Cloud provides a live cloud-to-cloud interface for all your data, making it easy to build reports from […]

You rated this post out of 5. Change rating

2021-12-06

452 reads

SQLServerCentral Article

CData AWS Glue Connector for Salesforce Deployment Guide

  • Article

AWS Glue is an ETL service from Amazon that enables you to prepare and load your data for storage and analytics. With Glue Studio, you can create no-code and low-code ETL jobs that work with data through CData Glue Connectors. In this article, we walk through configuring the CData Glue Connector for Salesforce to create and […]

You rated this post out of 5. Change rating

2021-11-26

572 reads

SQLServerCentral Article

A Comparison of Database Drivers for MySQL

  • Article

MySQL is "The world's most popular open source database" and it is widely-used to store and access your data. In fact, there are many cloud and on-premise databases (like MemSQL and Google Cloud SQL) that use the MySQL interface. Several native, open-source drivers are available for connecting to your MySQL data from other applications. In […]

5 (2)

You rated this post out of 5. Change rating

2021-11-22

945 reads

SQLServerCentral Article

Perform API Operations Using Stored Procedures in CData SSIS Components

  • Article

APIs require up-to-date and strong documentation, increased security levels, comprehensive testing, routine versioning, and high-reliability to be appropriately utilized. With the CData SSIS Data Flow components you can import and export data from various data sources. However, in some cases the type of operation you need does not fit the SSIS Source or the SSIS Destination model. The […]

You rated this post out of 5. Change rating

2021-11-08

865 reads

SQLServerCentral Article

CData AWS Glue Connector for Salesforce Deployment Guide

  • Article

AWS Glue is an ETL service from Amazon that enables you to prepare and load your data for storage and analytics. With Glue Studio, you can create no-code and low-code ETL jobs that work with data through CData Glue Connectors. In this article, we walk through configuring the CData Glue Connector for Salesforce and creating and […]

You rated this post out of 5. Change rating

2021-11-05

320 reads

Blogs

Monday Monitor Tips: Knowing Your RPO

By

A customer was asking recently about the RPO for their estate, and I showed...

Webinar tomorrow: The Role of Databases in the Era of AI

By

I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about...

Spark Connect Dotnet Variant Data Type

By

All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...

Read the latest Blogs

Forums

Table Partitioning SQL server 2022

By Saran

Hi All, I am currently testing the Table Partitioning to implement in SQL server...

STRING_AGG's behavior

By Alessandro Mortola

Comments posted to this topic are about the item STRING_AGG's behavior

The Role of Databases in the Era of AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Role of Databases in...

Visit the forum

Question of the Day

STRING_AGG's behavior

Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id     INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
  gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GO
What happens if you execute the following statements?
  1. select STRING_AGG(field1, ';') within group (order by id)  from t0;
  2. select STRING_AGG(field2, ';') within group (order by id)  from t0;

See possible answers