Traditionally, importing key-value data stores such as Redis into BI, reporting, and ETL tools is problematic, if not impossible. With the CData Drivers, there are several different ways to building a traditional database model to easily work with Redis data in the BI, reporting, ETL, and custom applications of your choice. In this article, we discuss […]
2021-11-12
1,584 reads
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 […]
2021-11-08
866 reads
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 […]
2021-11-05
326 reads
With Google Sheets you can create branded reports with data visualizations to share with your clients. Combined with CData Cloud, Google Sheets give you cloud-to-cloud access to data from the supported SaaS, Big Data and NoSQL sources for visualizations, dashboards, and more. In this article we explain how to use the CData Cloud Add-On to […]
2021-11-01
584 reads
Easily push SQL Server data to Salesforce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce or update existing records with data from a SQL Server database.
2021-10-29
566 reads
With Amazon DocumentDB developers and DBAs can balance availability, read scalability, and latency with five pre-configured consistency levels. The data in an Amazon DocumentDB cluster is accessible just like a MongoDB 3.6 cluster. The CData Software Drivers for MongoDB provide a SQL-like interface to MongoDB data through standards-based drivers. This allows users to see their data in the […]
2021-10-27
446 reads
Big data plays a key role in promoting both manufacturing and scientific development through industrial digitization and emerging research. Integrating big data demands scalable tools for enabling not only big data ingestion and curation but also efficient large-scale exploration and discovery. There is a solution to scale up to large volumes of data distributed across multiple […]
2021-10-22
258 reads
PolyBase is a new feature of SQL Server that allows you to connect to relational and non-relational data. You can run queries on any external data sources you might have, such as Oracle, PostgreSQL, Salesforce, MongoDB, Hadoop, etc. When paired with the CData ODBC Driver for PostgreSQL, you get access to your PostgreSQL data directly […]
2021-10-18
2,389 reads
The SQL Gateway enables you to configure a TDS (SQL Server) remoting service and set up a linked server for SAP HANA data. After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with SAP HANA data just […]
2021-09-29
4,310 reads
If your company uses legacy technology systems, you can use the UiPath RPA platform to extend your process automation capabilities to these systems and eliminate repetitive, error-prone tasks of manually updating them. By using UiPath Studio, you can build an RPA program just like drawing a diagram. With the CData ODBC Driver for Oracle, users can embed Oracle data in the workflow. Let’s […]
2021-09-24
1,412 reads
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
I have a table which is being written to by another application. A few...
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Comments posted to this topic are about the item Getting ANY of the data
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers