Streamline AI-driven analytics and data governance by integrating Tableau with Amazon DataZone, ensuring seamless collaboration and visibility across your organization.

As a cloud-based metadata management platform, Information Administration provides seamless access, discovery, sharing, and governance of data stored across Amazon Web Services (AWS), on-premises infrastructure, and diverse third-party sources. Amazon DataZone now enables you to unlock the power of data exploration by introducing advanced information evaluation and visualization capabilities directly within your project-subscribed data in Amazon DataZone, all accessible via the JDBC driver.

After collaborating closely with colleagues, we have successfully tested and verified Amazon DataZone authentication through the Athena JDBC connection, providing a seamless and secure connectivity experience for users. With this integration, you can now effortlessly query and analyze your governed data lake properties in Amazon DataZone using standard enterprise intelligence (BI) and analytics tools, such as Tableau.

According to Ali Tore, Senior Vice President of Superior Analytics at Salesforce,

As Amazon DataZone launches, it further solidifies its commitment to safeguarding enterprise customers’ access to data across all the tools and platforms they rely on, ensuring seamless collaboration and decision-making within their organizations. Guardant Health leverages Amazon DataZone to democratize data ingestion across its organization, empowering diverse teams to seamlessly access, query, and analyze data tailored to their specific needs.

Rajesh Kucharlapati, Senior Director of Information, Customer Relationship Management (CRM), and Analytics at Guardant Health, notes

Use case

Amazon DataZone simplifies the way you share and access information, streamlining availability for all stakeholders. Right here’s how:

• As a key player in the information production process, you will have the capability to develop and curate valuable data assets while ensuring effective governance practices, thereby rendering information discoverable, accessible, shareable, and reutilizable.
• You’ll have seamless access to a wide range of information sources within a unified platform, allowing for streamlined discovery and subscription capabilities. You can analyze this data using a variety of tools, including built-in AWS options such as Amazon SageMaker, Amazon Comprehend, and Amazon Rekognition.
• The integration of companion analytics tools grants you increased flexibility and efficiency in your workflow processes. You can now leverage your analytics instruments in conjunction with Tableau to quickly extract business insights from your data while employing standardized definitions and decentralized ownership. How can you leverage these capabilities to integrate various tools seamlessly?

Stipulations

To get started, follow these steps:

1. Can you please download the latest Athena JDBC driver from the AWS S3 bucket at s3.amazonaws.com/athena- drivers/AthenaJDBC.jar? Once downloaded, extract the JAR file to a directory of your choice, and then include it in your classpath when connecting to an Amazon Athena database using Tableau.
2. Establish a JDBC connection in Tableau by copying the connection string from the Amazon DataZone portal and configuring it accordingly. You will be directed to authenticate using single sign-on (SSO) with your company credentials.

When connected, users can effortlessly interrogate, visualize, and collaborate on data-driven insights within the intuitive Tableau environment, powered by Amazon DataZone.

The following diagram illustrates the overarching architecture of the Tableau integration.

SKIP

To configure Tableau for project-subscribed information property access, follow these concise and actionable steps:

1. Acquire the latest version of the Athena driver for optimal performance and compatibility. Since Tableau has the Athena driver preinstalled, it may well be using the older v2 model? To ensure seamless integration with Amazon DataZone, utilize the latest v3 driver, which includes essential authentication capabilities for a hassle-free experience. To acquire the latest JDBC driver for Model X, visit.
2. Set up the motive force. Place the JDBC driver file in a location that is easily accessible from your project, such as the lib or resources directory of your Java Development Kit (JDK).
   • : ~/Library/Tableau/Drivers
   • : C:Program FilesTableauDrivers
3. From the Amazon DataZone console, select your venture as illustrated in the accompanying screenshot for the DataZone Console.
   
4. To successfully acquire JDBC connection parameters, follow this process:
   1. The connection options on our venture webpage are designed to facilitate seamless interactions with your clients. Select .
      
   2. Within the dialogue field, I will replicate the following:

      Please provide the original text you’d like me to improve. To leverage the integration seamlessly, consider utilizing an AWS Lambda function to connect with your Amazon DataZone project as an IAM role from a server, assuming you have been added as a project member within that project. The screenshot displays the dialog field, showcasing its layout and design.
      

5. To establish a connection with Tableau Desktop, follow these concise steps:
   1. Select the desired connection option.
      
   2. Paste the copied JDBC URL into the connection string field, leaving the other fields unmodified.
      
6. To seamlessly authenticate via single sign-on (SSO), simply choose from the options presented in the following screenshot: You will be redirected to authenticate with a secure server. Utilize the authentication credentials stored within your Amazon Web Services (AWS) Single Sign-On (SSO) profile.
   
7. Once logged in, a prompt to authenticate the transaction will appear. DataZoneAuthPlugin. To authorize entry to Amazon DataZone from Tableau, select accordingly as depicted in this screenshot.
   
8. After establishing the connection, a “hit” message appears, as demonstrated in the following screenshot.
   

Instantly view your venture’s subscribed data within Tableau and create personalized dashboards.

Conclusion

Amazon DataZone further expands its offerings, providing greater flexibility for how you input, explore, and visualize your curated data. With the aid of the Athena JDBC driver, users can seamlessly integrate a range of popular business intelligence and analytics tools with Tableau, unlocking unparalleled accessibility to governed data within Amazon Data Zone.

With this publication, readers learned about the streamlined integration of Amazon DataZone and Tableau. Through a seamless integration of Tableau with Amazon DataZone’s robust information governance features, we enable information consumers to quickly and effortlessly locate, explore, and draw insights from governed data. This integration empowers organisations to bridge gaps between departments, cultivate collaborative cultures, and inform decision-making processes while ensuring the robust security and governance needed within today’s complex, dispersed data landscapes?

The functionality is currently available in the location where Amazon DataZone is situated. Explore the accompanying video to learn how to integrate Amazon DataZone with external analytics tools using JDBC. Let’s get started with our technical support.

Associated weblog posts

In regards to the Authors

He serves as a Senior Product Supervisor – Technical for Exterior Suppliers at AWS in Seattle, Washington, currently part of the Amazon DataZone team. He’s passionate about developing top-performing machine learning/artificial intelligence and analytics solutions that empower businesses to achieve their strategic objectives through innovative technologies. Join with him on .

Adiascar Cisneros Is a Senior Product Supervisor for Tableau, primarily located in Atlanta, Georgia? He leverages the synergy between the Tableau Platform and AWS companies to exponentially enhance the value customers derive from our offerings, accelerating their path to high-impact, data-driven decision-making. With a foundation in analytics, infrastructure development, community safety initiatives, and expertise in managing complex migrations, his background is well-rounded. Comply with him on .

Joel Farvault As a seasoned expert, Principal Specialist in SA Analytics at AWS, I bring 25 years of experience to bear on complex projects, specializing in enterprise architecture, information governance, and analytics within the financial services sector. Joel has spearheaded transformative initiatives in fraud analytics, claims automation, and data governance through Grasp Information Management. He capitalizes on his specialist knowledge to counsel customers on fortifying the foundations of their informational techniques.

Yogesh Dhimate is a Sr. As a seasoned Companion Options Architect at Amazon Web Services (AWS), my primary area of focus is fostering strategic partnerships with leading visualization and analytics solutions like Tableau. Prior to joining AWS, Yogesh worked with major companies such as Salesforce, driving their business strategy initiatives. With a distinguished career spanning over two decades in product administration and options structuring, Yogesh possesses a unique vantage point on the convergence of cloud computing and artificial intelligence.

Ariana Rahgozar is a Sr. As Senior Options Architect at Amazon Web Services (AWS), I collaborate closely with key clients to craft and deploy bespoke technical solutions that seamlessly integrate into their cloud transformation initiatives.