$Self->{ExternalDB} = {
        DataSource1 => {
                Name => 'Inventory',
                Url => 'DBI:mysql:database=inventorydb;host=localhost;',
                User => "inventory_app",
                Password => "inventory_pwd",
                DB => 'MySQL',
                LimitResults => 300,
                SearchColumns => [ "SERIAL", "TYPEID", "BRAND", "MODEL", "CENTRE" ],
                SearchColumnsType => [ "var", "int", "var", "var", "var"  ],
                ShowColumns => [ "SERIAL", "CENTRE" ,"BRAND", "MODEL", "NAME" ],
                From => "ITEMS_TBL",
                Where => "(STATUS<>'RETIRED' AND ESTADO<>'STOLEN')",
                GroupBy => "",
                OrderBy => "",
        },

        DataSource2 => {
                Name => 'CoursePupils',
                Url => 'DBI:mysql:database=coursedb;host=dbserver;',
                User => 'course_app',
                Password => 'course_pwd',
                DB => 'Oracle',
                LimitResults => 20,
                SearchColumns => [ "nie", "name" ],
                SearchColumnsType => [ "var", "var" ],
                ShowColumns => [ "id", "nie", "name" ],
                From => "pupils p",
                OrderBy => "name",
        },
};