Entry Amazon Redshift information from Salesforce Knowledge Cloud with Zero Copy Knowledge Federation

This put up is co-authored by Vijay Gopalakrishnan, Director of Product, Salesforce Knowledge Cloud.

In right now’s data-driven enterprise panorama, organizations accumulate a wealth of information throughout numerous contact factors and unify it in a central information warehouse or a knowledge lake to ship enterprise insights. This information is primarily used for analytical and machine studying functions, however not simply accessible by the enterprise customers throughout Gross sales, Service, and Advertising and marketing groups to make information pushed selections. Salesforce and Amazon collaborated to deal with this problem, by making the information accessible to the customers within the circulate of their work, with Zero Copy Knowledge Federation between Salesforce Knowledge Cloud and Amazon Redshift. This resolution empowers companies to entry Redshift information inside the Salesforce Knowledge Cloud, breaking down information silos, gaining deeper insights, and creating unified buyer profiles to ship extremely personalised experiences throughout numerous touchpoints. By eliminating the necessity for information replication, this integration improves effectivity and reduces prices whereas enabling real-time entry to invaluable enterprise information.

On this put up, we discover the advantages of the brand new Zero Copy Knowledge Federation and supply a step-by-step steering to configure it in Salesforce Knowledge Cloud.

What’s Salesforce Knowledge Cloud?

Salesforce Knowledge Cloud is a knowledge platform that unifies your entire firm’s information into Salesforce’s Einstein 1 Platform, giving each group a 360-degree view of the shopper to drive automation, create analytics, personalize engagement, and energy trusted synthetic intelligence (AI). Knowledge Cloud creates a holistic buyer view by turning volumes of disconnected information right into a unified buyer profile that’s easy to entry and perceive. This consists of numerous datasets like telemetry information, internet engagement information, and extra throughout your group or your exterior information lakes and warehouses. This unified view helps your Gross sales, Service, and Advertising and marketing groups construct personalised buyer experiences, invoke data-driven actions and workflows, and safely drive AI throughout all of your Salesforce apps.

What’s Amazon Redshift?

Amazon Redshift is a quick, totally managed, petabyte-scale information warehouse service that makes it easy and cost-effective to effectively analyze all of your information utilizing your present enterprise intelligence (BI) instruments. It’s optimized for datasets starting from a couple of hundred gigabytes to a petabyte or extra and delivers higher price-performance in comparison with most conventional information warehousing options. With a completely managed AI powered massively parallel processing (MPP) structure, Amazon Redshift makes enterprise decision-making fast and cost-effective.

What’s Zero Copy Knowledge Federation?

Zero Copy Knowledge Federation, a Salesforce Knowledge Cloud functionality, unifies Salesforce and Amazon Redshift information by a point-and-click interface. It gives safe, real-time entry to Redshift information with out copying, preserving enterprise information in place. This eliminates replication overhead and ensures entry to present data, enhancing information integration whereas sustaining information integrity and effectivity.

Knowledge federated from Amazon Redshift is represented as a local information cloud object which energy numerous Knowledge Cloud options, together with advertising segmentation, activations, and course of automation. With these capabilities at your fingertips, you possibly can enrich unified buyer profile in Salesforce Knowledge Cloud with transaction information from Amazon Redshift to create a wealthy buyer 360, acquire insights, harness predictive and generative AI on the unified information, and finally ship extremely personalised experiences throughout a number of touchpoints.

The next diagram depicts Zero Copy Knowledge Federation circulate, key options enabled and few potential actions and activations.

Connection to Amazon Redshift is established by deploying a knowledge stream in Salesforce Knowledge Cloud. If you deploy a knowledge stream from Amazon Redshift to Knowledge Cloud, an exterior information lake object (DLO) is created inside the Knowledge Cloud atmosphere. This exterior DLO acts as a storage container, housing metadata in your federated Redshift information. Importantly, the DLO serves as a reference, pointing to the information bodily saved in your Redshift information warehouse, preserving your information in its unique location. Much like native DLOs, the Amazon Redshift backed exterior DLOs can energy a number of key options, together with batch remodel, calculated insights, identification decision, question, segmentation, and activation, amongst others. Buyer unified profiles enriched with Redshift information may very well be actioned by Amazon SageMaker to drive predictive outcomes and activated throughout a number of platforms, together with Amazon Adverts and Salesforce Advertising and marketing Cloud, for creating viewers journeys and operating focused campaigns.

To extend efficiency, you possibly can go for acceleration, which is designed to boost question runtimes. For extra data on this function, discuss with Acceleration in Knowledge Federation.

To summarize, Zero Copy Knowledge Federation gives the next advantages:

• Unified information view: Integrates exterior information seamlessly with Salesforce information for a complete buyer view.
• Actual-time entry: Supplies close to real-time entry to information saved in exterior sources like Amazon Redshift.
• Knowledge effectivity: Eliminates the necessity to copy or transfer massive datasets, decreasing storage prices and information duplication.
• Value-effective: Reduces information switch pipeline and storage prices related to conventional information integration strategies.
• Enhanced safety: Knowledge stays in its unique safe atmosphere, decreasing publicity dangers.
• Streamlined compliance: Simplifies information governance by sustaining information in its unique, regulated atmosphere.

Stipulations

Earlier than configuring information federation, you will need to have entry to Salesforce Knowledge Cloud and the data to hook up with your Redshift provisioned or serverless warehouse. The Redshift warehouse should be publicly accessible and it is suggested to limit entry by enable itemizing solely the Knowledge Cloud IP addresses.

For data on establishing an Amazon Redshift Serverless or Amazon Redshift provisioned cluster, discuss with Amazon Redshift Serverless or Amazon Redshift provisioned clusters, respectively.

Configure Zero Copy Knowledge Federation

To federate Redshift information to Salesforce Knowledge Cloud, begin by configuring a Redshift connection.

1. Log in to Salesforce Knowledge Cloud and navigate to Knowledge Cloud Setup.
   
2. Within the navigation pane, select Connectors below Configuration.
   
3. Select New, select Amazon Redshift, and select Subsequent.
   
4. Retrieve the Redshift endpoint by navigating to the Redshift Serverless or provisioned cluster within the AWS console. Following picture exhibits the way to get hold of the endpoint URL for Redshift serverless.
   
5. Again in Salesforce Knowledge Cloud, configure the connector with a singular title and enter the endpoint out of your Redshift server.
6. Enter the person title and password configured in your Redshift serverless namespace.
7. Enter the title of the database configured in your Redshift serverless namespace.
   
8. Select Take a look at Connection to verify you’re in a position to efficiently connect with the Redshift occasion and select Save.
   

Create a Redshift Zero Copy Knowledge Federation information stream

Full the next steps to create a knowledge stream utilizing the connection you created:

1. Navigate to Knowledge Cloud and select Knowledge Streams within the navigation bar.
2. Select New to arrange a brand new information stream.
   
3. Select Amazon Redshift and select Subsequent.
   
4. Select your connector, database, and objects, then select Subsequent.
   
5. Configure the item, class, main key, and fields:
   1. Set the item title and object API title. For extra data, see Knowledge Lake Object Naming Requirements.
   2. Set the class to specify the kind of information to ingest. For extra data, see Class.
   3. Set the first key to establish the incoming information uniquely. For extra data, see Main Key.
   4. Choose the supply fields you need to ingest.
6. Select Subsequent.
   
7. Choose the related information house. Select default if you happen to don’t have some other information house provisioned in your group. For extra data, see Handle Knowledge Areas.
8. If you wish to question the information in your Redshift occasion with decreased latency, choose Allow acceleration and select your acceleration schedule. For extra data, see Acceleration in Knowledge Federation.
9. Select Deploy.
   

On profitable deployment, a knowledge stream is created.

Use circumstances for Zero Copy Knowledge Federation

The next are key use circumstances enabled by Zero Copy Knowledge Federation between Redshift and Salesforce Knowledge Cloud:

• Advertising and marketing insurance coverage marketing campaign journey – Mix buyer profile, insurance coverage coverage, and plan information in Amazon Redshift with buyer information in Salesforce Cloud for focused outreach campaigns in Advertising and marketing Cloud. This facilitates cross-selling of different monetary merchandise.
• Focused promotions and buyer outreach – Merge buyer buy and profile information from Amazon Redshift with buyer suggestions and repair information in Salesforce for focused buyer outreach in Advertising and marketing Cloud, together with promotional offers.
• Buyer satisfaction utilizing service cloud information – Mix buyer and case information in Salesforce with buyer suggestions information in Amazon Redshift to find out buyer satisfaction scores, enhancing service high quality.
• Prioritized provides and data-driven next-best actions – Make the most of buyer billing accounts and repair information from Salesforce together with prospect, order, and billing information in Amazon Redshift to generate prioritized provides and next-best actions. The transition from ETL pipelines to Zero Copy BYOL integration has streamlined operations.
• Buyer segmentation and activation – Federate buy information and billing historical past from Amazon Redshift to complement unified profiles in Salesforce Knowledge Cloud and generate actionable insights based mostly on the recency, frequency, and financial worth to create buyer segments and activate to your required supply.
• Buyer 360 with wealthy insights – Enrich buyer profiles in Salesforce Knowledge Cloud with buy, billing, and product information from Amazon Redshift to empower Advertising and marketing, Gross sales, and Service groups to enhance buyer engagement with wealthy buyer insights.

Conclusion

Zero Copy Knowledge Federation between Salesforce Knowledge Cloud and Amazon Redshift empowers companies to interrupt down information silos, improve buyer experiences, and drive operational efficiencies. By federating Redshift information to Salesforce Knowledge Cloud, organizations could make knowledgeable selections sooner, personalize buyer interactions at scale, and optimize assets throughout advertising, gross sales, service, and operations. This integration units a brand new customary for data-driven enterprise success within the digital age. Try the Salesforce Zero Copy Knowledge Federation announcement and the next assets to be taught extra and get began:

In regards to the Authors

Vijay Gopalakrishnan is a Director of Product Administration with Salesforce with a number of years of expertise within the information house. He at present is part of the Salesforce Knowledge Cloud group.

Ravi Bhattiprolu is a Sr. Associate Options Architect at AWS. Ravi works with strategic ISV companions, Salesforce and Tableau, to ship progressive and well-architected merchandise and options that assist joint clients obtain their enterprise and technical goals.

Avijit Goswami is a Principal Options Architect at AWS specialised in information and analytics. He helps AWS strategic clients in constructing high-performing, safe, and scalable information lake options on AWS utilizing AWS managed companies and open-source options. Exterior of his work, Avijit likes to journey, hike, watch sports activities, and take heed to music.

Ife Stewart is a Principal Options Architect within the Strategic ISV phase at AWS. She has been engaged with Salesforce Knowledge Cloud during the last 2 years to assist construct built-in buyer experiences throughout Salesforce and AWS. Ife has over 10 years of expertise in expertise. She is an advocate for range and inclusion within the expertise subject.

Mike Patterson is a Senior Buyer Options Supervisor within the Strategic ISV phase at AWS. He has partnered with Salesforce Knowledge Cloud to align enterprise goals with progressive AWS options to realize impactful buyer experiences. In Mike’s spare time, he enjoys spending time along with his household, sports activities, and outside actions.