Скачать или смотреть Demo | Hello DB Join

Learn more about Amplify Fusion: https://www.axway.com/en/products/amp...

In this demo, we build on the previous video and demonstrate how to join multiple tables using Axway Amplify Fusion's Database Connector. You’ll see how to configure a plug, write a join query, and test the integration.

What you'll learn in this video:
🔗 How to perform an inner join between orders and customers tables in Postgres
⚙️ How to configure a plug for selecting data using the Database Connector
🧪 How to test and validate your integration inside Axway Amplify Fusion

This video is part of a series showcasing how easy it is to build integrations with minimal setup inside Axway Amplify Fusion. Watch the full series here    • Axway Amplify Fusion | Demo Series  

[Full video transcript]

Hi. In this video, we'll take a look at Axway Amplify Fusion’s, database connector and how we can do a join of multiple tables. This video will leverage the prior video.

Hello Database Connector where we configured a database connector to Postgres, and I connected to my Neon Postgres database. And in this case, I'm going to use the customer table

where I've got three customers Ada, Alan, and Grace, with IDs one, two, three. And I will also use this orders table, which has three orders, and “Shipped”, “New” and “Canceled” status. And two of them belong to Ada and one belongs to Alan. So we'll do a “Join”.

So let's come over here. Let's create a new test integration. “Hello DB Join”. Let's add a scheduler so we can run... this integration using the test button. And let's add a Database Select component here. Give it a label. And let's expand our configuration panel. Let's select our connector. And again this was configured in a prior video. And we don't have a plug for this.

So let's create a plug. So this will be “PostgresCustomerOrder Join” plug. And we click the “Configure” button and we select the connector. It's a select that we're performing. And let's use the public schema where I have my customer and orders tables that I want to join. And I think I'd like the “order_id”, “order_date”, “amount” and “status”. And I want to join with that the customer “full_name” and “email” So I'll have a list of orders that Axway has the customer name and email address on it.

So let's add a join. Let's start, “orders inner” join with customers and the condition is or “orders.customer_id” equals “customers.customer_id”. And let's generate that and save it. And we can do a quick test. And there's no inputs here. And if I look at the results I see two orders for Ada, one shipped, one new, and one order for Alan. And if I look here, remember, Ada is customer id “1” Alan is “2”. And if I look at my orders, you see, Ada has two orders “shipped” and “new”, and Alan has one order in the “cancelled” state. And the third customer has no orders.

So that seem to work pretty well. Let's come over here, click refresh, select our plug. Let's save that and let's run a test. And if I look at the results in the monitor and I look at the response, look at the results, I do see an order for Ada that's shipped. I see an order for Ada that's new, and I see an order for Alan, which was cancelled.

So in this video, we saw how easy it is to, join database tables using Axway’s Amplify Fusion database connector and plugs.

Thank you.

#Axway #DatabaseIntegration #AmplifyFusion