/*SBIO2 Database 	sbio_user	leech*/
//dbprod.dep.state.fl.us:1530/fdep
let
    Source = Oracle.Database("dbprod.dep.state.fl.us:1530/fdep",
	[HierarchicalNavigation=true,
    Query="
    SELECT *     FROM SBIO.V$IWR_WQX_VIEW s
    "])
in
    Source




/*DOPPLER AKA WIN		WIN_QUERY	query*/
//dbware.dep.state.fl.us:1525/doppler
let
    Source = Oracle.Database("dbware.dep.state.fl.us:1525/doppler", [HierarchicalNavigation=true,
    Query="
    SELECT DISTINCT w.DEP_ANALYTE_GROUP_NAME FROM WIN_SNAP.WH2R_RESULT_ACTVTY_ORG_LOCS w
    "])
in
    Source	

***************************************************************************

/* LIMS Active db*/
//LIMS tmdluser	tmdl_transfer
//dbprod.dep.state.fl.us:1527/oraprod
let
    Source = Oracle.Database("dbprod.dep.state.fl.us:1527/oraprod",
	[HierarchicalNavigation=true,
    Query="
	SELECT DISTINCT
	a.SAMP_STATUS
	FROM VGSM.EV_JOB_SAMP_TEST_RES a
	WHERE Extract(YEAR FROM CURRENT_DATE) LIKE '20%'
    "])
in
    Source
//............................................................................................................................................................................................................................................................	
/* LIMS */
//LIMS tmdluser	tmdl_transfer
//dbprod.dep.state.fl.us:1527/oraprod
let
    Source = Oracle.Database("dbprod.dep.state.fl.us:1527/oraprod", [HierarchicalNavigation=true,
    Query="

    "])
in
    Source