Amazon Redshift V2 Connector for Microsoft Data Factory

-

Microsoft is updating our Amazon Redshift connector to use the new Amazon Redshift ODBC 2.x driver.

What’s new and why upgrade

Microsoft and Amazon Redshift have been collaborating to provide our shared customers with an industry-leading, improved security, connectivity experience. The new driver will ensure compatibility, stability, security, and support for your data connectivity. This improvement aligns with Microsoft’s continued commitment to enhancing and providing secure data connectivity solutions for customers, enabling the mitigation of data connectivity threats.

To support this initiative, existing connectors within Data Factory are transitioning to the Amazon Redshift ODBC 2.x driver for all Redshift connectors; the new connector is rolling out automatically across regions.

This improvement will benefit connectivity between Redshift and various Microsoft products, ranging from Fabric Copyjob, Fabric Copy pipeline, and Dataflows Gen2 to Semantic models, Power BI Desktop, Gateway, and more.

Key capabilities in this new connector include (and are not limited to):

  • Metadata visibility for external objects.
  • Support for Redshift Data Sharing reads.
  • Enhanced support for new features launched in Amazon Redshift.
  • Ability to audit connections between Microsoft products and Amazon Redshift.

Rollout details

The new connector is rolling out automatically across regions. To be best prepared, we recommend that customers who want to implement and test the connector sooner should enable the preview features.

To learn more, please reference the Microsoft Redshift documentation.


To learn more, please reference the Set up your Amazon Redshift connection

Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular posts from this blog

Exception deserializing the package "The process cannot access the file because it is being used by another process."

-
TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...
Read more

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

SSRS INTERVIEW QUESTIONS

-
Q: What is SSRS? Ø   SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø   It is used for preparing and delivering interactive and variety of reports. Ø   It is administered through an web based interface. Ø   Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø   SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø   SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...
Read more