#Amazon redshift odbc driver 64 bit how to
#Amazon redshift odbc driver 64 bit code

Power BI is a data visualization tool developed by Microsoft that offers enterprise business intelligence (BI) capabilities. Keycloak provides SSO, User Federation, Identity Brokering, Social Login, etc. Keycloak is an open-source IAM tool, it’s based on standards such as SAML 2.0, OIDC, and OAuth2.0. IAM also has the SAML 2.0 (Security Assertion Markup Language 2.0) identity provider (IdP) entity which supports SAML 2.0 standard. It helps administrators manage permissions in a central location and control users’ accessibility to AWS resources. It also handles the authentication and authorization to use resources. IAM is a web service that secures and controls access to the resources in AWS. Amazon Redshift also offers a serverless option that automatically provisions and scales data warehouse capacity to meet the requirements for demanding and unpredictable workloads. Let’s review the concepts of the key components used in the solution.Īmazon Redshift is a fully-managed petabyte-scale cloud data warehouse service that uses SQL to analyze the structure, semi-structured data across databases, and data lakes, as well as provides a secure and reliable analytics service.

#Amazon redshift odbc driver 64 bit how to

We are also explaining how to overcome the challenges associated with the ODBC driver and its support for OpenID Connect (OIDC) using SAML based assertion and OIDC tokens to establish the connectivity between Power BI and Amazon Redshift using Amazon Redshift ODBC Driver. This post demonstrates how Xylem and AWS partners worked together to enable secure connectivity using Amazon Redshift, AWS Identity and Access Management (IAM), Keycloak and Power BI. To secure and protect users’ data, we integrated Single-Sign-On (SSO) credentialing directly to Amazon Redshift clusters to facilitate individual user connections via an Identity Provider. Customers access and analyze the data in Amazon Redshift using Power BI. Xylem built Sensus Utility Data Lake on AWS and stored the utilities’ data in Amazon Redshift. The main benefit is to give customers the analytical abilities to satisfy their regional specific analysis and regulatory needs, which differ from the greater population of utilities served by the existing product portfolio.

#Amazon redshift odbc driver 64 bit code

One of those innovative solutions is the Sensus Utility Data Lake, where customers can capture data from their smart meters and use self-service/low code tooling to draw novel analytic insights from their data. Xylem (NYSE: XYL) is a leading global water technology company committed to solving critical water and infrastructure challenges with innovation.