Once we have the connection set up, it is very easy to grab table metadata from the database for use in our jobs. The following example shows how simple this is.
If you have set up the database correctly, then you should be able to see three tables in the database;
The steps to be performed are as follows:
cookbookDB_myCopydatabase connection and select Retrieve Schema.