ref #9918 first version of caryophyllaceae import

[cdmlib-apps.git] / app-import / src / main / java / eu / etaxonomy / cdm / app / common / CdmDestinations.java

diff --git a/app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java b/app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java
index 2355653fa08b5ce0725c5a11940c436c98fe9871..607d55378fad69da168086c43ff7e528a92d7d05 100644 (file)
--- a/app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java
+++ b/app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java
@@ -13,65 +13,107 @@ import java.lang.reflect.Method;
 
 import org.apache.log4j.Logger;
 
-import eu.etaxonomy.cdm.common.AccountStore;
+import eu.etaxonomy.cdm.config.AccountStore;
 import eu.etaxonomy.cdm.database.CdmDataSource;
 import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
 import eu.etaxonomy.cdm.database.ICdmDataSource;
 
 public class CdmDestinations {
+
        @SuppressWarnings("unused")
        private static Logger logger = Logger.getLogger(CdmDestinations.class);
 
-       public static ICdmDataSource cdm_redlist_localhost(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "localhost";
-               String cdmDB = "cdm_bfn_imports"; 
-               String cdmUserName = "root";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-       
-       public static ICdmDataSource cdm_redlist_plant_localhost(){
+    public static ICdmDataSource cdm_pesi2019_final(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_pesi_2019final";
+        String cdmUserName = "edit";
+        int port = 3306;
+        return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_local_redlist_animalia(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "localhost";
-               String cdmDB = "cdm_bfn_imports_plants"; 
-               String cdmUserName = "root";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-       
-       public static ICdmDataSource cdm_redlist_lumbricidae(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.171";
-               String cdmDB = "cdm_production_rl_lumbricidae"; 
+               String cdmDB = "cdm_bfn_imports_animalia";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
-       public static ICdmDataSource cdm_testDB_localhost(){
+
+    public static ICdmDataSource cdm_redlist_animalia_production(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_rl_animalia";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_additivity_ontology(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_additivity_ontology";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_redlist_animalia_production_final(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_rl_animalia_final";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_local_redlist_plant(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "localhost";
-               String cdmDB = "testDB"; 
-               String cdmUserName = "root";
+               String cdmDB = "cdm_bfn_imports_plants";
+               String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_test_useSummary(){
+       public static ICdmDataSource cdm_local_testDB(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "localhost";
-               String cdmDB = "palmae_2011_07_17";
+               String cdmDB = "testDB";
                String cdmUserName = "root";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_test_local_mysql(){
+    public static ICdmDataSource cdm_local_test_mysql(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "test";
+        String cdmUserName = "root";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_cdmtest_mysql(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_test";
+        String cdmUserName = "root";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_uzbekistan(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_uzbekistan";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_local_redlist_gefaesspflanzen(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
-               String cdmDB = "cdm_test";
+               String cdmDB = "rl2020_gefaesspflanzen";
                String cdmUserName = "root";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
 
-       public static ICdmDataSource cdm_test_local_mysql_moose(){
+       public static ICdmDataSource cdm_local_test_mysql_moose(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                String cdmDB = "moose";
@@ -79,7 +121,7 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_test_local_mysql_standardliste(){
+       public static ICdmDataSource cdm_local_test_mysql_standardliste(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                String cdmDB = "standardliste";
@@ -88,7 +130,7 @@ public class CdmDestinations {
        }
 
 
-       public static ICdmDataSource cdm_test_local_mysql_dwca(){
+       public static ICdmDataSource cdm_local_test_mysql_dwca(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                String cdmDB = "dwca";
@@ -97,7 +139,7 @@ public class CdmDestinations {
        }
 
 
-       public static ICdmDataSource cdm_test_local_mysql_fdac(){
+       public static ICdmDataSource cdm_local_mysql_fdac(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                String cdmDB = "fdac";
@@ -113,30 +155,115 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_test_local_euromed(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "127.0.0.1";
-               String cdmDB = "euroMed";
-               String cdmUserName = "root";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-       
-       public static ICdmDataSource cdm_test_local_euromed2(){
+    public static ICdmDataSource cdm_local_greece(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_test_greece";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_test_bogota(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_local_flora_bogota";
+        String cdmUserName = "edit";     //root on pesiimport2
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_casearia(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_casearia";
+        String cdmUserName = "edit";     //root on pesiimport2
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_mysql_pesi_euromed(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_pesi_euromed";
+        String cdmUserName = "edit";
+        int port = 3306;
+        return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_euromed(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_euromed";
+        String cdmUserName = "edit";
+        int port = 3306;
+        return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_mysql_tmpTest(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "tmpTest";
+        String cdmUserName = "edit";
+        int port = 3306;
+        return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_local_euromed2(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                String cdmDB = "euroMed2";
-               String cdmUserName = "root";
+               String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       public static ICdmDataSource cdm_test_local_euromed3(){
+    public static ICdmDataSource cdm_local_euromed_caucasus(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "euromed_caucasus";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+
+
+       public static ICdmDataSource cdm_local_test_euromed3(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                String cdmDB = "euroMed3";
                String cdmUserName = "root";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
-       
+
+    public static ICdmDataSource cdm_test_col(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_col";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_test_col2(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_col2";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_col(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "col_test";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_col2(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "col_test2";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+
        public static ICdmDataSource cdm_local_EDITImport(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
@@ -144,7 +271,7 @@ public class CdmDestinations {
                String cdmUserName = "edit";     //root on pesiimport2
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
+
        public static ICdmDataSource cdm_test_euroMed(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
@@ -153,41 +280,39 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_pesi_euromed(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.175";
-               String cdmDB = "cdm_pesi_euromed";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-       
-       public static ICdmDataSource cdm_corvidae_dev(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.175";
-               String cdmDB = "cdm_corvidae";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
+    public static ICdmDataSource cdm_production_euromed(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_euromed";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_euromed_caucasus(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_euromed_caucasus";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
-       public static ICdmDataSource cdm_ildis_dev(){
+       public static ICdmDataSource cdm_test_corvidae(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
-               String cdmDB = "cdm_edit_ildis";
+               String cdmDB = "cdm_corvidae";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-//
-//     public static ICdmDataSource cdm_ildis_production(){
-//             DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-//             String cdmServer = "160.45.63.171";
-//             String cdmDB = "cdm_edit_ildis";
-//             String cdmUserName = "edit";
-//             return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-//     }
-
+   public static ICdmDataSource cdm_test_redlist_mammalia(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_rl_mammalia";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
-       public static ICdmDataSource cdm_redlist_moose_dev(){
+       public static ICdmDataSource cdm_test_redlist_moose(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
                String cdmDB = "cdm_mt_moose";
@@ -202,8 +327,8 @@ public class CdmDestinations {
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
-       public static ICdmDataSource cdm_redlist_standardlist_dev(){
+
+       public static ICdmDataSource cdm_test_redlist_standardlist(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
                String cdmDB = "cdm_mt_standardliste";
@@ -211,7 +336,31 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_cyprus_dev(){
+       public static ICdmDataSource cdm_test_redlist_germanSL(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_rl_german_sl";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_germanSL(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_rl_german_sl";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource local_cyprus(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "localhost";
+        String cdmDB = "cdm_cyprus";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_test_cyprus(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
                String cdmDB = "cdm_cyprus";
@@ -219,7 +368,15 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_cyprus_production(){
+    public static ICdmDataSource cdm_test_bupleurum(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_test_bupleurum";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_production_cyprus(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.171";
                String cdmDB = "cdm_production_cyprus";
@@ -227,25 +384,80 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_cyprus_production_tunnel(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "127.0.0.1";
-               int port = 13306;
-               String cdmDB = "cdm_production_cyprus";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
-       }
+    public static ICdmDataSource cdm_production_casearia(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_casearia";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_uzbekistan(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_flora_uzbekistan";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_phycobank_production(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_phycobank";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_flora_cuba(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_flora_cuba";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_greece_checklist(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_flora_greece";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_lichenes(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_lichenes";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_mexico_rubiaceae(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_rubiaceae_mexico";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_bogota(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_flora_bogota";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
-       public static ICdmDataSource cdm_cyprus_dev_tunnel(){
+       public static ICdmDataSource cdm_production_tunnel_cyprus(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                int port = 13306;
-               String cdmDB = "cdm_cyprus";
+               String cdmDB = "cdm_production_cyprus";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_campanulaceae_production(){
+       public static ICdmDataSource cdm_production_campanulaceae(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.171";
                String cdmDB = "cdm_production_campanulaceae";
@@ -253,23 +465,7 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_flora_malesiana_preview(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.175";
-               String cdmDB = "cdm_edit_flora_malesiana";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-
-       public static ICdmDataSource cdm_flora_malesiana_production(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.171";
-               String cdmDB = "cdm_production_flora_malesiana";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-
-       public static ICdmDataSource cdm_portal_test_localhost(){
+       public static ICdmDataSource cdm_local_portal_test(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                String cdmDB = "cdm_portal_test";
@@ -277,7 +473,7 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_portal_test_localhost2(){
+       public static ICdmDataSource cdm_local_portal_test2(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
                String cdmDB = "cdm_portal_test2";
@@ -293,31 +489,121 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_local_diptera(){
+    public static ICdmDataSource cdm_local_cyprus(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_cyprus";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_mexico(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_mexico";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+    public static ICdmDataSource cdm_local_mexico2(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_mexico2";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_local_palmae(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
-               String cdmDB = "cdm_edit_diptera";
+               String cdmDB = "cdm_edit_caryo";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_local_palmae(){
+    public static ICdmDataSource cdm_local_cuba(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_flora_cuba";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_local_caryo(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
-               String cdmDB = "cdm_edit_palmae";
+               String cdmDB = "cdm_caryo_spp";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_globis_dev(){
+       public static ICdmDataSource cdm_local_algaterranew(){
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+               String cdmServer = "127.0.0.1";
+               String cdmDB = "cdm_production_algaterranew";
+               String cdmUserName = "root";
+               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+       }
+
+       public static ICdmDataSource cdm_test_globis(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
                String cdmDB = "cdm_edit_globis";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
-       public static ICdmDataSource cdm_globis_production(){
+
+    public static ICdmDataSource cdm_local_edaphobase(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "edaphobase";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_postgres_edaphobase(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
+        String cdmServer = "130.133.70.26";
+        String cdmDB = "cdm_edaphobase";
+        String cdmUserName = "edaphobase";
+        int port = 5433;
+        return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_test_postgres_edaphobase(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_edaphobase";
+        String cdmUserName = "edaphobase";
+        int port = 5432;
+        return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_test_postgres__ssh_edaphobase(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
+        String cdmServer = "localhost";
+        String cdmDB = "cdm_edaphobase";
+        String cdmUserName = "edaphobase";
+        int port = 13306;
+        return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_caryo_spp(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_local_caryophyllales_spp";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_local_caryo_spp2(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_caryo_spp2";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_production_globis(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.171";
                String cdmDB = "cdm_production_globis";
@@ -340,28 +626,22 @@ public class CdmDestinations {
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-
-       public static ICdmDataSource cdm_local_tdwg2010(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "127.0.0.1";
-               String cdmDB = "cdm_tdwg2010";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-
-
-       public static ICdmDataSource NULL(){
-               return null;
-       }
+    public static ICdmDataSource cdm_mexico_flora(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "132.248.13.83";
+        String cdmDB = "cdm_flora_mexico";
+        String cdmUserName = "bgbm-developer";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
 
        public static ICdmDataSource localH2(){
                return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
        }
 
-       public static ICdmDataSource localH2(String database, String username, String filePath){
-               return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
-       }
+       public static ICdmDataSource localH2Edapho(){
+        return CdmDataSource.NewH2EmbeddedInstance("cdmEdapho", "sa", "");
+    }
 
        public static ICdmDataSource localH2Salvador(){
                return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
@@ -370,7 +650,7 @@ public class CdmDestinations {
        public static ICdmDataSource localH2Armeria(){
                return CdmDataSource.NewH2EmbeddedInstance("armeria", "sa", "");
        }
-       
+
        public static ICdmDataSource localH2Standardliste(){
                return CdmDataSource.NewH2EmbeddedInstance("standardliste", "sa", "");
        }
@@ -392,7 +672,37 @@ public class CdmDestinations {
        }
 
 
-       public static ICdmDataSource cdm_algaterra_preview(){
+    public static ICdmDataSource cdm_test_test1(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_test1";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+       }
+    public static ICdmDataSource cdm_test_test2(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_test2";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+    public static ICdmDataSource cdm_test_test3(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_test3";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_test_phycobank(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_phycobank";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_test_algaterra(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
                String cdmDB = "cdm_edit_algaterra";
@@ -408,16 +718,23 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_edit_cichorieae_local_PG(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
-               String cdmServer = "127.0.0.1";
-               String cdmDB = "cdm_edit_cichorieae_a";
-               String cdmUserName = "edit";
-               int port = 15432;
-               return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
-       }
+    public static ICdmDataSource cdm_test_salvador(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_salvador";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_production_salvador(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_salvador";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
-       public static ICdmDataSource cdm_cichorieae_preview(){
+       public static ICdmDataSource cdm_test_cichorieae(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
                String cdmDB = "cdm_edit_cichorieae";
@@ -425,10 +742,25 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
+    public static ICdmDataSource cdm_int_flora_malesiana(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.201";
+        String cdmDB = "cdm_integration_flora_malesiana";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_test_caryo_spp(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_caryo_spp";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
        public static ICdmDataSource cdm_production_cichorieae(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.171";
-//             String cdmServer = "127.0.0.1";
                String cdmDB = "cdm_production_cichorieae";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
@@ -441,7 +773,7 @@ public class CdmDestinations {
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
+
        public static ICdmDataSource cdm_production_flora_deutschland(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.171";
@@ -449,8 +781,8 @@ public class CdmDestinations {
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
-       public static ICdmDataSource cdm_production_caryophyllales(){
+
+       public static ICdmDataSource cdm_production_caryophyllales_genus(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.171";
                String cdmDB = "cdm_production_caryophyllales";
@@ -458,32 +790,45 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
+       public static ICdmDataSource cdm_production_caryophyllales_spp(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_caryophyllales_spp";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_production_caryophyllales_nepenthaceae(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_caryo_nepenthaceae";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
-       public static ICdmDataSource cdm_production_diptera(){
+       public static ICdmDataSource cdm_local_caryophyllales_nepenthaceae(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_local_caryo_nepenthaceae";
+        String cdmUserName = "root";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+       public static ICdmDataSource cdm_production_redlist_gefaesspflanzen(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.171";
-               String cdmDB = "cdm_production_diptera";
+               String cdmDB = "cdm_production_rl_plantae";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_edit_cichorieae_preview(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "127.0.0.1";
-               String cdmDB = "cdm_edit_cichorieae";
-               String cdmUserName = "edit";
-               int port = 13306;
-               return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
-       }
-
-       public static ICdmDataSource cdm_edit_cichorieae_preview_direct(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.175";
-               String cdmDB = "cdm_edit_cichorieae";
-               String cdmUserName = "edit";
-               int port = 3306;
-               return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
-       }
+    public static ICdmDataSource cdm_production_edaphobase(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_edaphobase";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
        public static ICdmDataSource cdm_production_piB(String database){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
@@ -492,7 +837,7 @@ public class CdmDestinations {
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
+
        public static ICdmDataSource cdm_local_piB(String database){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
@@ -500,74 +845,30 @@ public class CdmDestinations {
                String cdmUserName = "root";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
-       
-       /**
-     * patricia
-     */
-    public static ICdmDataSource mon_cdm() {
-        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-        String cdmServer = "localhost";
-        String cdmDB = "cdm_local";
-        String cdmUserName = "root";
-        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-    }
 
-   public static ICdmDataSource proibiosphere_chenopodium_local() {
+   public static ICdmDataSource cdm_local_proibiosphere_chenopodium() {
         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
         String cdmServer = "localhost";
         String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
         String cdmUserName = "root";
         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-    }
-
-   public static ICdmDataSource proibiosphere_ants_local() {
-       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-       String cdmServer = "localhost";
-       String cdmDB = "cdm_production_proibiosphere_ants_pilot";
-       String cdmUserName = "root";
-       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
    }
 
-   public static ICdmDataSource proibiosphere_fungi_local() {
+   public static ICdmDataSource cdm_local_proibiosphere_spiders() {
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
        String cdmServer = "localhost";
-       String cdmDB = "cdm_production_proibiosphere_fungi_pilot";
-       String cdmUserName = "root";
-       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-   }
-
-   public static ICdmDataSource proibiosphere_campylopus_local() {
-       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-       String cdmServer = "localhost";
-       String cdmDB = "cdm_production_proibiosphere_campylopus_pilot";
-       String cdmUserName = "root";
-       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-   }
-
-
-   public static ICdmDataSource proibiosphere_eupolybothrus_local() {
-       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-       String cdmServer = "localhost";
-       String cdmDB = "cdm_production_proibiosphere_eupolybothrus_pilot";
+       String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
        String cdmUserName = "root";
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
    }
 
-   public static ICdmDataSource proibiosphere_spiders_local() {
+   public static ICdmDataSource cdm_test_pesi_fauna_europaea(){
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-       String cdmServer = "localhost";
-       String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
-       String cdmUserName = "root";
+       String cdmServer = "160.45.63.175";
+       String cdmDB = "cdm_pesi_fauna_europaea";
+       String cdmUserName = "edit";
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
    }
-//     public static ICdmDataSource LAPTOP_HP(){
-//             DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
-//             String cdmServer = "LAPTOPHP";
-//             String cdmDB = "cdmTest";
-//             String cdmUserName = "edit";
-//             return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
-//     }
-
 
 
 
@@ -588,9 +889,9 @@ public class CdmDestinations {
                pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
                ICdmDataSource destination;
                if(dbType.equals(DatabaseTypeEnum.MySQL)){
-                       destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
+                       destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
                } else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
-                       destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
+                       destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
                } else {
                        //TODO others
                        throw new RuntimeException("Unsupported DatabaseType");