Return to Workshop

Import JDBC datasource

• file import teiid designer JDBC Database » source model

• Under Connection Profile, select new

• Select PostgreSQL as the Connection Profile Type, Next

• In the next window, click the New Driver Definition icon

• Under the Jar List tab, select Add JAR/Zip and then select jdv-demo/assets/postgres/postgresql-42.1.4.jar, then ok

• In the New JDBC Connection Profile window make sure to use the IP address of your PostgreSQL instance and put the credentails for the postgres user and check Save Password.

• Click Test Connection and verify you get a Ping Succeeded response before selecting Finish

• Select TABLE to import

• Then select the order_details table, then click next

• Name your model PostgresDS.xmi

• In folder demo-jdv/sources

• JNDI Name java:/PostgresDS

• Click Finish

Fix import default values

• We have to fix the default values for two properties.

• Click on the Package Diagram tab and then click on lastupdatedate and then change the property Default Value in the lower left to now()

• Click on status and then change the property Default Value in the lower left to ‘ACTIVE’ and then save the model

• On the Model Editor tab, highlight order_details then click the preview data button. You should see the Postgres data in the SQL Results tab

Create View Model

• Lets now create a REST view on top of this base layer

• file new Teiid Metadata Model

• Location demo-jdv/views

• Name PostgresView

• Model Type View Model

• Transform from an existing model, click next

• In the next window select the existing model as PostgresDS, click Finish and save the view model

Deploy View Model

• Open the vdb demo-jdv.vdb and click the Add Model button in the lower left. Select PostgresView and save the vdb. Click the Deploy button

Test with Postman

• In postman, run the PostgresView test. Verify that the Test Results tab returns PASS

Return to Workshop