![microsoft access sample database northwindmdb schematic microsoft access sample database northwindmdb schematic](https://i.pinimg.com/736x/e3/e7/9f/e3e79febd8e9844e963b9b6934f69432--microsoft-computer.jpg)
![microsoft access sample database northwindmdb schematic microsoft access sample database northwindmdb schematic](https://599cd.com/templates/access/customer-database/img13.jpg)
The last one is called ‘Import Entities’, and we played with that one a long time ago. Open the ‘Northwind Database Metadata’ document again and check out those interesting icons in the top! We save and close all the panels and get back in our ‘northwind’ project…
![microsoft access sample database northwindmdb schematic microsoft access sample database northwindmdb schematic](https://i.pinimg.com/originals/15/05/28/1505283b821541de196157757c467ead.jpg)
Let’s move all those tables to the right side of the panel and save it…Nice…Short break before we jump into even better stuff!! Give a nice name like I did and then hit that blue link called ‘Retrieve all tables’ to see some magic stuff happening! Right-click on the ‘metadata’ folder we’ve created for our ‘northwind’ project and create a new document of type ‘Database metadata’ Your first ‘Database metadata’ document type Hit that ‘Finish’ with a bright shining end-result like this Make sure you test the connectivity before you save it all…When done, you’ll be back in that wizard for the ‘Next >’ step: Connection String: jdbc:postgresql://localhost:5432/northwind.This is our ‘fun’ screen as we will create a new ‘Database configuration’ with this database configuration info Make sure it’s ‘Automagically’ started and hit ‘Next >’ Give it a nice name and select those two basic service interfaces. Select the ‘WS-AppServer’ connector and hit ‘Next >’ Open the ‘System Resource Manager’ (you need to be an administrator for this!) and create a new service group: I don’t know if you already know the drill, but here you go… The creation of the WS-AppServer service container Time for ‘the magic’ to connect our database to a service container that makes it possible to generate webservices out of our northwind data…What? Is that possible? With that project we directly create some nice folder structure to start with! If you already have a ‘generic’ project available like I have you can start creating a new project next to it, with the name of ‘northwind’…How logical!? Time for the ‘Northwind’ AppWorks project Select the downloaded raw ‘northwind.sql’ file and hit the ‘Open’ button to start importing all that data…Īfter a minute you will end up in this set of tables for you to consume from through our AppWorks platform: Hit that ‘File’ menu item and choose ‘Run SQL File…’ Now that we’re connected to our ‘Northwind’ database it’s time to load some data into it. Now, right-click the top node and create a new database with the name ‘northwind’Īfter that database creation you need to disconnect and reconnect again, so you are able to select that brand-new database: So, spin up the AppWorks VM and make sure you have the HeidiSQL tool locally available with a connection to Postgres (not YET! a specific database)… The database contains the sales data for Northwind Traders, a fictitious specialty foods export/import company.Īha…So, it’s just some sample data to play around with, but it’s on a Microsoft SQL database…We run on PostgreSQL!? Lucky for us there is an interesting GitHub repository “Northwind database for Postgres”Īnd there we found the raw SQL script to build these databases for our own environment…How nice! The Northwind database is a sample database used by Microsoft to demonstrate the features of some of its products, including SQL Server. Let’s start with a retrieval from google on ‘what is the northwind database’? But what is the ‘Northwind’ database and what can we do with it? We’ll get an answer on that one as I’m as curious as you will probably be, so… Have you ever heard of it?…The ‘Northwind’ database!? Well, you might see it back in a lot of samples in the OpenText documentation. Welcome to a new installment of AppWorks tips.