fix(TUP-39924): upgrade org.codehaus.plexus:plexus-archiver to 4.8.0, (#6345)

plexus-io to 3.4.1 , maven-assembly-plugin to 3.6.0 and plexus-util to
4.0.0 for incompatibility.

main/plugins/org.talend.common.ui.runtime/src/main/java/org/talend/commons/ui/runtime/image/ECoreImage.java

@@ -115,6 +115,8 @@ public enum ECoreImage implements IImage {
 
     METADATA_SAPCONNECTION_ICON("/icons1/sapconnection.png"), //$NON-NLS-1$
     METADATA_SAPCONNECTION_WIZ("/icons1/connection_wiz.gif"), //$NON-NLS-1$
+    
+    METADATA_BIGQUERYCONNECTION_ICON("/icons1/bigqueryconnection.png"), //$NON-NLS-1$
 
     METADATA_HEADERFOOTER_ICON("/icons1/headerfooter_icon32.png"), //$NON-NLS-1$
 

main/plugins/org.talend.commons.runtime/pom_server.xml

@@ -125,7 +125,7 @@
                  <dependency>
                   <groupId>com.google.guava</groupId>
                   <artifactId>guava</artifactId>
-                  <version>30.0-jre</version>
+                  <version>32.0.1-jre</version>
                  </dependency>
                 </dependencies>
                 <configuration>

main/plugins/org.talend.commons.ui/src/main/java/org/talend/commons/ui/swt/advanced/dataeditor/button/ExportPushButtonForExtendedTable.java

@@ -130,11 +130,10 @@ public abstract class ExportPushButtonForExtendedTable extends ExportPushButton
         AbstractExtendedTableViewer extendedTableViewer = (AbstractExtendedTableViewer) extendedControlViewer;
         ExtendedTableModel extendedTableModel = extendedTableViewer.getExtendedTableModel();
         boolean enabled = false;
-        if (extendedTableModel != null && extendedTableModel.isDataRegistered()
-                && extendedTableModel.getBeansList().size() > 0) {
+        if (extendedTableModel != null && extendedTableModel.isDataRegistered() && extendedTableModel.getBeansList().size() > 0) {
             enabled = true;
         }
-        return super.getEnabledState() && enabled;
+        return extendedTableModel != null || enabled;
     }
 
 }

main/plugins/org.talend.commons.ui/src/main/java/org/talend/commons/ui/swt/advanced/dataeditor/button/SaveAsGenericSchemaPushButton.java

@@ -19,6 +19,7 @@ import org.talend.commons.ui.runtime.image.EImage;
 import org.talend.commons.ui.runtime.image.ImageProvider;
 import org.talend.commons.ui.swt.advanced.dataeditor.control.ExtendedPushButton;
 import org.talend.commons.ui.swt.extended.table.AbstractExtendedTableViewer;
+import org.talend.commons.ui.swt.extended.table.ExtendedTableModel;
 
 /**
  * DOC Administrator class global comment. Detailled comment <br/>
@@ -33,4 +34,11 @@ public abstract class SaveAsGenericSchemaPushButton extends ExtendedPushButton {
 
     @Override
     protected abstract Command getCommandToExecute();
+
+    @Override
+    public boolean getEnabledState() {
+        AbstractExtendedTableViewer extendedTableViewer = (AbstractExtendedTableViewer) extendedControlViewer;
+        ExtendedTableModel extendedTableModel = extendedTableViewer.getExtendedTableModel();
+        return extendedTableModel != null;
+    }
 }

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/i18n/messages.properties

@@ -156,6 +156,7 @@ ProjectRepositoryNode.invalidItem=Invalid item
 ProjectRepositoryNode.columns=Columns
 ProjectRepositoryNode.validationRules=Validation Rules
 ProjectRepositoryNode.cdcFoundation=CDC Foundation
+ProjectRepositoryNode.cdcFoundation.deprecated=CDC Foundation (deprecated)
 ProjectRepositoryNode.genericSchema=Generic schemas
 ProjectRepositoryNode.queries=Queries
 ProjectRepositoryNode.synonymSchemas=Synonym schemas

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/i18n/messages_fr.properties

@@ -175,6 +175,7 @@ ProjectRepositoryNode.sapBWDataStoreObject=Objet Data Store SAP
 ProjectRepositoryNode.sapBWInfoCube=InfoCube SAP
 ProjectRepositoryNode.sapBWInfoObject=InfoObject SAP
 ProjectRepositoryNode.sapContentExtractor=Extracteur SAP BI Content
+ProjectRepositoryNode.sapCDSView=Vue SAP CDS
 RepositoryDropAdapter_copyingItems=Copie des \u00E9l\u00E9ments...
 RepositoryDropAdapter_errorMsg=Ce r\u00E9pertoire contient l'\u00E9l\u00E9ment verrouill\u00E9, il ne peut \u00EAtre d\u00E9plac\u00E9
 RepositoryDropAdapter_lockedByOthers=Cet \u00E9l\u00E9ment est verrouill\u00E9 par d'autres utilisateurs, impossible de le d\u00E9placer.

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/i18n/messages_ja.properties

@@ -156,6 +156,7 @@ ProjectRepositoryNode.invalidItem=\u7121\u52B9\u306A\u30A2\u30A4\u30C6\u30E0
 ProjectRepositoryNode.columns=\u30AB\u30E9\u30E0
 ProjectRepositoryNode.validationRules=\u691C\u8A3C\u30EB\u30FC\u30EB
 ProjectRepositoryNode.cdcFoundation=CDC Foundation
+ProjectRepositoryNode.cdcFoundation.deprecated=CDC Foundation (\u975E\u63A8\u5968)
 ProjectRepositoryNode.genericSchema=\u30B8\u30A7\u30CD\u30EA\u30C3\u30AF\u30B9\u30AD\u30FC\u30DE
 ProjectRepositoryNode.queries=\u30AF\u30A8\u30EA\u30FC
 ProjectRepositoryNode.synonymSchemas=\u30B7\u30CE\u30CB\u30E0\u30B9\u30AD\u30FC\u30DE
@@ -175,6 +176,7 @@ ProjectRepositoryNode.sapBWDataStoreObject=SAP DSO
 ProjectRepositoryNode.sapBWInfoCube=SAP InfoCube
 ProjectRepositoryNode.sapBWInfoObject=SAP InfoObject
 ProjectRepositoryNode.sapContentExtractor=SAP BI\u30B3\u30F3\u30C6\u30F3\u30C4\u30A8\u30AF\u30B9\u30C8\u30E9\u30AF\u30BF\u30FC
+ProjectRepositoryNode.sapCDSView=SAP CDS\u30D3\u30E5\u30FC
 RepositoryDropAdapter_copyingItems=\u30A2\u30A4\u30C6\u30E0\u3092\u30B3\u30D4\u30FC\u4E2D...
 RepositoryDropAdapter_errorMsg=\u30C7\u30A3\u30EC\u30AF\u30C8\u30EA\u30FC\u306B\u30ED\u30C3\u30AF\u3055\u308C\u305F\u30A2\u30A4\u30C6\u30E0\u304C\u542B\u307E\u308C\u3066\u3044\u307E\u3059\u3002\u73FE\u5728\u3001\u79FB\u52D5\u3067\u304D\u307E\u305B\u3093,
 RepositoryDropAdapter_lockedByOthers=\u3053\u306E\u30A2\u30A4\u30C6\u30E0\u304C\u4ED6\u306E\u30E6\u30FC\u30B6\u30FC\u306B\u3088\u3063\u3066\u30ED\u30C3\u30AF\u3055\u308C\u307E\u3057\u305F\u3002\u73FE\u5728\u3001\u79FB\u52D5\u3067\u304D\u307E\u305B\u3093\u3002

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/i18n/messages_zh_CN.properties

@@ -175,6 +175,7 @@ ProjectRepositoryNode.sapBWDataStoreObject=SAP DSO
 ProjectRepositoryNode.sapBWInfoCube=SAP InfoCube
 ProjectRepositoryNode.sapBWInfoObject=SAP InfoObject
 ProjectRepositoryNode.sapContentExtractor=SAP BI \u5185\u5BB9\u63D0\u53D6\u5668
+ProjectRepositoryNode.sapCDSView=SAP CDS \u89C6\u56FE
 RepositoryDropAdapter_copyingItems=\u6B63\u5728\u590D\u5236\u9879\u76EE...
 RepositoryDropAdapter_errorMsg=\u6B64\u76EE\u5F55\u5305\u542B\u9501\u5B9A\u7684\u9879\u76EE\uFF0C\u73B0\u5728\u65E0\u6CD5\u79FB\u52A8
 RepositoryDropAdapter_lockedByOthers=\u6B64\u9879\u76EE\u88AB\u5176\u4ED6\u7528\u6237\u9501\u5B9A\uFF0C\u73B0\u5728\u65E0\u6CD5\u79FB\u52A8\u3002

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/model/AbstractEMFRepositoryFactory.java

@@ -67,7 +67,6 @@ import org.talend.core.model.repository.Folder;
 import org.talend.core.model.repository.IRepositoryViewObject;
 import org.talend.core.model.repository.LockInfo;
 import org.talend.core.model.repository.RepositoryViewObject;
-import org.talend.core.model.routines.RoutinesUtil;
 import org.talend.core.repository.i18n.Messages;
 import org.talend.core.repository.utils.XmiResourceManager;
 import org.talend.core.runtime.CoreRuntimePlugin;
@@ -131,7 +130,7 @@ public abstract class AbstractEMFRepositoryFactory extends AbstractRepositoryFac
                 ERepositoryObjectType.METADATA_FILE_RULES, ERepositoryObjectType.METADATA_FILE_HL7,
                 ERepositoryObjectType.METADATA_FILE_FTP, ERepositoryObjectType.METADATA_FILE_BRMS,
                 ERepositoryObjectType.METADATA_MDMCONNECTION, ERepositoryObjectType.METADATA_HEADER_FOOTER,
-                ERepositoryObjectType.JOB_SCRIPT };
+                ERepositoryObjectType.JOB_SCRIPT, ERepositoryObjectType.METADATA_BIGQUERYCONNECTIONS };
 
         List<IRepositoryViewObject> deletedItems = new ArrayList<IRepositoryViewObject>();
         for (ERepositoryObjectType type : types) {
@@ -874,25 +873,38 @@ public abstract class AbstractEMFRepositoryFactory extends AbstractRepositoryFac
     @Override
     public IRepositoryViewObject getLastVersion(Project project, String id, String relativeFolder, ERepositoryObjectType type)
             throws PersistenceException {
-        List<IRepositoryViewObject> serializableAllVersion = null;
-        Object fullFolder = getFullFolder(project, type, relativeFolder);
-        serializableAllVersion = getSerializableFromFolder(project, fullFolder, id, type, false, false, true, true);
+        List<IRepositoryViewObject> serializableAllVersion = new ArrayList<>();
+        if (lastFolderForItemMap.containsKey(id)) {
+            ERepositoryObjectType itemType = lastRepositoryTypeForItemMap.get(id);
+            String currentPath = lastFolderForItemMap.get(id);
+            Object fullFolder = getFullFolder(project, itemType, currentPath);
+            try {
+                if (fullFolder != null && (fullFolder instanceof FolderItem || ((IFolder) fullFolder).exists())) {
+                    serializableAllVersion.addAll(getSerializableFromFolder(project, fullFolder, id, itemType, false, false, true, true));
+                }
+            } catch (PersistenceException e) {
+                // do nothing.
+                // if any exception happen or can't find the item, just try to look for it everywhere.
+            }
+        }
         if (serializableAllVersion.isEmpty()) {
-            // look in all folders for this item type
-            serializableAllVersion = getSerializableFromFolder(project, fullFolder, id, type, false, true, true, true, true);
+            Object fullFolder = getFullFolder(project, type, relativeFolder);
+            serializableAllVersion = getSerializableFromFolder(project, fullFolder, id, type, false, false, true, true);
+            if (serializableAllVersion.isEmpty()) {
+                // look in all folders for this item type
+                serializableAllVersion = getSerializableFromFolder(project, fullFolder, id, type, false, true, true, true, true);
+            }
         }
         int size = serializableAllVersion.size();
-
         if (size > 1) {
             String message = getItemsMessages(serializableAllVersion, size);
-
             throw new PersistenceException(Messages.getString(
                     "AbstractEMFRepositoryFactory.presistenceException.OnlyOneOccurenceMustbeFound", message)); //$NON-NLS-1$
-        } else if (size == 1) {
-            return serializableAllVersion.get(0);
-        } else {
-            return null;
         }
+        if (size == 1) {
+            return serializableAllVersion.get(0);
+        }
+        return null;
     }
 
     protected void computePropertyMaxInformationLevel(Property property) {

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/model/AbstractRepositoryFactory.java

@@ -184,6 +184,7 @@ public abstract class AbstractRepositoryFactory implements IRepositoryFactory {
         collect(getMetadata(project, ERepositoryObjectType.METADATA_FILE_LDIF), result);
         collect(getMetadata(project, ERepositoryObjectType.METADATA_CONNECTIONS), result);
         collect(getMetadata(project, ERepositoryObjectType.METADATA_SAPCONNECTIONS), result);
+        collect(getMetadata(project, ERepositoryObjectType.METADATA_BIGQUERYCONNECTIONS), result);
         collect(getMetadata(project, ERepositoryObjectType.METADATA_HEADER_FOOTER), result);
         collect(getMetadata(project, ERepositoryObjectType.METADATA_LDAP_SCHEMA), result);
         collect(getMetadata(project, ERepositoryObjectType.METADATA_GENERIC_SCHEMA), result);

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/model/ProjectRepositoryNode.java

@@ -1350,6 +1350,8 @@ public class ProjectRepositoryNode extends RepositoryNode implements IProjectRep
             connection = dbMetadataConnection;
         } else if (type == ERepositoryObjectType.METADATA_SAPCONNECTIONS) {
             connection = ((ConnectionItem) repositoryObject.getProperty().getItem()).getConnection();
+        } else if (type == ERepositoryObjectType.METADATA_BIGQUERYCONNECTIONS) {
+            connection = ((ConnectionItem) repositoryObject.getProperty().getItem()).getConnection();
         } else if (type == ERepositoryObjectType.METADATA_FILE_DELIMITED) {
             connection = ((ConnectionItem) repositoryObject.getProperty().getItem()).getConnection();
         } else if (type == ERepositoryObjectType.METADATA_FILE_POSITIONAL) {
@@ -1701,11 +1703,11 @@ public class ProjectRepositoryNode extends RepositoryNode implements IProjectRep
                 DatabaseConnectionItem connectionItem = (DatabaseConnectionItem) item;
                 DatabaseConnection connection = (DatabaseConnection) connectionItem.getConnection();
                 if (PluginChecker.isCDCPluginLoaded()) {
-                    ICDCProviderService service = GlobalServiceRegister.getDefault()
-                            .getService(ICDCProviderService.class);
+                    ICDCProviderService service = GlobalServiceRegister.getDefault().getService(ICDCProviderService.class);
+
                     if (service != null && service.canCreateCDCConnection(connection)) {
                         RepositoryNode cdcNode = new StableRepositoryNode(node,
-                                Messages.getString("ProjectRepositoryNode.cdcFoundation"), //$NON-NLS-1$
+                                Messages.getString("ProjectRepositoryNode.cdcFoundation.deprecated"), //$NON-NLS-1$
                                 ECoreImage.FOLDER_CLOSE_ICON);
                         node.getChildren().add(cdcNode);
                         service.createCDCTypes(recBinNode, cdcNode, connection.getCdcConns());

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/model/ProxyRepositoryFactory.java

@@ -2207,6 +2207,13 @@ public final class ProxyRepositoryFactory implements IProxyRepositoryFactory {
                     ExceptionHandler.process(e);
                 }
                 
+                if (IHadoopDistributionService.get() != null) {
+                    try {
+                        IHadoopDistributionService.get().checkAndMigrateDistributionProxyCredential(project);
+                    } catch (Exception e) {
+                        ExceptionHandler.process(e);
+                    }
+                }
                 // init dynamic distirbution after `beforeLogon`, before loading libraries.
                 initDynamicDistribution(monitor);
                 

main/plugins/org.talend.core.repository/src/main/java/org/talend/core/repository/ui/actions/DuplicateAction.java

@@ -606,6 +606,8 @@ public class DuplicateAction extends AContextualAction {
                     item = PropertiesFactory.eINSTANCE.createSalesforceSchemaConnectionItem();
                 } else if (repositoryType == ERepositoryObjectType.METADATA_SAPCONNECTIONS) {
                     item = PropertiesFactory.eINSTANCE.createSAPConnectionItem();
+                } else if (repositoryType == ERepositoryObjectType.METADATA_BIGQUERYCONNECTIONS) {
+                    item = PropertiesFactory.eINSTANCE.createBigQueryConnectionItem();
                 } else if (repositoryType == ERepositoryObjectType.METADATA_WSDL_SCHEMA) {
                     item = PropertiesFactory.eINSTANCE.createWSDLSchemaConnectionItem();
                 } else if (repositoryType == ERepositoryObjectType.PROCESS) {

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/PluginChecker.java

@@ -43,6 +43,8 @@ public class PluginChecker {
     private static final String CDC_PLUGIN_ID = "org.talend.designer.cdc"; //$NON-NLS-1$
 
     private static final String SAP_WZIARD_PLUGIN_ID = "org.talend.repository.sap"; //$NON-NLS-1$
+    
+    private static final String BIGQUERY_WZIARD_PLUGIN_ID = "org.talend.repository.bigquery"; //$NON-NLS-1$
 
     private static final String EBCDIC_PLUGIN_ID = "org.talend.repository.ebcdic"; //$NON-NLS-1$
 
@@ -246,6 +248,10 @@ public class PluginChecker {
     public static boolean isSAPWizardPluginLoaded() {
         return isPluginLoaded(SAP_WZIARD_PLUGIN_ID);
     }
+    
+    public static boolean isBigQueryWizardPluginLoaded() {
+        return isPluginLoaded(BIGQUERY_WZIARD_PLUGIN_ID);
+    }
 
     public static boolean isEBCDICPluginLoaded() {
         return isPluginLoaded(EBCDIC_PLUGIN_ID);
@@ -268,7 +274,7 @@ public class PluginChecker {
     }
 
     public static boolean isExchangeSystemLoaded() {
-        return isPluginLoaded(EXCHANGE_SYSTEM_PLUGIN_ID);
+        return false;
     }
 
     public static boolean isRulesPluginLoaded() { // added by hyWang

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/database/EDatabase4DriverClassName.java

@@ -88,8 +88,8 @@ public enum EDatabase4DriverClassName {
     // MOD klliu 2010-06-04 bug 12819: upgrade jdbc driver class used in sql explorer
     TERADATA(EDatabaseTypeName.TERADATA, "com.teradata.jdbc.TeraDriver"), //$NON-NLS-1$
 
-    VERTICA(EDatabaseTypeName.VERTICA, "com.vertica.Driver"), //$NON-NLS-1$
-    VERTICA2(EDatabaseTypeName.VERTICA, "com.vertica.jdbc.Driver"), //$NON-NLS-1$
+//    VERTICA(EDatabaseTypeName.VERTICA, "com.vertica.Driver"), //$NON-NLS-1$
+    VERTICA(EDatabaseTypeName.VERTICA, "com.vertica.jdbc.Driver"), //$NON-NLS-1$
 
     HIVE(EDatabaseTypeName.HIVE, "org.apache.hadoop.hive.jdbc.HiveDriver"), //$NON-NLS-1$
 

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/database/conn/ConnParameterKeys.java

@@ -455,6 +455,9 @@ public class ConnParameterKeys {
     public static final String CONN_PARA_KEY_UNIV_STANDALONE_EXEC_MEMORY="CONN_PARA_KEY_UNIV_STANDALONE_EXEC_MEMORY";
     public static final String CONN_PARA_KEY_UNIV_STANDALONE_EXEC_CORE="CONN_PARA_KEY_UNIV_STANDALONE_EXEC_CORE";
     
+    
+    // Spark Submit Scripts
+    public static final String CONN_PARA_KEY_UNIV_SPARK_SUBMIT_SCRIPT_HOME="CONN_PARA_KEY_UNIV_SPARK_SUBMIT_SCRIPT_HOME";
     /**
      * Redshift
      */

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/database/conn/version/EDatabaseVersion4Drivers.java

@@ -33,7 +33,7 @@ public enum EDatabaseVersion4Drivers {
     ACCESS_2007(new DbVersion4Drivers(EDatabaseTypeName.ACCESS, "Access 2007", "Access_2007")), //$NON-NLS-1$ //$NON-NLS-2$
     // oracle
     ORACLE_18(new DbVersion4Drivers(new EDatabaseTypeName[] { EDatabaseTypeName.ORACLEFORSID, EDatabaseTypeName.ORACLESN,
-            EDatabaseTypeName.ORACLE_OCI, EDatabaseTypeName.ORACLE_CUSTOM }, "Oracle 18 and above", "ORACLE_18", "ojdbc8-19.3.0.0.jar")),
+            EDatabaseTypeName.ORACLE_OCI, EDatabaseTypeName.ORACLE_CUSTOM }, "Oracle 18 and above", "ORACLE_18", "ojdbc8-19.19.0.0.jar")),
     ORACLE_12(new DbVersion4Drivers(new EDatabaseTypeName[] { EDatabaseTypeName.ORACLEFORSID, EDatabaseTypeName.ORACLESN,
             EDatabaseTypeName.ORACLE_OCI, EDatabaseTypeName.ORACLE_CUSTOM }, "Oracle 12 (Deprecated)", "ORACLE_12",
             "ojdbc7.jar")),
@@ -71,7 +71,7 @@ public enum EDatabaseVersion4Drivers {
     // MYSQL, add for 9594
     MYSQL_8(new DbVersion4Drivers(EDatabaseTypeName.MYSQL, "MySQL 8", "MYSQL_8", "mysql-connector-j-8.0.33.jar")), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
     MYSQL_5(new DbVersion4Drivers(EDatabaseTypeName.MYSQL, "MySQL 5", "MYSQL_5", "mysql-connector-java-5.1.49.jar")), //$NON-NLS-1$  //$NON-NLS-2$ //$NON-NLS-3$
-    MARIADB(new DbVersion4Drivers(EDatabaseTypeName.MYSQL, "MariaDB", "MARIADB", "mariadb-java-client-2.5.3.jar")), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
+    MARIADB(new DbVersion4Drivers(EDatabaseTypeName.MYSQL, "MariaDB", "MARIADB", "mariadb-java-client-3.1.4.jar")), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
     // add for 9594
     MSSQL(new DbVersion4Drivers(EDatabaseTypeName.MSSQL,"Open source JTDS", "JTDS", "jtds-1.3.1-patch-20190523.jar")), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
     MSSQL_2012(new DbVersion4Drivers(EDatabaseTypeName.MSSQL,
@@ -81,10 +81,13 @@ public enum EDatabaseVersion4Drivers {
             new String[] { "mssql-jdbc.jar", "slf4j-api-1.7.34.jar", "slf4j-reload4j-1.7.34.jar", "msal4j-1.11.0.jar", //$NON-NLS-1$
                     "oauth2-oidc-sdk-9.7.jar", "reload4j-1.2.22.jar", "jackson-core-2.13.4.jar",
                     "jackson-databind-2.13.4.2.jar", "jackson-annotations-2.13.4.jar", "jcip-annotations-1.0-1.jar",
-                    "json-smart-2.4.9.jar", "nimbus-jose-jwt-9.22.jar", "accessors-smart-2.4.9.jar", "asm-9.5.jar",
+                    "json-smart-2.4.11.jar", "nimbus-jose-jwt-9.22.jar", "accessors-smart-2.4.11.jar", "asm-9.5.jar",
                     "content-type-2.1.jar", "lang-tag-1.5.jar" })),
 
-    VERTICA_9(new DbVersion4Drivers(EDatabaseTypeName.VERTICA, "VERTICA 9.X", "VERTICA_9_0", "vertica-jdbc-9.3.1-0.jar")), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
+//    VERTICA_9(new DbVersion4Drivers(EDatabaseTypeName.VERTICA, "VERTICA 9.X  (Deprecated)", "VERTICA_9_0", "vertica-jdbc-9.3.1-0.jar")), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
+    
+    //https://mvnrepository.com/artifact/com.vertica.jdbc/vertica-jdbc/12.0.4-0
+    VERTICA_12(new DbVersion4Drivers(EDatabaseTypeName.VERTICA, "VERTICA 12.X", "VERTICA_12_0", "vertica-jdbc-12.0.4-0.jar")), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
 
     // for bug 0017930
     GREENPLUM_PSQL(new DbVersion4Drivers(EDatabaseTypeName.GREENPLUM,"PostgreSQL", "POSTGRESQL", "postgresql-8.4-703.jdbc4.jar")), //$NON-NLS-1$

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/hadoop/IHadoopDistributionService.java

@@ -16,6 +16,7 @@ import java.util.Map;
 
 import org.talend.core.GlobalServiceRegister;
 import org.talend.core.IService;
+import org.talend.core.model.general.Project;
 import org.talend.core.runtime.hd.IDistributionsManager;
 import org.talend.core.runtime.hd.IDynamicDistributionManager;
 import org.talend.core.runtime.hd.IHDistribution;
@@ -132,6 +133,8 @@ public interface IHadoopDistributionService extends IService {
 
     IDynamicDistributionManager getDynamicDistributionManager();
 
+    void checkAndMigrateDistributionProxyCredential(Project project) throws Exception;
+
     public static IHadoopDistributionService get() {
         GlobalServiceRegister gsr = GlobalServiceRegister.getDefault();
         if (gsr.isServiceRegistered(IHadoopDistributionService.class)) {

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/hadoop/conf/EHadoopProperties.java

@@ -214,7 +214,9 @@ public enum EHadoopProperties {
     
     UNIV_STANDALONE_EXEC_MEMORY,
     
-    UNIV_STANDALONE_EXEC_CORE;
+    UNIV_STANDALONE_EXEC_CORE,
+    
+    UNIV_SPARK_SUBMIT_SCRIPT_HOME;
 
     public String getName() {
         return this.name();

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/context/ContextUtils.java

@@ -522,10 +522,16 @@ public class ContextUtils {
         return itemMap;
     }
 
+
+    private static Set<String> missingContexts = new HashSet<>();
+
+    public static void clearMissingContextCache() {
+        missingContexts.clear();
+    }
+
     /**
-     *
-     * get the repository context item,now contextId can be either joblet node or context node.
-     */
+    * get the repository context item, now contextId can be either joblet node or context node.
+    */
     public static Item getRepositoryContextItemById(String contextId) {
         if (IContextParameter.BUILT_IN.equals(contextId)) {
             return null;
@@ -533,6 +539,9 @@ public class ContextUtils {
         if (checkObject(contextId)) {
             return null;
         }
+        if (missingContexts.contains(contextId)) {
+            return null;
+        }
 
         List<ERepositoryObjectType> possibleTypes = new ArrayList<ERepositoryObjectType>();
         possibleTypes.add(ERepositoryObjectType.CONTEXT);
@@ -547,6 +556,8 @@ public class ContextUtils {
                     return item;
                 }
             }
+            missingContexts.add(contextId);
+            ExceptionHandler.log("Can't find Context item[id=" + contextId + "].");
         } catch (PersistenceException e) {
             ExceptionHandler.process(e);
         }
@@ -857,6 +868,7 @@ public class ContextUtils {
             ItemContextLink itemContextLink) {
         Map<String, String> renamedMap = new HashMap<String, String>();
         Map<String, Item> tempItemMap = new HashMap<String, Item>();
+        clearMissingContextCache();
         for (ContextType contextType : contextTypeList) {
             for (Object obj : contextType.getContextParameter()) {
                 if (obj instanceof ContextParameterType) {
@@ -919,6 +931,7 @@ public class ContextUtils {
      */
     public static Map<String, String> calculateRenamedMapFromLinkFile(String projectLabel, String itemId,
             List<IContext> contextList) {
+        clearMissingContextCache();
         Map<String, String> renamedMap = new HashMap<String, String>();
         Map<String, Item> idToItemMap = new HashMap<String, Item>();
         try {

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/context/JobContextManager.java

@@ -300,6 +300,7 @@ public class JobContextManager implements IContextManager {
         }
         List<ContextItem> contextItemList = ContextUtils.getAllContextItem();
         boolean setDefault = false;
+        ContextUtils.clearMissingContextCache();
         for (int i = 0; i < contextTypeList.size(); i++) {
             contextType = (ContextType) contextTypeList.get(i);
             String name = contextType.getName();
@@ -529,6 +530,7 @@ public class JobContextManager implements IContextManager {
 
         EList newcontextTypeList = new BasicEList();
         Map<String, Item> idToItemMap = new HashMap<String, Item>();
+        ContextUtils.clearMissingContextCache();
         for (int i = 0; i < listContext.size(); i++) {
             IContext context = listContext.get(i);
             String contextGroupName = renameGroupContext.get(context);

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/context/link/AbstractItemContextLinkService.java

@@ -51,6 +51,7 @@ public abstract class AbstractItemContextLinkService implements IItemContextLink
         itemContextLink.setItemId(itemId);
         Map<String, Item> tempCache = new HashMap<String, Item>();
         if (contextTypeList != null && contextTypeList.size() > 0) {
+            ContextUtils.clearMissingContextCache();
             for (Object object : contextTypeList) {
                 if (object instanceof ContextType) {
                     ContextType jobContextType = (ContextType) object;

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/context/link/ContextLinkService.java

@@ -206,6 +206,7 @@ public class ContextLinkService {
             Map<String, Map<String, String>> changedContextParameterId) throws PersistenceException {
         List<Relation> relationList = RelationshipItemBuilder.getInstance()
                 .getItemsHaveRelationWith(sourceId, RelationshipItemBuilder.LATEST_VERSION, false);
+        ContextUtils.clearMissingContextCache();
         for (Relation relation : relationList) {
             String id = relation.getId();
             IFile linkFile = calContextLinkFile(ProjectManager.getInstance().getCurrentProject().getTechnicalLabel(), id);

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/metadata/MetadataTalendType.java

@@ -463,29 +463,31 @@ public final class MetadataTalendType {
         return list;
     }
 
-    public static URL getSystemFolderURLOfMappingsFile() throws SystemException {
+    public static File getSystemFolderURLOfMappingsFile() throws SystemException {
         String dirPath = "/" + INTERNAL_MAPPINGS_FOLDER; //$NON-NLS-1$
-        URL url = null;
         Path filePath = new Path(dirPath);
         Bundle b = Platform.getBundle(CoreRuntimePlugin.PLUGIN_ID);
         if (b != null) {
             try {
                 // Enumeration<URL> entries = b.findEntries(dirPath, "mapping_*.xml", false);
-                url = FileLocator.toFileURL(FileLocator.find(b, filePath, null));
+                return new File(FileLocator.toFileURL(FileLocator.find(b, filePath, null)).getFile());
             } catch (IOException e) {
                 throw new SystemException(e);
             }
         }
-        return url;
+        return null;
     }
 
-    public static URL getProjectFolderURLOfMappingsFile() throws SystemException {
+    public static File getProjectFolderURLOfMappingsFile() throws SystemException {
         try {
             String dirPath = "/" + INTERNAL_MAPPINGS_FOLDER; //$NON-NLS-1$
             IProject project = ResourceUtils.getProject(ProjectManager.getInstance().getCurrentProject());
             IPath settingPath = new ProjectScope(project).getLocation();
             File mappingFolder = settingPath.append(dirPath).toFile();
-            return mappingFolder.toURI().toURL();
+            if (!mappingFolder.exists()) {
+                mappingFolder.mkdirs();
+            }
+            return mappingFolder;
         } catch (Exception e) {
             throw new SystemException(e);
         }
@@ -592,8 +594,7 @@ public final class MetadataTalendType {
 
     public static JSONObject getRevisionObject() {
         try {
-            File revisonFile = new File(MetadataTalendType.getSystemFolderURLOfMappingsFile().getFile(),
-                    MetadataTalendType.FILE_MAPPING_REVISION);
+            File revisonFile = new File(getSystemFolderURLOfMappingsFile(), FILE_MAPPING_REVISION);
             String jsonStr = new String(Files.readAllBytes(revisonFile.toPath()));
             return new JSONObject(jsonStr);
         } catch (Exception e) {
@@ -605,13 +606,13 @@ public final class MetadataTalendType {
     public static boolean restoreMappingFiles() throws Exception {
         List<File> toDelete = new ArrayList<>();
         JSONObject revision = getRevisionObject();
-        File projectMappingFolder = new File(getProjectFolderURLOfMappingsFile().getFile());
+        File projectMappingFolder = getProjectFolderURLOfMappingsFile();
         if (projectMappingFolder.exists()) {
             File[] projectMappingFiles = projectMappingFolder.listFiles(f -> f.getName().matches(MAPPING_FILE_PATTERN));
             if (projectMappingFiles != null) {
                 for (File file : projectMappingFiles) {
                     if (revision.has(file.getName())) {
-                        String sha1 = MetadataTalendType.getSha1OfFile(file);
+                        String sha1 = getSha1OfFile(file);
                         if (revision.getJSONObject(file.getName()).has(sha1)) {
                             toDelete.add(file);
                         }
@@ -668,9 +669,9 @@ public final class MetadataTalendType {
     }
 
     public static List<File> getWorkingMappingFiles() throws SystemException {
-        File projectMappingFolder = new File(getProjectFolderURLOfMappingsFile().getFile());
+        File projectMappingFolder = getProjectFolderURLOfMappingsFile();
         File[] projectMappingFiles = projectMappingFolder.listFiles(f -> f.getName().matches(MAPPING_FILE_PATTERN));
-        File systemMappingFolder = new File(getSystemFolderURLOfMappingsFile().getFile());
+        File systemMappingFolder = getSystemFolderURLOfMappingsFile();
         File[] systemMappingFiles = systemMappingFolder.listFiles(f -> f.getName().matches(MAPPING_FILE_PATTERN));
         if (projectMappingFiles == null || projectMappingFiles.length == 0) {
             return Arrays.asList(systemMappingFiles);
@@ -686,7 +687,7 @@ public final class MetadataTalendType {
 
     public static String getSha1OfSystemMappingFile(String fileName) {
         try {
-            return getSha1OfFile(new File(getSystemFolderURLOfMappingsFile().getFile(), fileName));
+            return getSha1OfFile(new File(getSystemFolderURLOfMappingsFile(), fileName));
         } catch (SystemException e) {
             ExceptionHandler.process(e);
             return null;

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/metadata/MetadataToolAvroHelper.java

@@ -156,6 +156,7 @@ public final class MetadataToolAvroHelper {
         copyColumnProperties(fb, in);
 
         fb.prop(DiSchemaConstants.TALEND6_LABEL, label);
+        
 
         Object defaultValue = null;
         Expression initialValue = in.getInitialValue();
@@ -369,6 +370,7 @@ public final class MetadataToolAvroHelper {
      */
     private static <T extends PropBuilder<T>> PropBuilder<T> copyColumnProperties(PropBuilder<T> builder,
             org.talend.core.model.metadata.builder.connection.MetadataColumn in) {
+    	
         // Properties common to tables and columns.
         if (in.getId() != null) {
             builder.prop(DiSchemaConstants.TALEND6_ID, in.getId());
@@ -385,6 +387,8 @@ public final class MetadataToolAvroHelper {
                 builder.prop(DiSchemaConstants.TALEND6_IS_READ_ONLY, tv.getValue());
             }else if(DiSchemaConstants.AVRO_TECHNICAL_KEY.equals(additionalTag)){
                 builder.prop(DiSchemaConstants.AVRO_TECHNICAL_KEY, tv.getValue());
+            }else if(DiSchemaConstants.LOGICAL_TIME_TYPE_AS.equals(additionalTag)) {
+            	builder.prop(DiSchemaConstants.LOGICAL_TIME_TYPE_AS, tv.getValue());
             }else if (tv.getValue() != null) {
                 builder.prop(DiSchemaConstants.TALEND6_ADDITIONAL_PROPERTIES + additionalTag, tv.getValue());
             }
@@ -626,6 +630,7 @@ public final class MetadataToolAvroHelper {
         } else if (AvroUtils.isSameType(nonnullable, AvroUtils._float())) {
             col.setTalendType(JavaTypesManager.FLOAT.getId());
         } else if (AvroUtils.isSameType(nonnullable, AvroUtils._int())) {
+        	
             if (logicalType == LogicalTypes.date()) {
                	col.setTalendType(JavaTypesManager.DATE.getId());
                 TaggedValue tv = TaggedValueHelper.createTaggedValue(DiSchemaConstants.TALEND6_COLUMN_DATE_DATE, "true");
@@ -637,6 +642,8 @@ public final class MetadataToolAvroHelper {
           	    String logical_time_type_as = field.getProp(DiSchemaConstants.LOGICAL_TIME_TYPE_AS);
           	    if(DiSchemaConstants.AS_TALEND_DATE.equals(logical_time_type_as)) {
                 	  col.setTalendType(JavaTypesManager.DATE.getId());
+                      TaggedValue tv2 = TaggedValueHelper.createTaggedValue(DiSchemaConstants.LOGICAL_TIME_TYPE_AS, DiSchemaConstants.AS_TALEND_DATE);
+                      col.getTaggedValue().add(tv2);
           	    } else {
           	        col.setTalendType(JavaTypesManager.INTEGER.getId());
           	    }

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/metadata/builder/ConvertionHelper.java

@@ -33,6 +33,7 @@ import org.talend.core.database.EDatabaseTypeName;
 import org.talend.core.database.ERedshiftDriver;
 import org.talend.core.database.conn.ConnParameterKeys;
 import org.talend.core.database.conn.template.EDatabaseConnTemplate;
+import org.talend.core.database.conn.version.EDatabaseVersion4Drivers;
 import org.talend.core.model.metadata.Dbms;
 import org.talend.core.model.metadata.DiSchemaConstants;
 import org.talend.core.model.metadata.IConvertionConstants;
@@ -272,7 +273,7 @@ public final class ConvertionHelper {
 
     }
 
-    private static String getDriverVersionString(DatabaseConnection dbConn) {
+    public static String getDriverVersionString(DatabaseConnection dbConn) {
         String dbVersionString = dbConn.getDbVersionString();
         if (EDatabaseTypeName.REDSHIFT.getDisplayName().equals(dbConn.getDatabaseType())
                 || EDatabaseTypeName.REDSHIFT_SSO.getDisplayName().equals(dbConn.getDatabaseType())) {
@@ -286,6 +287,9 @@ public final class ConvertionHelper {
                 }
             }
         }
+        if (EDatabaseTypeName.VERTICA.getDisplayName().equals(dbConn.getDatabaseType())) {
+            dbVersionString = EDatabaseVersion4Drivers.VERTICA_12.getVersionValue();
+        }
         return dbVersionString;
     }
 

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/metadata/designerproperties/ComponentToRepositoryProperty.java

@@ -36,6 +36,7 @@ import org.talend.core.model.metadata.IMetadataTable;
 import org.talend.core.model.metadata.MetadataTalendType;
 import org.talend.core.model.metadata.builder.ConvertionHelper;
 import org.talend.core.model.metadata.builder.connection.BRMSConnection;
+import org.talend.core.model.metadata.builder.connection.BigQueryConnection;
 import org.talend.core.model.metadata.builder.connection.Connection;
 import org.talend.core.model.metadata.builder.connection.ConnectionFactory;
 import org.talend.core.model.metadata.builder.connection.DatabaseConnection;
@@ -213,6 +214,8 @@ public class ComponentToRepositoryProperty {
             setFileExcelValue((FileExcelConnection) connection, node, param);
         } else if (connection instanceof SAPConnection) {
             setSAPValue((SAPConnection) connection, node, param);
+        } else if (connection instanceof BigQueryConnection) {
+            setBigQueryValue((BigQueryConnection) connection, node, param);
         } else if (connection instanceof SalesforceSchemaConnection) {
             setSalesforceSchema((SalesforceSchemaConnection) connection, node, param);
         } else if (connection instanceof MDMConnection) {
@@ -1793,6 +1796,30 @@ public class ComponentToRepositoryProperty {
             }
         }
     }
+    
+    private static void setBigQueryValue(BigQueryConnection connection, INode node, IElementParameter param) {
+        if ("SERVICE_ACCOUNT_CREDENTIALS_FILE".equals(param.getRepositoryValue())) {
+            String value = getParameterValue(connection, node, param);
+            if (value != null) {
+                connection.setServiceAccountCredentialsFile(value);
+            }
+        } else if ("PROJECT_ID".equals(param.getRepositoryValue())) {
+            String value = getParameterValue(connection, node, param);
+            if (value != null) {
+                connection.setProjectId(value);
+            }
+        } else if ("USE_REGION_ENDPOINT".equals(param.getRepositoryValue())) {
+            String value = getParameterValue(connection, node, param);
+            if (value != null) {
+                connection.setUseRegionEndpoint(Boolean.valueOf(value));
+            }
+        } else if ("REGION_ENDPOINT_BQ".equals(param.getRepositoryValue())) {
+            String value = getParameterValue(connection, node, param);
+            if (value != null) {
+                connection.setRegionEndpoint(value);
+            }
+        }
+    }
 
     /**
      *

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/metadata/designerproperties/RepositoryToComponentProperty.java

@@ -20,6 +20,7 @@ import java.util.Iterator;
 import java.util.List;
 import java.util.Map;
 import java.util.Set;
+import java.util.stream.Collectors;
 
 import org.apache.commons.lang3.StringUtils;
 import org.eclipse.core.runtime.Path;
@@ -47,6 +48,7 @@ import org.talend.core.model.metadata.MultiSchemasUtil;
 import org.talend.core.model.metadata.builder.ConvertionHelper;
 import org.talend.core.model.metadata.builder.connection.AdditionalConnectionProperty;
 import org.talend.core.model.metadata.builder.connection.BRMSConnection;
+import org.talend.core.model.metadata.builder.connection.BigQueryConnection;
 import org.talend.core.model.metadata.builder.connection.Concept;
 import org.talend.core.model.metadata.builder.connection.ConceptTarget;
 import org.talend.core.model.metadata.builder.connection.Connection;
@@ -148,6 +150,10 @@ public class RepositoryToComponentProperty {
         if (connection instanceof SAPConnection) {
             return getSAPValue((SAPConnection) connection, value);
         }
+        
+        if (connection instanceof BigQueryConnection) {
+            return getBigQueryValue((BigQueryConnection) connection, value, table);
+        }
 
         if (connection instanceof SalesforceSchemaConnection) {
             return getSalesforceSchemaValue((SalesforceSchemaConnection) connection, value, table);
@@ -456,6 +462,62 @@ public class RepositoryToComponentProperty {
         }
         return null;
     }
+    
+    public static Object getBigQueryValue(BigQueryConnection connection, String value, IMetadataTable table) {
+        if ("SERVICE_ACCOUNT_CREDENTIALS_FILE".equals(value)) {
+            if (isContextMode(connection, connection.getServiceAccountCredentialsFile())) {
+                return connection.getServiceAccountCredentialsFile();
+            } else {
+                return TalendQuoteUtils.addQuotes(connection.getServiceAccountCredentialsFile());
+            }
+        } else if ("PROJECT_ID".equals(value)) {
+            if (isContextMode(connection, connection.getProjectId())) {
+                return connection.getProjectId();
+            } else {
+                return TalendQuoteUtils.addQuotes(connection.getProjectId());
+            }
+        } else if ("USE_REGION_ENDPOINT".equals(value)) {
+            return connection.isUseRegionEndpoint();
+        } else if ("REGION_ENDPOINT_BQ".equals(value)) {
+            if (isContextMode(connection, connection.getRegionEndpoint())) {
+                return connection.getRegionEndpoint();
+            } else {
+                return TalendQuoteUtils.addQuotes(connection.getRegionEndpoint());
+            }
+        } else if ("DATASET".equals(value)) {
+            if(table!=null) {
+                Map<String, String> properties = table.getAdditionalProperties();
+                if(properties!=null) {
+                    String dataSet = properties.get("dataSet");
+                    if (isContextMode(connection, dataSet)) {
+                        return dataSet;
+                    } else {
+                        return TalendQuoteUtils.addQuotes(dataSet);
+                    }
+                }
+            }
+        } else if ("QUERY".equals(value)) {
+            if(table!=null) {
+                Map<String, String> properties = table.getAdditionalProperties();
+                if(properties!=null) {
+                    String dataSet = properties.get("dataSet");
+                    String tableName = table.getLabel();
+                    if(dataSet!=null && tableName!=null) {
+                        List<IMetadataColumn> columns = table.getListColumns();
+                        StringBuilder strBuilder = new StringBuilder();
+                        strBuilder.append("SELECT");
+                        if(columns!=null) {
+                            strBuilder.append(columns.stream().map(column -> column.getOriginalDbColumnName()).collect(Collectors.joining(",", " ", " ")));
+                        }
+                        strBuilder.append("FROM ").append(dataSet).append('.').append(tableName);
+                        return TalendQuoteUtils.addQuotes(strBuilder.toString());
+                    }
+                }
+            }
+        }
+        
+        return null;
+    }
 
     /**
      * DOC gcui Comment method "getHL7Value".

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/repository/ERepositoryObjectType.java

@@ -31,6 +31,7 @@ import org.talend.core.IESBService;
 import org.talend.core.PluginChecker;
 import org.talend.core.model.general.Project;
 import org.talend.core.model.properties.BRMSConnectionItem;
+import org.talend.core.model.properties.BigQueryConnectionItem;
 import org.talend.core.model.properties.CSVFileConnectionItem;
 import org.talend.core.model.properties.ConnectionItem;
 import org.talend.core.model.properties.ContextItem;
@@ -360,10 +361,10 @@ public class ERepositoryObjectType extends DynaEnum<ERepositoryObjectType> {
 
     public final static ERepositoryObjectType METADATA_SAP_TABLE = new ERepositoryObjectType("repository.SAPTable", //$NON-NLS-1$
             "METADATA_SAP_TABLE", 104, true, true, new String[] { PROD_DI }, new String[] {}, false);
-
+    
     public final static ERepositoryObjectType METADATA_SAP_CONTENT_EXTRACTOR = new ERepositoryObjectType("repository.SAPTable", //$NON-NLS-1$
             "METADATA_SAP_CONTENT_EXTRACTOR", 105, true, true, new String[] { PROD_DI }, new String[] {}, false);
-
+    
     public final static ERepositoryObjectType METADATA_CON_CALCULATION_VIEW = new ERepositoryObjectType(
             "repository.metadataCalculationView", "METADATA_CON_CALCULATION_VIEW", 106, true, true, new String[] { PROD_DI },
             new String[] {}, false);
@@ -508,6 +509,8 @@ public class ERepositoryObjectType extends DynaEnum<ERepositoryObjectType> {
     public final static ERepositoryObjectType METADATA_FILE_FTP = ERepositoryObjectType.valueOf("METADATA_FILE_FTP");
 
     public final static ERepositoryObjectType METADATA_SAPCONNECTIONS = ERepositoryObjectType.valueOf("METADATA_SAPCONNECTIONS");
+    
+    public final static ERepositoryObjectType METADATA_BIGQUERYCONNECTIONS = ERepositoryObjectType.valueOf("METADATA_BIGQUERYCONNECTIONS");
 
     public final static ERepositoryObjectType METADATA_FILE_EBCDIC = ERepositoryObjectType.valueOf("METADATA_FILE_EBCDIC");
 
@@ -868,6 +871,8 @@ public class ERepositoryObjectType extends DynaEnum<ERepositoryObjectType> {
             return "DB connection"; //$NON-NLS-1$
         } else if (type == METADATA_SAPCONNECTIONS) {
             return "SAPconnection"; //$NON-NLS-1$
+        } else if (type == METADATA_BIGQUERYCONNECTIONS) {
+            return "BigQueryconnection"; //$NON-NLS-1$
         } else if (type == METADATA_FILE_EBCDIC) {
             return "fileEBCDIC"; //$NON-NLS-1$
         } else if (type == METADATA_FILE_HL7) {
@@ -1079,6 +1084,11 @@ public class ERepositoryObjectType extends DynaEnum<ERepositoryObjectType> {
             public Object caseSAPConnectionItem(SAPConnectionItem object) {
                 return METADATA_SAPCONNECTIONS;
             }
+            
+            @Override
+            public Object caseBigQueryConnectionItem(BigQueryConnectionItem object) {
+                return METADATA_BIGQUERYCONNECTIONS;
+            }
 
             @Override
             public Object caseDelimitedFileConnectionItem(DelimitedFileConnectionItem object) {

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/update/RepositoryUpdateManager.java

@@ -770,6 +770,15 @@ public abstract class RepositoryUpdateManager {
                 updateConnectionContextParam((ConnectionItem) item, citem, valueMap);
             }
         }
+        
+        List<IRepositoryViewObject> bigqueryConnList = FACTORY.getAll(ERepositoryObjectType.METADATA_BIGQUERYCONNECTIONS, true);
+        for (IRepositoryViewObject obj : bigqueryConnList) {
+            Item item = obj.getProperty().getItem();
+            if (item instanceof ConnectionItem) {
+                updateConnectionContextParam((ConnectionItem) item, citem, valueMap);
+            }
+        }
+        
         for (String updateType : UpdateRepositoryHelper.getAllHadoopConnectionTypes()) {
             List<IRepositoryViewObject> hadoopConnList = FACTORY
                     .getAll(ERepositoryObjectType.valueOf(ERepositoryObjectType.class, updateType), true);

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/model/utils/TalendPropertiesUtil.java

@@ -35,7 +35,7 @@ public final class TalendPropertiesUtil {
      * @return
      */
     public static boolean isHideExchange() {
-        return isEnabled("talend.hide.exchange") || isEnabled("talend.disable.internet"); //$NON-NLS-1$ //$NON-NLS-2$
+        return true; //$NON-NLS-1$ //$NON-NLS-2$
     }
 
     /**

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/nexus/TalendLibsServerManager.java

@@ -12,7 +12,9 @@
 // ============================================================================
 package org.talend.core.nexus;
 
+import java.net.URLEncoder;
 import java.util.Date;
+import java.util.Map;
 
 import org.apache.commons.lang.StringUtils;
 import org.talend.commons.exception.ExceptionHandler;
@@ -25,9 +27,9 @@ import org.talend.core.runtime.CoreRuntimePlugin;
 import org.talend.core.runtime.i18n.Messages;
 import org.talend.core.runtime.projectsetting.ProjectPreferenceManager;
 import org.talend.core.service.IRemoteService;
+import org.talend.core.utils.SecurityStorageUtil;
 import org.talend.repository.model.IProxyRepositoryFactory;
 import org.talend.repository.model.RepositoryConstants;
-import org.talend.utils.security.StudioEncryption;
 
 /**
  * created by wchen on 2015年6月16日 Detailled comment
@@ -81,6 +83,8 @@ public class TalendLibsServerManager {
 
     public static final String ENABLE_PROXY_SETTING = "nexus.proxy.enable";
 
+    public static final String NEXUS_PROXY_STORAGE_CATEGORY = "org.talend.artifact.proxy.setting";
+
     public static final String TALEND_LIB_USER = "";//$NON-NLS-1$
 
     public static final String TALEND_LIB_PASSWORD = "";//$NON-NLS-1$
@@ -255,10 +259,14 @@ public class TalendLibsServerManager {
             boolean enableProxyFlag = prefManager.getBoolean(TalendLibsServerManager.ENABLE_PROXY_SETTING);
             if (enableProxyFlag) {
                 serverBean.setServer(prefManager.getValue(TalendLibsServerManager.NEXUS_PROXY_URL));
-                serverBean.setUserName(prefManager.getValue(TalendLibsServerManager.NEXUS_PROXY_USERNAME));
-                serverBean.setPassword(StudioEncryption.getStudioEncryption(StudioEncryption.EncryptionKeyName.SYSTEM).decrypt(prefManager.getValue(TalendLibsServerManager.NEXUS_PROXY_PASSWORD)));
                 serverBean.setRepositoryId(prefManager.getValue(TalendLibsServerManager.NEXUS_PROXY_REPOSITORY_ID));
                 serverBean.setType(prefManager.getValue(TalendLibsServerManager.NEXUS_PROXY_TYPE));
+                String[] credentials = getProxyArtifactCredentials(serverBean.getServer(), serverBean.getRepositoryId(),
+                        NEXUS_PROXY_USERNAME, NEXUS_PROXY_PASSWORD);
+                if (credentials != null) {
+                    serverBean.setUserName(credentials[0]);
+                    serverBean.setPassword(credentials[1]);
+                }
             }
         }
         if (StringUtils.isNotEmpty(serverBean.getServer())) {
@@ -267,6 +275,89 @@ public class TalendLibsServerManager {
         return null;
     }
 
+    public String[] getProxyArtifactCredentials(String url, String repositoryId, String usernameKey, String passwordKey) {
+        if (StringUtils.isBlank(url)) {
+            return null;
+        }
+        try {
+            String path = getStoragePath(url, repositoryId);
+            Map<String, String> storageNodePairs = SecurityStorageUtil.getSecurityStorageNodePairs(path);
+            if (storageNodePairs != null) {
+                String username = storageNodePairs.get(usernameKey);
+                String password = storageNodePairs.get(passwordKey);
+                if (username == null && password == null) {
+                    return null;
+                }
+                return new String[] { username, password };
+            }
+        } catch (Exception e) {
+            ExceptionHandler.process(e);
+        }
+        return null;
+    }
+
+    public void saveProxyArtifactCredentials(String url, String repositoryId, String usernameKey, String username,
+            String passwordKey, String password) {
+        if (StringUtils.isBlank(url)) {
+            return;
+        }
+        try {
+            String path = getStoragePath(url, repositoryId);
+            SecurityStorageUtil.saveToSecurityStorage(path, usernameKey, username, false, false);
+            SecurityStorageUtil.saveToSecurityStorage(path, passwordKey, password, true, false);
+            SecurityStorageUtil.flushSecurityStorage();
+        } catch (Exception e) {
+            ExceptionHandler.process(e);
+        }
+    }
+
+    public void saveProxyArtifactCredentialsUserName(String url, String repositoryId, String usernameKey, String username,
+            boolean flush) {
+        if (StringUtils.isBlank(url)) {
+            return;
+        }
+        try {
+            String path = getStoragePath(url, repositoryId);
+            SecurityStorageUtil.saveToSecurityStorage(path, usernameKey, username, false, flush);
+        } catch (Exception e) {
+            ExceptionHandler.process(e);
+        }
+    }
+
+    public void saveProxyArtifactCredentialsPassword(String url, String repositoryId, String passwordKey, String password,
+            boolean flush) {
+        if (StringUtils.isBlank(url)) {
+            return;
+        }
+        try {
+            String path = getStoragePath(url, repositoryId);
+            SecurityStorageUtil.saveToSecurityStorage(path, passwordKey, password, true, flush);
+        } catch (Exception e) {
+            ExceptionHandler.process(e);
+        }
+    }
+
+    public void flushSecurityStorage() {
+        try {
+            SecurityStorageUtil.flushSecurityStorage();
+        } catch (Exception e) {
+            ExceptionHandler.process(e);
+        }
+    }
+
+    private String getStoragePath(String url, String repositoryId) throws Exception {
+        String node = url;
+        if (StringUtils.isNotBlank(repositoryId)) {
+            if (!url.endsWith("/")) {
+                node = node + "/";
+            }
+            node = node + repositoryId;
+        }
+        node = URLEncoder.encode(node, "UTF-8");
+        String path = NEXUS_PROXY_STORAGE_CATEGORY + "/" + node;
+        return path;
+    }
+
     public ArtifactRepositoryBean getTalentArtifactServer() {
         ArtifactRepositoryBean serverBean = getProxyArtifactServer();
         if (serverBean == null) {

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/service/IBigQueryProviderService.java

@@ -0,0 +1,31 @@
+// ============================================================================
+//
+// Copyright (C) 2006-2023 Talend Inc. - www.talend.com
+//
+// This source code is available under agreement available at
+// %InstallDIR%\features\org.talend.rcp.branding.%PRODUCTNAME%\%PRODUCTNAME%license.txt
+//
+// You should have received a copy of the agreement
+// along with this program; if not, write to Talend SA
+// 9 rue Pages 92150 Suresnes, France
+//
+// ============================================================================
+package org.talend.core.service;
+
+import java.util.Map;
+
+import org.talend.core.IProviderService;
+import org.talend.core.model.process.INode;
+import org.talend.core.model.properties.BigQueryConnectionItem;
+import org.talend.repository.model.RepositoryNode;
+
+public interface IBigQueryProviderService extends IProviderService {
+
+    public BigQueryConnectionItem getRepositoryItem(final INode node);
+
+    public boolean isBigQueryNode(final INode node);
+
+    public boolean isBigQueryNode(final RepositoryNode node);
+
+    public boolean isRepositorySchemaLine(INode node, Map<String, Object> lineValue);
+}

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/service/IStudioLiteP2Service.java

@@ -39,6 +39,8 @@ import org.talend.core.model.update.IStudioUpdateConfig;
  */
 public interface IStudioLiteP2Service extends IService {
 
+    public static final String PROP_CLEARPERSISTEDSTATE = "talend.studio.switchProject.clearPersistedState";
+
     public static final String CONFIG_STORAGE_FOLDER = "talend/studioLite/";
 
     public static final String BUNDLES_INFOS_STORAGE_FOLDER = CONFIG_STORAGE_FOLDER + "bundlesInfo/";

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/ui/images/RepositoryImageProvider.java

@@ -53,6 +53,8 @@ public class RepositoryImageProvider {
             return ECoreImage.METADATA_CONNECTION_ICON;
         } else if (type == ERepositoryObjectType.METADATA_SAPCONNECTIONS || type == ERepositoryObjectType.METADATA_SAP_FUNCTION) {
             return ECoreImage.METADATA_SAPCONNECTION_ICON;
+        } else if (type == ERepositoryObjectType.METADATA_BIGQUERYCONNECTIONS) {
+            return ECoreImage.METADATA_BIGQUERYCONNECTION_ICON;
         } else if (type == ERepositoryObjectType.SQLPATTERNS) {
             return ECoreImage.METADATA_SQLPATTERN_ICON;
         } else if (type == ERepositoryObjectType.METADATA_CON_TABLE || type == ERepositoryObjectType.METADATA_SAP_IDOC) {

main/plugins/org.talend.core.runtime/src/main/java/org/talend/core/utils/SecurityStorageUtil.java

@@ -0,0 +1,67 @@
+// ============================================================================
+//
+// Copyright (C) 2006-2023 Talend Inc. - www.talend.com
+//
+// This source code is available under agreement available at
+// %InstallDIR%\features\org.talend.rcp.branding.%PRODUCTNAME%\%PRODUCTNAME%license.txt
+//
+// You should have received a copy of the agreement
+// along with this program; if not, write to Talend SA
+// 9 rue Pages 92150 Suresnes, France
+//
+// ============================================================================
+package org.talend.core.utils;
+
+import java.util.HashMap;
+import java.util.Map;
+
+import org.eclipse.equinox.security.storage.ISecurePreferences;
+import org.eclipse.equinox.security.storage.SecurePreferencesFactory;
+
+/**
+ * DOC jding  class global comment. Detailled comment
+ */
+public class SecurityStorageUtil {
+
+    public static void saveToSecurityStorage(String pathName, String key, String value, boolean encrypt) throws Exception {
+        saveToSecurityStorage(pathName, key, value, encrypt, true);
+    }
+
+    public static void saveToSecurityStorage(String pathName, String key, String value, boolean encrypt, boolean flush)
+            throws Exception {
+        ISecurePreferences securePreferences = SecurePreferencesFactory.getDefault();
+        ISecurePreferences node = securePreferences.node(pathName);
+        node.put(key, value, encrypt);
+        if (flush) {
+            securePreferences.flush();
+        }
+    }
+
+    public static void flushSecurityStorage() throws Exception {
+        ISecurePreferences securePreferences = SecurePreferencesFactory.getDefault();
+        securePreferences.flush();
+    }
+
+    public static String getValueFromSecurityStorage(String pathName, String key) throws Exception {
+        ISecurePreferences securePreferences = SecurePreferencesFactory.getDefault();
+        if (!securePreferences.nodeExists(pathName)) {
+            return null;
+        }
+        ISecurePreferences node = securePreferences.node(pathName);
+        return node.get(key, null);
+    }
+
+    public static Map<String, String> getSecurityStorageNodePairs(String pathName) throws Exception {
+        ISecurePreferences securePreferences = SecurePreferencesFactory.getDefault();
+        if (!securePreferences.nodeExists(pathName)) {
+            return null;
+        }
+        Map<String, String> keyValuePair = new HashMap<String, String>();
+        ISecurePreferences node = securePreferences.node(pathName);
+        for (String key : node.keys()) {
+            keyValuePair.put(key, node.get(key, null));
+        }
+        return keyValuePair;
+    }
+
+}

main/plugins/org.talend.core.runtime/src/main/java/org/talend/designer/rowgenerator/data/FunctionManager.java

@@ -37,8 +37,6 @@ public class FunctionManager {
 
     public static final String PURE_PERL_DESC = Messages.getString("FunctionManager.PurePerl.Desc"); //$NON-NLS-1$
 
-    public static final String PURE_PERL_PARAM = Messages.getString("FunctionManager.PurePerl.ParaName"); //$NON-NLS-1$
-
     private List<TalendType> talendTypes = null;
 
     public static final String PERL_FUN_PREFIX = "sub{"; //$NON-NLS-1$
@@ -55,6 +53,37 @@ public class FunctionManager {
 
     public static final String EMPTY_STRING = " "; //$NON-NLS-1$
 
+    public static enum EFunctionParameter {
+
+        CUSTOMIZE_PARAM("customize parameter", Messages.getString("FunctionManager.PurePerl.ParaName")); //$NON-NLS-1$ //$NON-NLS-2$
+
+        private String paramName;
+
+        private String paramDisplayName;
+
+        EFunctionParameter(String paramName, String paramDisplayName) {
+            this.paramName = paramName;
+            this.paramDisplayName = paramDisplayName;
+        }
+
+        public String getParamName() {
+            return paramName;
+        }
+
+        public String getParamDisplayName() {
+            return paramDisplayName;
+        }
+
+        public static String getDisplayNameByName(String name) {
+            for (EFunctionParameter eParameter : values()) {
+                if (eParameter.getParamName().equals(name)) {
+                    return eParameter.getParamDisplayName();
+                }
+            }
+            return null;
+        }
+
+    }
     /**
      * qzhang Comment method "getFunctionByName".
      *
@@ -80,7 +109,7 @@ public class FunctionManager {
         function.setDescription(PURE_PERL_DESC);
         StringParameter param = new StringParameter();
         List<Parameter> params = new ArrayList<Parameter>();
-        param.setName(PURE_PERL_PARAM);
+        param.setName(EFunctionParameter.CUSTOMIZE_PARAM.getParamName());
         params.add(param);
         function.setParameters(params);
         return function;

main/plugins/org.talend.core.runtime/src/main/java/org/talend/designer/rowgenerator/data/RoutineJarsFunctionParser.java

@@ -86,43 +86,47 @@ public class RoutineJarsFunctionParser extends AbstractTalendFunctionParser {
             Set<RoutinesParameterType> rps = new HashSet<RoutinesParameterType>();
             if (processItem instanceof ProcessItem) {
                 ProcessType pt = ((ProcessItem) processItem).getProcess();
+                if (pt != null) {
+                    if (pt.getParameters() != null) {
+                        rps.addAll(pt.getParameters().getRoutinesParameter());
+                    }
+                    // if it is test process
+                    int pidFeature = TalendFilePackage.PROCESS_TYPE_FEATURE_COUNT + 2;
+                    int versionFeature = TalendFilePackage.PROCESS_TYPE_FEATURE_COUNT + 4;
+                    ProcessTypeImpl pi = (ProcessTypeImpl) pt;
+                    if (pi.eClass() != null && StringUtils.equals(pi.eClass().getName(), "TestContainer")) {
 
-                rps.addAll(pt.getParameters().getRoutinesParameter());
-
-                // if it is test process
-                int pidFeature = TalendFilePackage.PROCESS_TYPE_FEATURE_COUNT + 2;
-                int versionFeature = TalendFilePackage.PROCESS_TYPE_FEATURE_COUNT + 4;
-                ProcessTypeImpl pi = (ProcessTypeImpl) pt;
-                if (pi.eClass() != null && StringUtils.equals(pi.eClass().getName(), "TestContainer")) {
-
-                    try {
-                        Object pid = pi.eGet(pidFeature, true, false);
-                        Object version = pi.eGet(versionFeature, true, false);
-                        if (pid != null) {
-                            IProxyRepositoryService svc = IProxyRepositoryService.get();
-                            try {
-                                List<IRepositoryViewObject> vos = svc.getProxyRepositoryFactory().getAllVersion(pid.toString());
-                                for (IRepositoryViewObject vo : vos) {
-                                    if (StringUtils.equals(vo.getVersion(), String.valueOf(version))) {
-                                        Item parentProcessItem = vo.getProperty().getItem();
-                                        if (parentProcessItem instanceof ProcessItem) {
-                                            pt = ((ProcessItem) parentProcessItem).getProcess();
-                                            rps.addAll(pt.getParameters().getRoutinesParameter());
+                        try {
+                            Object pid = pi.eGet(pidFeature, true, false);
+                            Object version = pi.eGet(versionFeature, true, false);
+                            if (pid != null) {
+                                IProxyRepositoryService svc = IProxyRepositoryService.get();
+                                try {
+                                    List<IRepositoryViewObject> vos = svc.getProxyRepositoryFactory().getAllVersion(pid.toString());
+                                    for (IRepositoryViewObject vo : vos) {
+                                        if (StringUtils.equals(vo.getVersion(), String.valueOf(version))) {
+                                            Item parentProcessItem = vo.getProperty().getItem();
+                                            if (parentProcessItem instanceof ProcessItem) {
+                                                pt = ((ProcessItem) parentProcessItem).getProcess();
+                                                rps.addAll(pt.getParameters().getRoutinesParameter());
+                                            }
                                         }
                                     }
+                                } catch (PersistenceException e) {
+                                    // ignore
                                 }
-                            } catch (PersistenceException e) {
-                                // ignore
                             }
+                        } catch (Exception e) {
+                            // ignore
                         }
-                    } catch (Exception e) {
-                        // ignore
                     }
                 }
 
             } else if (processItem instanceof JobletProcessItem) {
                 ProcessType pt = ((JobletProcessItem) processItem).getJobletProcess();
-                rps.addAll(pt.getParameters().getRoutinesParameter());
+                if (pt != null && pt.getParameters() != null) {
+                    rps.addAll(pt.getParameters().getRoutinesParameter());
+                }
             }
 
             if (!rps.isEmpty()) {

main/plugins/org.talend.core.runtime/src/main/java/org/talend/repository/model/RepositoryNodeUtilities.java

@@ -512,6 +512,7 @@ public class RepositoryNodeUtilities {
                     || curType == ERepositoryObjectType.METADATA_FILE_RULES
                     || curType == ERepositoryObjectType.METADATA_FILE_LINKRULES
                     || curType == ERepositoryObjectType.METADATA_SAPCONNECTIONS
+                    || curType == ERepositoryObjectType.METADATA_BIGQUERYCONNECTIONS
                     || curType == ERepositoryObjectType.METADATA_HEADER_FOOTER) {
                 tmpType = ERepositoryObjectType.METADATA;
             } else if (curType == ERepositoryObjectType.ROUTINES || curType == ERepositoryObjectType.SNIPPETS) {

main/plugins/org.talend.core.runtime/src/main/java/org/talend/repository/ui/properties/StatusHelper.java

@@ -77,6 +77,7 @@ public class StatusHelper {
             case PropertiesPackage.CSV_FILE_CONNECTION_ITEM:
             case PropertiesPackage.DATABASE_CONNECTION_ITEM:
             case PropertiesPackage.SAP_CONNECTION_ITEM:
+            case PropertiesPackage.BIG_QUERY_CONNECTION_ITEM:
             case PropertiesPackage.DELIMITED_FILE_CONNECTION_ITEM:
             case PropertiesPackage.POSITIONAL_FILE_CONNECTION_ITEM:
             case PropertiesPackage.CONTEXT_ITEM:

main/plugins/org.talend.core.ui/src/main/java/org/talend/core/ui/context/ContextNebulaGridComposite.java

@@ -648,6 +648,7 @@ public class ContextNebulaGridComposite extends AbstractContextTabEditComposite
             helper.initHelper(contextManager);
             Map<String, Item> items = new HashMap<String, Item>();
             boolean needRefresh = false;
+            ContextUtils.clearMissingContextCache();
             for (IContextParameter param : contextManager.getDefaultContext().getContextParameterList()) {
                 if (!param.isBuiltIn()) {
                     String source = param.getSource();

main/plugins/org.talend.core.ui/src/main/java/org/talend/core/ui/context/SelectRepositoryContextDialog.java

@@ -522,6 +522,7 @@ public class SelectRepositoryContextDialog extends SelectionDialog {
             // remove the params which is unchecked
             Set<String> jobletIds = new HashSet<String>();
             Set<String> chekedIds = new HashSet<String>();
+            ContextUtils.clearMissingContextCache();
             for (IContextParameter param : existParas) {
                 if (param.isBuiltIn()) {
                     continue;

main/plugins/org.talend.core.ui/src/main/java/org/talend/core/ui/context/cmd/AddRepositoryContextGroupCommand.java

@@ -184,6 +184,7 @@ public class AddRepositoryContextGroupCommand extends Command {
         // remove the params which is unchecked
         Set<String> nonContextIds = new HashSet<String>();
         Set<String> chekedIds = new HashSet<String>();
+        ContextUtils.clearMissingContextCache();
         for (IContextParameter param : existParas) {
             if (param.isBuiltIn()) {
                 continue;

main/plugins/org.talend.core.ui/src/main/java/org/talend/core/ui/context/nattableTree/ContextNatTableUtils.java

@@ -92,6 +92,7 @@ public class ContextNatTableUtils {
         List<ContextTableTabParentModel> output = new ArrayList<ContextTableTabParentModel>();
         if (!contextDatas.isEmpty()) {
             int i = 0;
+            ContextUtils.clearMissingContextCache();
             for (IContextParameter para : contextDatas) {
                 String sourceId = para.getSource();
                 if (IContextParameter.BUILT_IN.equals(sourceId)) {

main/plugins/org.talend.core.ui/src/main/java/org/talend/core/ui/context/nattableTree/ExtendedContextColumnPropertyAccessor.java

@@ -411,6 +411,7 @@ public class ExtendedContextColumnPropertyAccessor<R> implements IColumnProperty
 
             if (modified) {
                 updateRelation();
+                modelManager.refresh();
             }
         }
 
@@ -425,7 +426,6 @@ public class ExtendedContextColumnPropertyAccessor<R> implements IColumnProperty
                             && jobContextManager.isOriginalParameter(param.getName())) {
                         jobContextManager.setModified(true);
                         manager.fireContextsChangedEvent();
-                        modelManager.refresh();
                     }
                 }
             }
@@ -494,6 +494,7 @@ public class ExtendedContextColumnPropertyAccessor<R> implements IColumnProperty
             }
             if (modified) {
                 updateRelation();
+                modelManager.refresh();
             }
         }
 
@@ -508,7 +509,6 @@ public class ExtendedContextColumnPropertyAccessor<R> implements IColumnProperty
                             && jobContextManager.isOriginalParameter(param.getName())) {
                         jobContextManager.setModified(true);
                         manager.fireContextsChangedEvent();
-                        modelManager.refresh();
                     }
                 }
             }
@@ -576,6 +576,7 @@ public class ExtendedContextColumnPropertyAccessor<R> implements IColumnProperty
             }
             if (modified) {
                 updateRelation();
+                modelManager.refresh();
             }
         }
 
@@ -590,7 +591,6 @@ public class ExtendedContextColumnPropertyAccessor<R> implements IColumnProperty
                             && jobContextManager.isOriginalParameter(param.getName())) {
                         jobContextManager.setModified(true);
                         manager.fireContextsChangedEvent();
-                        modelManager.refresh();
                     }
                 }
             }
@@ -673,6 +673,7 @@ public class ExtendedContextColumnPropertyAccessor<R> implements IColumnProperty
             if (modified) {
                 // it is undo, so the order changed
                 updateRelation(newName, originalName);
+                modelManager.refresh();
             }
         }
 
@@ -687,7 +688,6 @@ public class ExtendedContextColumnPropertyAccessor<R> implements IColumnProperty
                             && jobContextManager.isOriginalParameter(param.getName())) {
                         jobContextManager.setModified(true);
                         manager.fireContextsChangedEvent();
-                        modelManager.refresh();
                     }
                 }
             }

main/plugins/org.talend.core.ui/src/main/java/org/talend/core/ui/context/view/Contexts.java

@@ -21,6 +21,7 @@ import org.eclipse.ui.IViewPart;
 import org.eclipse.ui.IWorkbenchPage;
 import org.eclipse.ui.IWorkbenchPart;
 import org.eclipse.ui.PlatformUI;
+import org.talend.core.model.context.ContextUtils;
 import org.talend.core.ui.branding.IBrandingConfiguration;
 
 /**
@@ -51,6 +52,7 @@ public class Contexts {
             public void run() {
                 if (cxtView != null) {
                     updateTitle(cxtView);
+                    ContextUtils.clearMissingContextCache();
                     cxtView.refresh(part);
                 }
             }

main/plugins/org.talend.core.ui/src/main/java/org/talend/core/ui/documentation/generation/ExternalNodeComponentHandler.java

@@ -175,9 +175,28 @@ public class ExternalNodeComponentHandler extends AbstractComponentHandler {
                 generateComponentSchemaInfo(externalNode, componentElement);
                 generateComponentElementParamInfo(parametersElement, elementParameterList);
             } else {
+                boolean isSCDComponent = externalNode.getComponent().getName().endsWith("SCD");
+                if (isSCDComponent) {
+                    Element parametersElement = componentElement.addElement("parameters"); //$NON-NLS-1$
+                    List elementParameterList = externalNode.getElementParameters();
+                    generateComponentSchemaInfo(externalNode, componentElement);
+                    generateComponentElementParamInfo(parametersElement, elementParameterList);
+                }
                 URL fileURL = componentDocumentation.getHTMLFile();
                 if (fileURL != null) {
                     this.externalNodeHTMLMap.put(componentName, fileURL);
+                    if (isSCDComponent) {
+                        // add extra check and uncheck icon for SCDComponent
+                        File picPath = new File(
+                                HTMLDocUtils.getTmpFolder() + File.separatorChar + IHTMLDocConstants.PICTUREFOLDERPATH);
+                        if (picPath.exists()) {
+                            for (File f : picPath.listFiles()) {
+                                if (!picFilePathMap.containsKey(f.getName())) {
+                                    picFilePathMap.put(f.getName(), f.getAbsolutePath());
+                                }
+                            }
+                        }
+                    }
                 }
             }
             componentElement.addComment(componentName);

main/plugins/org.talend.core/src/main/java/messages_fr.properties

@@ -317,3 +317,4 @@ ActionBarBuildHelper.SaveAll_toolTip=Sauvegarder tout
 ContextOrderProperty.BuiltInComment=Variables de contexte built-in
 ContextOrderProperty.RepositoryComment=Variables de contexte du contexte du r\u00E9f\u00E9rentiel :
 BaseComponentInstallerTask.installComponent=Installation du composant {0}
+ApplicationWorkbenchWindowAdvisor.repositoryConnection=Connexion

main/plugins/org.talend.core/src/main/java/messages_zh_CN.properties

@@ -317,3 +317,4 @@ ActionBarBuildHelper.SaveAll_toolTip=\u4FDD\u5B58\u5168\u90E8
 ContextOrderProperty.BuiltInComment=\u5185\u7F6E\u4E0A\u4E0B\u6587\u53D8\u91CF
 ContextOrderProperty.RepositoryComment=\u6765\u81EA\u5B58\u50A8\u5E93\u4E0A\u4E0B\u6587\u7684\u4E0A\u4E0B\u6587\u53D8\u91CF\uFF1A
 BaseComponentInstallerTask.installComponent=\u6B63\u5728\u5B89\u88C5\u7EC4\u4EF6 {0}
+ApplicationWorkbenchWindowAdvisor.repositoryConnection=\u8FDE\u63A5

main/plugins/org.talend.core/src/main/java/org/talend/core/model/param/ERepositoryCategoryType.java

@@ -30,6 +30,7 @@ public enum ERepositoryCategoryType {
     DATABASE,
     SAP,
     SAPIDOC,
+    BIGQUERY,
     EBCDIC,
     HL7,
     FTP,

main/plugins/org.talend.cwm.mip.edit/plugin_fr.properties

@@ -553,7 +553,7 @@ _UI_Column_length_feature=Longueur
 _UI_Column_collationName_feature=Nom de l'interclassement
 _UI_Column_characterSetName_feature=Nom du jeu de caract\u00E8res
 _UI_Column_referencedTableType_feature=Type de la table r\u00E9f\u00E9renc\u00E9e
-_UI_Column_optionScopeColumnSet_feature=Scope des options sur le jeu de colonnes
+_UI_Column_optionScopeColumnSet_feature=P\u00E9rim\u00E8tre des options sur le jeu de colonnes
 _UI_Procedure_type_feature=Type
 _UI_Trigger_eventManipulation_feature=Manipulation d'\u00E9v\u00E9nement
 _UI_Trigger_actionCondition_feature=Condition d'action

main/plugins/org.talend.designer.maven.repo.tcksdk/pom.xml

@@ -15,12 +15,12 @@
 		<geronimo.version>1.0.2</geronimo.version>
 		<jcache.version>1.0.5</jcache.version>
 		<jcache_spec.version>1.0-alpha-1</jcache_spec.version>
-		<johnzon.version>1.2.19</johnzon.version>
+		<johnzon.version>1.2.20</johnzon.version>
 		<meecrowave.version>1.2.15</meecrowave.version>
 		<microprofile.version>1.2.1</microprofile.version>
 		<owb.version>2.0.27</owb.version>
 		<slf4j.version>1.7.34</slf4j.version>
-		<tomcat.version>9.0.73</tomcat.version>
+		<tomcat.version>9.0.75</tomcat.version>
 		<xbean.version>4.20</xbean.version>
 		<reload4j.version>1.2.22</reload4j.version>
 		<log4j2.version>2.20.0</log4j2.version>

main/plugins/org.talend.designer.maven.tos/resources/build/plugins/karaf-maven-plugin-4-2-10/pom.xml

@@ -82,7 +82,12 @@
 		<dependency>
 			<groupId>org.codehaus.plexus</groupId>
 			<artifactId>plexus-archiver</artifactId>
-			<version>3.6.0</version>
+			<version>4.8.0</version>
+		</dependency>
+		<dependency>
+			<groupId>org.codehaus.plexus</groupId>
+			<artifactId>plexus-xml</artifactId>
+			<version>4.0.0</version>
 		</dependency>
 		<dependency>
 		    <groupId>org.codehaus.plexus</groupId>

main/plugins/org.talend.designer.maven.tos/resources/build/pom.xml

@@ -133,7 +133,7 @@
 		<dependency>
 			<groupId>org.apache.maven.plugins</groupId>
 			<artifactId>maven-surefire-plugin</artifactId>
-			<version>2.20</version>
+			<version>2.22.2</version>
 			<exclusions>
 				<exclusion>
 					<groupId>org.sonatype.plexus</groupId>
@@ -141,6 +141,21 @@
 				</exclusion>
 			</exclusions>
 		</dependency>
+        <dependency>
+            <groupId>org.apache.maven.surefire</groupId>
+            <artifactId>surefire-booter</artifactId>
+            <version>2.22.2</version>
+        </dependency>
+        <dependency>
+            <groupId>org.apache.maven.surefire</groupId>
+            <artifactId>surefire-api</artifactId>
+            <version>2.22.2</version>
+        </dependency>
+        <dependency>
+            <groupId>org.apache.maven.surefire</groupId>
+            <artifactId>surefire-junit4</artifactId>
+            <version>2.22.2</version>
+        </dependency>
 		<dependency>
 			<groupId>org.codehaus.plexus</groupId>
 			<artifactId>plexus-cipher</artifactId>

main/plugins/org.talend.designer.maven.tos/resources/tcompv1/pom.xml

@@ -11,7 +11,7 @@
     <packaging>pom</packaging>
 
     <properties>
-        <tcomp.version>1.57.1</tcomp.version>
+        <tcomp.version>1.59.0</tcomp.version>
         <slf4j.version>1.7.34</slf4j.version>
         <reload4j.version>1.2.22</reload4j.version>
     </properties>

main/plugins/org.talend.designer.maven/resources/templates/general/pom_project_template.xml

@@ -44,7 +44,12 @@
 						<dependency>
 							<groupId>org.codehaus.plexus</groupId>
 							<artifactId>plexus-utils</artifactId>
-							<version>3.0.24</version>
+							<version>4.0.0</version>
+						</dependency>
+						<dependency>
+							<groupId>org.codehaus.plexus</groupId>
+							<artifactId>plexus-xml</artifactId>
+							<version>4.0.0</version>
 						</dependency>
 						<dependency>
 							<groupId>commons-io</groupId>
@@ -54,7 +59,7 @@
 						<dependency>
 							<groupId>org.codehaus.plexus</groupId>
 							<artifactId>plexus-archiver</artifactId>
-							<version>3.6.0</version>
+							<version>4.8.0</version>
 						</dependency>
 						<dependency>
 							<groupId>org.apache.maven</groupId>
@@ -74,7 +79,7 @@
 						<dependency>
 							<groupId>com.google.guava</groupId>
 							<artifactId>guava</artifactId>
-							<version>30.0-jre</version>
+							<version>32.0.1-jre</version>
 						</dependency>
 					</dependencies>
 				</plugin>
@@ -106,7 +111,7 @@
 						<dependency>
 							<groupId>com.google.guava</groupId>
 							<artifactId>guava</artifactId>
-							<version>30.0-jre</version>
+							<version>32.0.1-jre</version>
 						</dependency>
 					</dependencies>
 				</plugin>
@@ -123,7 +128,12 @@
 						<dependency>
 							<groupId>org.codehaus.plexus</groupId>
 							<artifactId>plexus-utils</artifactId>
-							<version>3.0.24</version>
+							<version>4.0.0</version>
+						</dependency>
+						<dependency>
+							<groupId>org.codehaus.plexus</groupId>
+							<artifactId>plexus-xml</artifactId>
+							<version>4.0.0</version>
 						</dependency>
 						<dependency>
 							<groupId>org.apache.commons</groupId>
@@ -138,12 +148,12 @@
 						<dependency>
 							<groupId>org.codehaus.plexus</groupId>
 							<artifactId>plexus-archiver</artifactId>
-							<version>3.6.0</version>
+							<version>4.8.0</version>
 						</dependency>
 						<dependency>
 							<groupId>org.codehaus.plexus</groupId>
 							<artifactId>plexus-io</artifactId>
-							<version>3.0.1</version>
+							<version>3.4.1</version>
 						</dependency>
 						<dependency>
 							<groupId>org.apache.maven</groupId>
@@ -153,7 +163,7 @@
 						<dependency>
 							<groupId>com.google.guava</groupId>
 							<artifactId>guava</artifactId>
-							<version>30.0-jre</version>
+							<version>32.0.1-jre</version>
 						</dependency>
 					</dependencies>
 					<configuration>
@@ -165,7 +175,7 @@
 				<plugin>
 					<groupId>org.apache.maven.plugins</groupId>
 					<artifactId>maven-assembly-plugin</artifactId>
-					<version>3.0.0</version>
+					<version>3.6.0</version>
 					<dependencies>
 						<dependency>
 							<groupId>org.apache.maven.shared</groupId>
@@ -175,7 +185,17 @@
 						<dependency>
 							<groupId>org.codehaus.plexus</groupId>
 							<artifactId>plexus-utils</artifactId>
-							<version>3.0.24</version>
+							<version>4.0.0</version>
+						</dependency>
+						<dependency>
+							<groupId>org.codehaus.plexus</groupId>
+							<artifactId>plexus-io</artifactId>
+							<version>3.4.1</version>
+						</dependency>
+						<dependency>
+							<groupId>org.codehaus.plexus</groupId>
+							<artifactId>plexus-xml</artifactId>
+							<version>4.0.0</version>
 						</dependency>
 						<dependency>
 							<groupId>commons-codec</groupId>
@@ -195,7 +215,7 @@
 						<dependency>
 							<groupId>org.codehaus.plexus</groupId>
 							<artifactId>plexus-archiver</artifactId>
-							<version>3.6.0</version>
+							<version>4.8.0</version>
 						</dependency>
 						<dependency>
 							<groupId>org.apache.maven</groupId>
@@ -210,14 +230,14 @@
 						<dependency>
 							<groupId>com.google.guava</groupId>
 							<artifactId>guava</artifactId>
-							<version>30.0-jre</version>
+							<version>32.0.1-jre</version>
 						</dependency>
 					</dependencies>
 				</plugin>
 				<plugin>
 					<groupId>org.apache.maven.plugins</groupId>
 					<artifactId>maven-surefire-plugin</artifactId>
-					<version>2.20</version>
+					<version>2.22.2</version>
 					<dependencies>
 						<dependency>
 							<groupId>org.sonatype.plexus</groupId>

main/plugins/org.talend.designer.maven/src/main/java/org/talend/designer/maven/tools/creator/AbstractMavenProcessorPom.java

@@ -216,7 +216,7 @@ public abstract class AbstractMavenProcessorPom extends CreateMavenBundleTemplat
                 Dependency guavaDep = new Dependency();
                 guavaDep.setGroupId("com.google.guava");
                 guavaDep.setArtifactId("guava");
-                guavaDep.setVersion("30.0-jre");
+                guavaDep.setVersion("32.0.1-jre");
                 
                 Dependency ioDep = new Dependency();
                 ioDep.setGroupId("commons-io");

main/plugins/org.talend.libraries.jdbc.mysql/plugin.xml

@@ -18,11 +18,11 @@
         </libraryNeeded>
         <libraryNeeded
               context="plugin:org.talend.libraries.jdbc.mysql"
-              id="mariadb-java-client-2.5.3.jar"
+              id="mariadb-java-client-3.1.4.jar"
               language="java"
               message="Needed for Mysql jdbc plugin"
-              mvn_uri="mvn:org.mariadb.jdbc/mariadb-java-client/2.5.3"
-              name="mariadb-java-client-2.5.3.jar"
+              mvn_uri="mvn:org.mariadb.jdbc/mariadb-java-client/3.1.4"
+              name="mariadb-java-client-3.1.4.jar"
               required="true">
         </libraryNeeded>
         <libraryNeeded

main/plugins/org.talend.librariesmanager.ui/src/main/java/org/talend/librariesmanager/utils/ModuleMavenURIUtils.java

@@ -101,13 +101,14 @@ public class ModuleMavenURIUtils {
     private static Pattern pattern;
 
     // match mvn:group-id/artifact-id/version/type/classifier
-    public static final String expression1 = "(mvn:(\\w+.*/)(\\w+.*/)(\\d+\\.\\d.*?(/))(\\w+/)(\\w+))";//$NON-NLS-1$
+    public static final String expression1 = "(mvn:(\\w+.*/)(\\w+.*/)(\\d+(\\.)?\\d.*?(/))(\\w+/)(\\w+))";//$NON-NLS-1$
 
     // match mvn:group-id/artifact-id/version/type
-    public static final String expression2 = "(mvn:(\\w+.*/)(\\w+.*/)(\\d+\\.\\d.*?(/))\\w+)";//$NON-NLS-1$
+    public static final String expression2 = "(mvn:(\\w+.*/)(\\w+.*/)(\\d+(\\.)?\\d.*?(/))\\w+)";//$NON-NLS-1$
 
     // match mvn:group-id/artifact-id/version
-    public static final String expression3 = "(mvn:(\\w+.*/)(\\w+.*/)(\\d+\\.\\d[^/]*))";//$NON-NLS-1$
+    public static final String expression3 = "(mvn:(\\w+.*/)(\\w+.*/)(\\d+(\\.)?\\d[^/]*))";//$NON-NLS-1$
+
 
     public static final String MVNURI_TEMPLET = "mvn:<groupid>/<artifactId>/<version>/<type>";
 

main/plugins/org.talend.librariesmanager/src/main/java/org/talend/librariesmanager/model/ModulesNeededProvider.java

@@ -797,8 +797,6 @@ public class ModulesNeededProvider {
         if (importNeedsListForBeans == null) {
             importNeedsListForBeans = getModulesNeededForRoutes(processItem);
 
-            importNeedsListForBeans.add(getComponentModuleById("CAMEL", "camel-cxf"));
-
             importNeedsListForBeans.add(getComponentModuleById("CAMEL", "cxf-core"));
             importNeedsListForBeans.add(getComponentModuleById("CAMEL", "javax.ws.rs-api"));
             for (ModuleNeeded need : importNeedsListForBeans) {

main/plugins/org.talend.librariesmanager/src/main/java/org/talend/librariesmanager/model/service/LocalLibraryManager.java

@@ -1476,9 +1476,7 @@ public class LocalLibraryManager implements ILibraryManagerService, IChangedLibr
     
    private boolean isExtComponentProvider(String id) {
        if ("org.talend.designer.components.model.UserComponentsProvider".equals(id)
-               || "org.talend.designer.codegen.components.model.SharedStudioUserComponentProvider".equals(id)
-               || "org.talend.designer.components.exchange.ExchangeComponentsProvider".equals(id)
-               || "org.talend.designer.components.exchange.SharedStudioExchangeComponentsProvider".equals(id)) {
+               || "org.talend.designer.codegen.components.model.SharedStudioUserComponentProvider".equals(id)) {
            return true;
        }
        return false;

main/plugins/org.talend.metadata.managment.ui/src/main/java/messages_ja.properties

@@ -142,7 +142,7 @@ DatabaseTableForm.retreiveButtonIsAccessible=[Retrieve] (\u53D6\u5F97)\u30DC\u30
 DatabaseTableForm.retreiveButtonTip=\u30B9\u30AD\u30FC\u30DE\u3092\u5B9A\u7FA9\u3057\u3066\u304F\u3060\u3055\u3044\u3002\u300C\u30B9\u30AD\u30FC\u30DE\u60C5\u5831\u3092\u53D6\u5F97\u300D\u304C\u4F7F\u7528\u3067\u304D\u307E\u3059!
 DatabaseTableForm.retreiveButtonUse=[\u30B9\u30AD\u30FC\u30DE\u3092\u53D6\u5F97]\u30DC\u30BF\u30F3\u3092\u4F7F\u3063\u3066\u3001\u73FE\u5728\u306E\u30B9\u30AD\u30FC\u30DE\u3092\u30C6\u30FC\u30D6\u30EB\u57FA\u672C\u30B9\u30AD\u30FC\u30DE\u306B\u7F6E\u63DB
 DatabaseTableForm.retreiveSchema=\u30B9\u30AD\u30FC\u30DE\u3092\u53D6\u5F97
-DatabaseTableForm.guessSchema=\u30B9\u30AD\u30FC\u30DE\u3092\u63A8\u6E2C
+DatabaseTableForm.guessSchema=\u63A8\u6E2C\u30B9\u30AD\u30FC\u30DE
 DatabaseTableForm.streamDetach=\u30B9\u30C8\u30EA\u30FC\u30E0\u5206\u96E2
 DatabaseTableForm.table=\u30C6\u30FC\u30D6\u30EB\u306B\u57FA\u3065\u3044\u305F
 DatabaseTableForm.tableColumnText.talbe=\u30C6\u30FC\u30D6\u30EB

main/plugins/org.talend.metadata.managment.ui/src/main/java/org/talend/metadata/managment/ui/editor/MetadataTalendTypeEditor.java

@@ -166,8 +166,7 @@ public class MetadataTalendTypeEditor extends FieldEditor {
         private void init() {
             try {
                 tmpFiles.clear();
-                java.nio.file.Path systemMappingPath = new File(MetadataTalendType.getSystemFolderURLOfMappingsFile().getFile())
-                        .toPath();
+                java.nio.file.Path systemMappingPath = MetadataTalendType.getSystemFolderURLOfMappingsFile().toPath();
                 Map<String, File> systemFileMap = Stream
                         .of(systemMappingPath.toFile()
                                 .listFiles(f -> f.getName().matches(MetadataTalendType.MAPPING_FILE_PATTERN)))
@@ -323,8 +322,7 @@ public class MetadataTalendTypeEditor extends FieldEditor {
         if (sourceViewerDialog.open() == IDialogConstants.OK_ID) {
             System.out.println(sourceViewerDialog.getResult());
             try {
-                File systemFile = new File(MetadataTalendType.getSystemFolderURLOfMappingsFile().getFile(),
-                        fileSelected.fileName);
+                File systemFile = new File(MetadataTalendType.getSystemFolderURLOfMappingsFile(), fileSelected.fileName);
                 if (systemFile.exists()) {
                     String currentSha1 = MetadataTalendType.getSha1OfText(sourceViewerDialog.getDocument().get());
                     String systemSha1 = MetadataTalendType.getSha1OfFile(systemFile);
@@ -334,7 +332,7 @@ public class MetadataTalendTypeEditor extends FieldEditor {
                         setControlEnable(removeButton, false);
                     } else {
                         fileSelected.type = FileType.USER_DEFINED;
-                        fileSelected.file = new File(MetadataTalendType.getProjectFolderURLOfMappingsFile().getFile(),
+                        fileSelected.file = new File(MetadataTalendType.getProjectFolderURLOfMappingsFile(),
                                 fileSelected.fileName);
                         setControlEnable(removeButton, true);
                     }
@@ -431,7 +429,7 @@ public class MetadataTalendTypeEditor extends FieldEditor {
         if (FileType.USER_DEFINED == info.type) {
             try {
                 info.type = FileType.SYSTEM_DEFAULT;
-                info.file = new File(MetadataTalendType.getSystemFolderURLOfMappingsFile().getFile(), info.fileName);
+                info.file = new File(MetadataTalendType.getSystemFolderURLOfMappingsFile(), info.fileName);
                 info.fileContent = null;
             } catch (SystemException e) {
                 ExceptionHandler.process(e);
@@ -664,11 +662,10 @@ public class MetadataTalendTypeEditor extends FieldEditor {
                 @Override
                 protected void run() throws LoginException, PersistenceException {
                     try {
-                        File[] projectMappingFiles = new File(MetadataTalendType.getProjectFolderURLOfMappingsFile().getFile())
-                                .listFiles();
+                        File[] projectMappingFiles = MetadataTalendType.getProjectFolderURLOfMappingsFile().listFiles();
                         if (projectMappingFiles != null) {
                             Set<String> systemFileNames = Stream
-                                    .of(new File(MetadataTalendType.getSystemFolderURLOfMappingsFile().getFile())
+                                    .of(MetadataTalendType.getSystemFolderURLOfMappingsFile()
                                             .listFiles(f -> f.getName().matches(MetadataTalendType.MAPPING_FILE_PATTERN)))
                                     .map(File::getName).collect(Collectors.toSet());
                             Stream.of(projectMappingFiles).filter(f -> systemFileNames.contains(f.getName()))

main/plugins/org.talend.metadata.managment.ui/src/main/java/org/talend/metadata/managment/ui/utils/DBConnectionContextUtils.java

@@ -30,6 +30,7 @@ import org.talend.core.database.conn.ConnParameterKeys;
 import org.talend.core.database.conn.DatabaseConnStrUtil;
 import org.talend.core.database.conn.template.DbConnStrForHive;
 import org.talend.core.database.conn.template.EDatabaseConnTemplate;
+import org.talend.core.database.conn.version.EDatabaseVersion4Drivers;
 import org.talend.core.hadoop.IHadoopClusterService;
 import org.talend.core.hadoop.repository.HadoopRepositoryUtil;
 import org.talend.core.language.ECodeLanguage;
@@ -53,7 +54,6 @@ import org.talend.core.utils.TalendQuoteUtils;
 import org.talend.cwm.helper.CatalogHelper;
 import org.talend.cwm.helper.ConnectionHelper;
 import org.talend.cwm.helper.SchemaHelper;
-import org.talend.cwm.helper.StudioEncryptionHelper;
 import org.talend.designer.core.model.utils.emf.talendfile.ContextType;
 import org.talend.metadata.managment.repository.ManagerConnection;
 import org.talend.metadata.managment.ui.model.IConnParamName;
@@ -869,6 +869,11 @@ public final class DBConnectionContextUtils {
 
         filePath = TalendQuoteUtils.removeQuotes(filePath);
         dbRootPath = TalendQuoteUtils.removeQuotes(dbRootPath);
+        
+        //
+        if (EDatabaseTypeName.VERTICA.getDisplayName().equals(dbConn.getDatabaseType())) {
+            dbVersionString = EDatabaseVersion4Drivers.VERTICA_12.getVersionValue();
+        }
         // url
 
         String urlConnection;

main/plugins/org.talend.metadata.managment.ui/src/main/java/org/talend/metadata/managment/ui/utils/ExtendedNodeConnectionContextUtils.java

@@ -214,7 +214,10 @@ public class ExtendedNodeConnectionContextUtils {
         StandaloneMaster,
         StandaloneConfigureExecutors,
         StandaloneExecutorMemory,
-        StandaloneExecutorCore
+        StandaloneExecutorCore,
+        
+        //spark submit script
+        SparkSubmitScriptHome
     }
 
     static List<IContextParameter> getContextVariables(final String prefixName, Connection conn, Set<IConnParamName> paramSet) {

main/plugins/org.talend.metadata.managment/plugin.xml

@@ -174,16 +174,16 @@
            context="plugin:org.talend.metadata.managment"
            language="java"
            message="Needed for create Microsoft SQL Server db connection"
-           mvn_uri="mvn:net.minidev/json-smart/2.4.9"
-           name="json-smart-2.4.9.jar"
+           mvn_uri="mvn:net.minidev/json-smart/2.4.11"
+           name="json-smart-2.4.11.jar"
            required="true">
      </libraryNeeded>
      <libraryNeeded
            context="plugin:org.talend.metadata.managment"
            language="java"
            message="Needed for create Microsoft SQL Server db connection"
-           mvn_uri="mvn:net.minidev/accessors-smart/2.4.9"
-           name="accessors-smart-2.4.9.jar"
+           mvn_uri="mvn:net.minidev/accessors-smart/2.4.11"
+           name="accessors-smart-2.4.11.jar"
            required="true">
      </libraryNeeded>
      <libraryNeeded
@@ -194,6 +194,14 @@
            name="asm-9.5.jar"
            required="true">
      </libraryNeeded>
+     <libraryNeeded
+          context="Vertica 12.x dbwizard"
+          language="java"
+          message="Vertica 12.x dbwizard for TOP"
+          mvn_uri="mvn:com.vertica.jdbc/vertica-jdbc/12.0.4-0"
+          name="vertica-jdbc-12.0.4-0.jar"
+          required="true">
+    </libraryNeeded>
    </extension>
    <extension
          point="org.talend.core.migrationTask">

main/plugins/org.talend.metadata.managment/src/main/java/org/talend/core/model/metadata/builder/database/DqRepositoryViewService.java

@@ -94,7 +94,8 @@ public final class DqRepositoryViewService {
 
     public static final String[] TABLE_TYPES = new String[] { ETableTypes.TABLETYPE_TABLE.getName(),
             ETableTypes.EXTERNAL_TABLE.getName(), ETableTypes.MANAGED_TABLE.getName(), ETableTypes.INDEX_TABLE.getName(),
-            ETableTypes.SYSTEM_TABLE.getName() };
+            ETableTypes.SYSTEM_TABLE.getName(), ETableTypes.FOREIGN_TABLE.getName(),
+            ETableTypes.EXTERNAL_TABLE_SPACE.getName() };
 
     public static final String[] VIEW_TYPES = new String[] { ETableTypes.TABLETYPE_VIEW.getName(),
             ETableTypes.VIRTUAL_VIEW.getName() };

main/plugins/org.talend.metadata.managment/src/main/java/org/talend/core/model/metadata/builder/database/ExtractMetaDataFromDataBase.java

@@ -91,11 +91,13 @@ public class ExtractMetaDataFromDataBase {
         TABLETYPE_ALL_SYNONYM("ALL_SYNONYM"), //$NON-NLS-1$
         TABLETYPE_ALIAS("ALIAS"), //$NON-NLS-1$
         EXTERNAL_TABLE("EXTERNAL_TABLE"), //$NON-NLS-1$
+        EXTERNAL_TABLE_SPACE("EXTERNAL TABLE"), //$NON-NLS-1$ for redshift tabel
         MANAGED_TABLE("MANAGED_TABLE"), //$NON-NLS-1$ // for hive
         INDEX_TABLE("INDEX_TABLE"), //$NON-NLS-1$ // for hive
         VIRTUAL_VIEW("VIRTUAL_VIEW"), //$NON-NLS-1$ // for hive
         SYSTEM_TABLE("SYSTEM TABLE"), //$NON-NLS-1$ //added for amazon redshift TDQ-11558 by msjian
-        SYSTEM_VIEW("SYSTEM VIEW"); //$NON-NLS-1$ // for mysql
+        SYSTEM_VIEW("SYSTEM VIEW"), //$NON-NLS-1$ // for mysql
+        FOREIGN_TABLE("FOREIGN TABLE"); //$NON-NLS-1$ // for postgresql
 
         private final String name;
 

main/plugins/org.talend.metadata.managment/src/main/java/org/talend/core/model/metadata/builder/database/ExtractMetaDataUtils.java

@@ -122,7 +122,7 @@ public class ExtractMetaDataUtils {
     private String[] ORACLE_SSL_JARS = new String[] { "oraclepki-12.2.0.1.jar", "osdt_cert-12.2.0.1.jar", //$NON-NLS-1$//$NON-NLS-2$
             "osdt_core-12.2.0.1.jar" }; //$NON-NLS-1$
     
-    private String ORACLE_NLS_JARS = "orai18n-19.3.0.0.jar";
+    private String ORACLE_NLS_JARS = "orai18n-19.19.0.0.jar";
 
     public static final String SNOWFLAKE = "Snowflake"; //$NON-NLS-1$
 
@@ -985,9 +985,8 @@ public class ExtractMetaDataUtils {
                         driverClassName = getDriverClassByDbType(dbType);
                     }
                     // feature TDI-22108
-                    if (EDatabaseTypeName.VERTICA.getXmlName().equals(dbType)
-                            && EDatabaseVersion4Drivers.VERTICA_9.getVersionValue().equals(dbVersion)) {
-                        driverClassName = EDatabase4DriverClassName.VERTICA2.getDriverClass();
+                    if (EDatabaseTypeName.VERTICA.getXmlName().equals(dbType)) {
+                        driverClassName = EDatabase4DriverClassName.VERTICA.getDriverClass();
                     } else if (EDatabaseTypeName.MYSQL.getXmlName().equals(dbType)) {
                         if (EDatabaseVersion4Drivers.MYSQL_8.getVersionValue().equals(dbVersion)) {
                             driverClassName = EDatabase4DriverClassName.MYSQL8.getDriverClass();

main/plugins/org.talend.metadata.managment/src/main/java/org/talend/core/model/metadata/builder/database/manager/ExtractManager.java

@@ -194,7 +194,8 @@ public class ExtractManager {
         ResultSet rsTableTypes = dbMetaData.getTableTypes();
         Set<String> availableTableTypes = new HashSet<String>();
         String[] neededTableTypes = { ETableTypes.TABLETYPE_TABLE.getName(), ETableTypes.TABLETYPE_VIEW.getName(),
-                ETableTypes.TABLETYPE_SYNONYM.getName(), ETableTypes.EXTERNAL_TABLE.getName()};
+                ETableTypes.TABLETYPE_SYNONYM.getName(), ETableTypes.EXTERNAL_TABLE.getName(),
+                ETableTypes.EXTERNAL_TABLE_SPACE.getName(), ETableTypes.FOREIGN_TABLE.getName() };
 
         try {
             while (rsTableTypes.next()) {

main/plugins/org.talend.metadata.managment/src/main/java/org/talend/core/model/metadata/builder/database/manager/dbs/OracleExtractManager.java

@@ -183,7 +183,9 @@ public class OracleExtractManager extends ExtractManager {
             } else if (table.eContainer() instanceof Schema) {
                 synSQL += "and all_synonyms.OWNER =?";
             }
-            synSQL += " ORDER BY all_tab_columns.COLUMN_NAME"; //$NON-NLS-1$
+            
+            //TUP-39239, caused not same ordering of the columns between table schema and synonym schema
+//            synSQL += " ORDER BY all_tab_columns.COLUMN_NAME"; //$NON-NLS-1$
             PreparedStatement sta = extractMeta.getConn().prepareStatement(synSQL);
             sta.setString(1, synonymName);
             int idx = 2;

main/plugins/org.talend.metadata.managment/src/main/java/org/talend/metadata/managment/model/DBConnectionFillerImpl.java

@@ -1091,6 +1091,8 @@ public class DBConnectionFillerImpl extends MetadataFillerImpl<DatabaseConnectio
                 metadatatable.setName(tableName);
                 // Added by Marvin Wang on Feb. 6, 2012 for bug TDI-24413, it is just for hive external table.
                 if (ETableTypes.EXTERNAL_TABLE.getName().equals(temptableType)
+                        || ETableTypes.EXTERNAL_TABLE_SPACE.getName().equals(temptableType)
+                        || ETableTypes.FOREIGN_TABLE.getName().equals(temptableType)
                         || ETableTypes.MANAGED_TABLE.getName().equals(temptableType)
                         || ETableTypes.INDEX_TABLE.getName().equals(temptableType)
                         || ETableTypes.TABLETYPE_BASE_TABLE.getName().equals(temptableType)

main/plugins/org.talend.metadata.managment/src/main/java/org/talend/metadata/managment/utils/MetadataConnectionUtils.java

@@ -320,7 +320,7 @@ public class MetadataConnectionUtils {
             }// ~
             additionalParams = ConvertionHelper.convertAdditionalParameters(databaseConnection);
             metadataConnection.setAdditionalParams(additionalParams);
-            metadataConnection.setDbVersionString(dbVersionString);
+            metadataConnection.setDbVersionString(ConvertionHelper.getDriverVersionString(databaseConnection));
             metadataConnection.setDatabase(dataBase);
             metadataConnection.setDbType(dbType);
             metadataConnection.setDriverJarPath(driverJarPath);

main/plugins/org.talend.model/model/metadata.ecore

@@ -873,6 +873,13 @@
   <eClassifiers xsi:type="ecore:EClass" name="SAPBWTableField" eSuperTypes="#//SAPTableField">
     <eStructuralFeatures xsi:type="ecore:EAttribute" name="logicalName" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
   </eClassifiers>
+  <eClassifiers xsi:type="ecore:EClass" name="BigQueryConnection" eSuperTypes="#//Connection">
+    <eStructuralFeatures xsi:type="ecore:EAttribute" name="ServiceAccountCredentialsFile"
+        eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
+    <eStructuralFeatures xsi:type="ecore:EAttribute" name="ProjectId" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
+    <eStructuralFeatures xsi:type="ecore:EAttribute" name="UseRegionEndpoint" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EBoolean"/>
+    <eStructuralFeatures xsi:type="ecore:EAttribute" name="RegionEndpoint" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
+  </eClassifiers>
   <eSubpackages name="cwm" nsURI="http://www.talend.org/cwm/2010" nsPrefix="cwm">
     <eSubpackages name="relational" nsURI="http://www.talend.org/cwm/resource/relational/2010"
         nsPrefix="relational">

main/plugins/org.talend.model/model/metadata.genmodel

@@ -574,6 +574,12 @@
     <genClasses ecoreClass="metadata.ecore#//SAPBWTableField">
       <genFeatures createChild="false" ecoreFeature="ecore:EAttribute metadata.ecore#//SAPBWTableField/logicalName"/>
     </genClasses>
+    <genClasses ecoreClass="metadata.ecore#//BigQueryConnection">
+      <genFeatures createChild="false" ecoreFeature="ecore:EAttribute metadata.ecore#//BigQueryConnection/ServiceAccountCredentialsFile"/>
+      <genFeatures createChild="false" ecoreFeature="ecore:EAttribute metadata.ecore#//BigQueryConnection/ProjectId"/>
+      <genFeatures createChild="false" ecoreFeature="ecore:EAttribute metadata.ecore#//BigQueryConnection/UseRegionEndpoint"/>
+      <genFeatures createChild="false" ecoreFeature="ecore:EAttribute metadata.ecore#//BigQueryConnection/RegionEndpoint"/>
+    </genClasses>
     <nestedGenPackages prefix="cwm" basePackage="org.talend" disposableProviderFactory="true"
         ecorePackage="metadata.ecore#//cwm">
       <nestedGenPackages prefix="Relational" basePackage="org.talend.cwm" disposableProviderFactory="true"

main/plugins/org.talend.model/model/properties.ecore

@@ -874,4 +874,5 @@
   <eClassifiers xsi:type="ecore:EClass" name="RoutinesJarItem" eSuperTypes="#//Item">
     <eStructuralFeatures xsi:type="ecore:EReference" name="routinesJarType" eType="#//RoutinesJarType"/>
   </eClassifiers>
+  <eClassifiers xsi:type="ecore:EClass" name="BigQueryConnectionItem" eSuperTypes="#//ConnectionItem"/>
 </ecore:EPackage>

main/plugins/org.talend.model/model/properties.genmodel

@@ -689,5 +689,6 @@
     <genClasses ecoreClass="properties.ecore#//RoutinesJarItem">
       <genFeatures notify="false" createChild="false" propertySortChoices="true" ecoreFeature="ecore:EReference properties.ecore#//RoutinesJarItem/routinesJarType"/>
     </genClasses>
+    <genClasses ecoreClass="properties.ecore#//BigQueryConnectionItem"/>
   </genPackages>
 </genmodel:GenModel>

main/plugins/org.talend.model/src/main/java/org/talend/core/model/metadata/builder/connection/BigQueryAuthMode.java

@@ -0,0 +1,9 @@
+package org.talend.core.model.metadata.builder.connection;
+
+public enum BigQueryAuthMode {
+	
+	SERVICEACCOUNT,
+	OAUTH,
+	TOKEN
+
+}

main/plugins/org.talend.model/src/main/java/org/talend/core/model/metadata/builder/connection/BigQueryConnection.java

@@ -0,0 +1,113 @@
+/**
+ */
+package org.talend.core.model.metadata.builder.connection;
+
+/**
+ * <!-- begin-user-doc -->
+ * A representation of the model object '<em><b>Big Query Connection</b></em>'.
+ * <!-- end-user-doc -->
+ *
+ * <p>
+ * The following features are supported:
+ * </p>
+ * <ul>
+ *   <li>{@link org.talend.core.model.metadata.builder.connection.BigQueryConnection#getServiceAccountCredentialsFile <em>Service Account Credentials File</em>}</li>
+ *   <li>{@link org.talend.core.model.metadata.builder.connection.BigQueryConnection#getProjectId <em>Project Id</em>}</li>
+ *   <li>{@link org.talend.core.model.metadata.builder.connection.BigQueryConnection#isUseRegionEndpoint <em>Use Region Endpoint</em>}</li>
+ *   <li>{@link org.talend.core.model.metadata.builder.connection.BigQueryConnection#getRegionEndpoint <em>Region Endpoint</em>}</li>
+ * </ul>
+ *
+ * @see org.talend.core.model.metadata.builder.connection.ConnectionPackage#getBigQueryConnection()
+ * @model
+ * @generated
+ */
+public interface BigQueryConnection extends Connection {
+	/**
+	 * Returns the value of the '<em><b>Service Account Credentials File</b></em>' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return the value of the '<em>Service Account Credentials File</em>' attribute.
+	 * @see #setServiceAccountCredentialsFile(String)
+	 * @see org.talend.core.model.metadata.builder.connection.ConnectionPackage#getBigQueryConnection_ServiceAccountCredentialsFile()
+	 * @model
+	 * @generated
+	 */
+	String getServiceAccountCredentialsFile();
+
+	/**
+	 * Sets the value of the '{@link org.talend.core.model.metadata.builder.connection.BigQueryConnection#getServiceAccountCredentialsFile <em>Service Account Credentials File</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @param value the new value of the '<em>Service Account Credentials File</em>' attribute.
+	 * @see #getServiceAccountCredentialsFile()
+	 * @generated
+	 */
+	void setServiceAccountCredentialsFile(String value);
+
+	/**
+	 * Returns the value of the '<em><b>Project Id</b></em>' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return the value of the '<em>Project Id</em>' attribute.
+	 * @see #setProjectId(String)
+	 * @see org.talend.core.model.metadata.builder.connection.ConnectionPackage#getBigQueryConnection_ProjectId()
+	 * @model
+	 * @generated
+	 */
+	String getProjectId();
+
+	/**
+	 * Sets the value of the '{@link org.talend.core.model.metadata.builder.connection.BigQueryConnection#getProjectId <em>Project Id</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @param value the new value of the '<em>Project Id</em>' attribute.
+	 * @see #getProjectId()
+	 * @generated
+	 */
+	void setProjectId(String value);
+
+	/**
+	 * Returns the value of the '<em><b>Use Region Endpoint</b></em>' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return the value of the '<em>Use Region Endpoint</em>' attribute.
+	 * @see #setUseRegionEndpoint(boolean)
+	 * @see org.talend.core.model.metadata.builder.connection.ConnectionPackage#getBigQueryConnection_UseRegionEndpoint()
+	 * @model
+	 * @generated
+	 */
+	boolean isUseRegionEndpoint();
+
+	/**
+	 * Sets the value of the '{@link org.talend.core.model.metadata.builder.connection.BigQueryConnection#isUseRegionEndpoint <em>Use Region Endpoint</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @param value the new value of the '<em>Use Region Endpoint</em>' attribute.
+	 * @see #isUseRegionEndpoint()
+	 * @generated
+	 */
+	void setUseRegionEndpoint(boolean value);
+
+	/**
+	 * Returns the value of the '<em><b>Region Endpoint</b></em>' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return the value of the '<em>Region Endpoint</em>' attribute.
+	 * @see #setRegionEndpoint(String)
+	 * @see org.talend.core.model.metadata.builder.connection.ConnectionPackage#getBigQueryConnection_RegionEndpoint()
+	 * @model
+	 * @generated
+	 */
+	String getRegionEndpoint();
+
+	/**
+	 * Sets the value of the '{@link org.talend.core.model.metadata.builder.connection.BigQueryConnection#getRegionEndpoint <em>Region Endpoint</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @param value the new value of the '<em>Region Endpoint</em>' attribute.
+	 * @see #getRegionEndpoint()
+	 * @generated
+	 */
+	void setRegionEndpoint(String value);
+
+} // BigQueryConnection

main/plugins/org.talend.model/src/main/java/org/talend/core/model/metadata/builder/connection/ConnectionFactory.java

@@ -15,472 +15,481 @@ import org.eclipse.emf.ecore.EFactory;
  */
 public interface ConnectionFactory extends EFactory {
 
-    /**
-     * The singleton instance of the factory.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @generated
-     */
-    ConnectionFactory eINSTANCE = org.talend.core.model.metadata.builder.connection.impl.ConnectionFactoryImpl.init();
+	/**
+	 * The singleton instance of the factory.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @generated
+	 */
+	ConnectionFactory eINSTANCE = org.talend.core.model.metadata.builder.connection.impl.ConnectionFactoryImpl.init();
 
-    /**
-     * Returns a new object of class '<em>Metadata</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Metadata</em>'.
-     * @generated
-     */
-    Metadata createMetadata();
+	/**
+	 * Returns a new object of class '<em>Metadata</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Metadata</em>'.
+	 * @generated
+	 */
+	Metadata createMetadata();
 
-    /**
-     * Returns a new object of class '<em>Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Connection</em>'.
-     * @generated
-     */
-    Connection createConnection();
+	/**
+	 * Returns a new object of class '<em>Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Connection</em>'.
+	 * @generated
+	 */
+	Connection createConnection();
 
-    /**
-     * Returns a new object of class '<em>Metadata Column</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Metadata Column</em>'.
-     * @generated
-     */
-    MetadataColumn createMetadataColumn();
+	/**
+	 * Returns a new object of class '<em>Metadata Column</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Metadata Column</em>'.
+	 * @generated
+	 */
+	MetadataColumn createMetadataColumn();
 
-    /**
-     * Returns a new object of class '<em>Metadata Table</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Metadata Table</em>'.
-     * @generated
-     */
-    MetadataTable createMetadataTable();
+	/**
+	 * Returns a new object of class '<em>Metadata Table</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Metadata Table</em>'.
+	 * @generated
+	 */
+	MetadataTable createMetadataTable();
 
-    /**
-     * Returns a new object of class '<em>Delimited File Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Delimited File Connection</em>'.
-     * @generated
-     */
-    DelimitedFileConnection createDelimitedFileConnection();
+	/**
+	 * Returns a new object of class '<em>Delimited File Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Delimited File Connection</em>'.
+	 * @generated
+	 */
+	DelimitedFileConnection createDelimitedFileConnection();
 
-    /**
-     * Returns a new object of class '<em>Positional File Connection</em>'. <!-- begin-user-doc --> <!-- end-user-doc
-     * -->
-     * 
-     * @return a new object of class '<em>Positional File Connection</em>'.
-     * @generated
-     */
-    PositionalFileConnection createPositionalFileConnection();
+	/**
+	 * Returns a new object of class '<em>Positional File Connection</em>'. <!-- begin-user-doc --> <!-- end-user-doc
+	 * -->
+	 * 
+	 * @return a new object of class '<em>Positional File Connection</em>'.
+	 * @generated
+	 */
+	PositionalFileConnection createPositionalFileConnection();
 
-    /**
-     * Returns a new object of class '<em>Ebcdic Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Ebcdic Connection</em>'.
-     * @generated
-     */
-    EbcdicConnection createEbcdicConnection();
+	/**
+	 * Returns a new object of class '<em>Ebcdic Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Ebcdic Connection</em>'.
+	 * @generated
+	 */
+	EbcdicConnection createEbcdicConnection();
 
-    /**
-     * Returns a new object of class '<em>MDM Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>MDM Connection</em>'.
-     * @generated
-     */
-    MDMConnection createMDMConnection();
+	/**
+	 * Returns a new object of class '<em>MDM Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>MDM Connection</em>'.
+	 * @generated
+	 */
+	MDMConnection createMDMConnection();
 
-    /**
-     * Returns a new object of class '<em>Database Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Database Connection</em>'.
-     * @generated
-     */
-    DatabaseConnection createDatabaseConnection();
+	/**
+	 * Returns a new object of class '<em>Database Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Database Connection</em>'.
+	 * @generated
+	 */
+	DatabaseConnection createDatabaseConnection();
 
-    /**
-     * Returns a new object of class '<em>SAP Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>SAP Connection</em>'.
-     * @generated
-     */
-    SAPConnection createSAPConnection();
+	/**
+	 * Returns a new object of class '<em>SAP Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAP Connection</em>'.
+	 * @generated
+	 */
+	SAPConnection createSAPConnection();
 
-    /**
-     * Returns a new object of class '<em>SAP Function Unit</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>SAP Function Unit</em>'.
-     * @generated
-     */
-    SAPFunctionUnit createSAPFunctionUnit();
+	/**
+	 * Returns a new object of class '<em>SAP Function Unit</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAP Function Unit</em>'.
+	 * @generated
+	 */
+	SAPFunctionUnit createSAPFunctionUnit();
 
-    /**
-     * Returns a new object of class '<em>SAPI Doc Unit</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>SAPI Doc Unit</em>'.
-     * @generated
-     */
-    SAPIDocUnit createSAPIDocUnit();
+	/**
+	 * Returns a new object of class '<em>SAPI Doc Unit</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAPI Doc Unit</em>'.
+	 * @generated
+	 */
+	SAPIDocUnit createSAPIDocUnit();
 
-    /**
-     * Returns a new object of class '<em>SAP Function Parameter Column</em>'. <!-- begin-user-doc --> <!-- end-user-doc
-     * -->
-     * 
-     * @return a new object of class '<em>SAP Function Parameter Column</em>'.
-     * @generated
-     */
-    SAPFunctionParameterColumn createSAPFunctionParameterColumn();
+	/**
+	 * Returns a new object of class '<em>SAP Function Parameter Column</em>'. <!-- begin-user-doc --> <!-- end-user-doc
+	 * -->
+	 * 
+	 * @return a new object of class '<em>SAP Function Parameter Column</em>'.
+	 * @generated
+	 */
+	SAPFunctionParameterColumn createSAPFunctionParameterColumn();
 
-    /**
-     * Returns a new object of class '<em>SAP Function Parameter Table</em>'. <!-- begin-user-doc --> <!-- end-user-doc
-     * -->
-     * 
-     * @return a new object of class '<em>SAP Function Parameter Table</em>'.
-     * @generated
-     */
-    SAPFunctionParameterTable createSAPFunctionParameterTable();
+	/**
+	 * Returns a new object of class '<em>SAP Function Parameter Table</em>'. <!-- begin-user-doc --> <!-- end-user-doc
+	 * -->
+	 * 
+	 * @return a new object of class '<em>SAP Function Parameter Table</em>'.
+	 * @generated
+	 */
+	SAPFunctionParameterTable createSAPFunctionParameterTable();
 
-    /**
-     * Returns a new object of class '<em>Input SAP Function Parameter Table</em>'.
-     * <!-- begin-user-doc --> <!--
-     * end-user-doc -->
-     * @return a new object of class '<em>Input SAP Function Parameter Table</em>'.
-     * @generated
-     */
-    InputSAPFunctionParameterTable createInputSAPFunctionParameterTable();
+	/**
+	 * Returns a new object of class '<em>Input SAP Function Parameter Table</em>'.
+	 * <!-- begin-user-doc --> <!--
+	 * end-user-doc -->
+	 * @return a new object of class '<em>Input SAP Function Parameter Table</em>'.
+	 * @generated
+	 */
+	InputSAPFunctionParameterTable createInputSAPFunctionParameterTable();
 
-    /**
-     * Returns a new object of class '<em>Output SAP Function Parameter Table</em>'.
-     * <!-- begin-user-doc --> <!--
-     * end-user-doc -->
-     * @return a new object of class '<em>Output SAP Function Parameter Table</em>'.
-     * @generated
-     */
-    OutputSAPFunctionParameterTable createOutputSAPFunctionParameterTable();
+	/**
+	 * Returns a new object of class '<em>Output SAP Function Parameter Table</em>'.
+	 * <!-- begin-user-doc --> <!--
+	 * end-user-doc -->
+	 * @return a new object of class '<em>Output SAP Function Parameter Table</em>'.
+	 * @generated
+	 */
+	OutputSAPFunctionParameterTable createOutputSAPFunctionParameterTable();
 
-    /**
-     * Returns a new object of class '<em>Regexp File Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Regexp File Connection</em>'.
-     * @generated
-     */
-    RegexpFileConnection createRegexpFileConnection();
+	/**
+	 * Returns a new object of class '<em>Regexp File Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Regexp File Connection</em>'.
+	 * @generated
+	 */
+	RegexpFileConnection createRegexpFileConnection();
 
-    /**
-     * Returns a new object of class '<em>Xml File Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Xml File Connection</em>'.
-     * @generated
-     */
-    XmlFileConnection createXmlFileConnection();
+	/**
+	 * Returns a new object of class '<em>Xml File Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Xml File Connection</em>'.
+	 * @generated
+	 */
+	XmlFileConnection createXmlFileConnection();
 
-    /**
-     * Returns a new object of class '<em>Schema Target</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Schema Target</em>'.
-     * @generated
-     */
-    SchemaTarget createSchemaTarget();
+	/**
+	 * Returns a new object of class '<em>Schema Target</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Schema Target</em>'.
+	 * @generated
+	 */
+	SchemaTarget createSchemaTarget();
 
-    /**
-     * Returns a new object of class '<em>Queries Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Queries Connection</em>'.
-     * @generated
-     */
-    QueriesConnection createQueriesConnection();
+	/**
+	 * Returns a new object of class '<em>Queries Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Queries Connection</em>'.
+	 * @generated
+	 */
+	QueriesConnection createQueriesConnection();
 
-    /**
-     * Returns a new object of class '<em>Query</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Query</em>'.
-     * @generated
-     */
-    Query createQuery();
+	/**
+	 * Returns a new object of class '<em>Query</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Query</em>'.
+	 * @generated
+	 */
+	Query createQuery();
 
-    /**
-     * Returns a new object of class '<em>Ldif File Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Ldif File Connection</em>'.
-     * @generated
-     */
-    LdifFileConnection createLdifFileConnection();
+	/**
+	 * Returns a new object of class '<em>Ldif File Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Ldif File Connection</em>'.
+	 * @generated
+	 */
+	LdifFileConnection createLdifFileConnection();
 
-    /**
-     * Returns a new object of class '<em>File Excel Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>File Excel Connection</em>'.
-     * @generated
-     */
-    FileExcelConnection createFileExcelConnection();
+	/**
+	 * Returns a new object of class '<em>File Excel Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>File Excel Connection</em>'.
+	 * @generated
+	 */
+	FileExcelConnection createFileExcelConnection();
 
-    /**
-     * Returns a new object of class '<em>Xml XPath Loop Descriptor</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Xml XPath Loop Descriptor</em>'.
-     * @generated
-     */
-    XmlXPathLoopDescriptor createXmlXPathLoopDescriptor();
+	/**
+	 * Returns a new object of class '<em>Xml XPath Loop Descriptor</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Xml XPath Loop Descriptor</em>'.
+	 * @generated
+	 */
+	XmlXPathLoopDescriptor createXmlXPathLoopDescriptor();
 
-    /**
-     * Returns a new object of class '<em>Generic Schema Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Generic Schema Connection</em>'.
-     * @generated
-     */
-    GenericSchemaConnection createGenericSchemaConnection();
+	/**
+	 * Returns a new object of class '<em>Generic Schema Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Generic Schema Connection</em>'.
+	 * @generated
+	 */
+	GenericSchemaConnection createGenericSchemaConnection();
 
-    /**
-     * Returns a new object of class '<em>LDAP Schema Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>LDAP Schema Connection</em>'.
-     * @generated
-     */
-    LDAPSchemaConnection createLDAPSchemaConnection();
+	/**
+	 * Returns a new object of class '<em>LDAP Schema Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>LDAP Schema Connection</em>'.
+	 * @generated
+	 */
+	LDAPSchemaConnection createLDAPSchemaConnection();
 
-    /**
-     * Returns a new object of class '<em>WSDL Schema Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>WSDL Schema Connection</em>'.
-     * @generated
-     */
-    WSDLSchemaConnection createWSDLSchemaConnection();
+	/**
+	 * Returns a new object of class '<em>WSDL Schema Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>WSDL Schema Connection</em>'.
+	 * @generated
+	 */
+	WSDLSchemaConnection createWSDLSchemaConnection();
 
-    /**
-     * Returns a new object of class '<em>Salesforce Schema Connection</em>'. <!-- begin-user-doc --> <!-- end-user-doc
-     * -->
-     * 
-     * @return a new object of class '<em>Salesforce Schema Connection</em>'.
-     * @generated
-     */
-    SalesforceSchemaConnection createSalesforceSchemaConnection();
+	/**
+	 * Returns a new object of class '<em>Salesforce Schema Connection</em>'. <!-- begin-user-doc --> <!-- end-user-doc
+	 * -->
+	 * 
+	 * @return a new object of class '<em>Salesforce Schema Connection</em>'.
+	 * @generated
+	 */
+	SalesforceSchemaConnection createSalesforceSchemaConnection();
 
-    /**
-     * Returns a new object of class '<em>CDC Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>CDC Connection</em>'.
-     * @generated
-     */
-    CDCConnection createCDCConnection();
+	/**
+	 * Returns a new object of class '<em>CDC Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>CDC Connection</em>'.
+	 * @generated
+	 */
+	CDCConnection createCDCConnection();
 
-    /**
-     * Returns a new object of class '<em>CDC Type</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>CDC Type</em>'.
-     * @generated
-     */
-    CDCType createCDCType();
+	/**
+	 * Returns a new object of class '<em>CDC Type</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>CDC Type</em>'.
+	 * @generated
+	 */
+	CDCType createCDCType();
 
-    /**
-     * Returns a new object of class '<em>Subscriber Table</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Subscriber Table</em>'.
-     * @generated
-     */
-    SubscriberTable createSubscriberTable();
+	/**
+	 * Returns a new object of class '<em>Subscriber Table</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Subscriber Table</em>'.
+	 * @generated
+	 */
+	SubscriberTable createSubscriberTable();
 
-    /**
-     * Returns a new object of class '<em>SAP Test Input Parameter Table</em>'.
-     * <!-- begin-user-doc --> <!--
-     * end-user-doc -->
-     * @return a new object of class '<em>SAP Test Input Parameter Table</em>'.
-     * @generated
-     */
-    SAPTestInputParameterTable createSAPTestInputParameterTable();
+	/**
+	 * Returns a new object of class '<em>SAP Test Input Parameter Table</em>'.
+	 * <!-- begin-user-doc --> <!--
+	 * end-user-doc -->
+	 * @return a new object of class '<em>SAP Test Input Parameter Table</em>'.
+	 * @generated
+	 */
+	SAPTestInputParameterTable createSAPTestInputParameterTable();
 
-    /**
-     * Returns a new object of class '<em>Concept</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Concept</em>'.
-     * @generated
-     */
-    Concept createConcept();
+	/**
+	 * Returns a new object of class '<em>Concept</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Concept</em>'.
+	 * @generated
+	 */
+	Concept createConcept();
 
-    /**
-     * Returns a new object of class '<em>Concept Target</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Concept Target</em>'.
-     * @generated
-     */
-    ConceptTarget createConceptTarget();
+	/**
+	 * Returns a new object of class '<em>Concept Target</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Concept Target</em>'.
+	 * @generated
+	 */
+	ConceptTarget createConceptTarget();
 
-    /**
-     * Returns a new object of class '<em>HL7 Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>HL7 Connection</em>'.
-     * @generated
-     */
-    HL7Connection createHL7Connection();
+	/**
+	 * Returns a new object of class '<em>HL7 Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>HL7 Connection</em>'.
+	 * @generated
+	 */
+	HL7Connection createHL7Connection();
 
-    /**
-     * Returns a new object of class '<em>Header Footer Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Header Footer Connection</em>'.
-     * @generated
-     */
-    HeaderFooterConnection createHeaderFooterConnection();
+	/**
+	 * Returns a new object of class '<em>Header Footer Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Header Footer Connection</em>'.
+	 * @generated
+	 */
+	HeaderFooterConnection createHeaderFooterConnection();
 
-    /**
-     * Returns a new object of class '<em>XML File Node</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>XML File Node</em>'.
-     * @generated
-     */
-    XMLFileNode createXMLFileNode();
+	/**
+	 * Returns a new object of class '<em>XML File Node</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>XML File Node</em>'.
+	 * @generated
+	 */
+	XMLFileNode createXMLFileNode();
 
-    /**
-     * Returns a new object of class '<em>WSDL Parameter</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>WSDL Parameter</em>'.
-     * @generated
-     */
-    WSDLParameter createWSDLParameter();
+	/**
+	 * Returns a new object of class '<em>WSDL Parameter</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>WSDL Parameter</em>'.
+	 * @generated
+	 */
+	WSDLParameter createWSDLParameter();
 
-    /**
-     * Returns a new object of class '<em>Generic Package</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Generic Package</em>'.
-     * @generated
-     */
-    GenericPackage createGenericPackage();
+	/**
+	 * Returns a new object of class '<em>Generic Package</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Generic Package</em>'.
+	 * @generated
+	 */
+	GenericPackage createGenericPackage();
 
-    /**
-     * Returns a new object of class '<em>HL7 File Node</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>HL7 File Node</em>'.
-     * @generated
-     */
-    HL7FileNode createHL7FileNode();
+	/**
+	 * Returns a new object of class '<em>HL7 File Node</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>HL7 File Node</em>'.
+	 * @generated
+	 */
+	HL7FileNode createHL7FileNode();
 
-    /**
-     * Returns a new object of class '<em>FTP Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>FTP Connection</em>'.
-     * @generated
-     */
-    FTPConnection createFTPConnection();
+	/**
+	 * Returns a new object of class '<em>FTP Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>FTP Connection</em>'.
+	 * @generated
+	 */
+	FTPConnection createFTPConnection();
 
-    /**
-     * Returns a new object of class '<em>BRMS Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>BRMS Connection</em>'.
-     * @generated
-     */
-    BRMSConnection createBRMSConnection();
+	/**
+	 * Returns a new object of class '<em>BRMS Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>BRMS Connection</em>'.
+	 * @generated
+	 */
+	BRMSConnection createBRMSConnection();
 
-    /**
-     * Returns a new object of class '<em>Condition Type</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Condition Type</em>'.
-     * @generated
-     */
-    ConditionType createConditionType();
+	/**
+	 * Returns a new object of class '<em>Condition Type</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Condition Type</em>'.
+	 * @generated
+	 */
+	ConditionType createConditionType();
 
-    /**
-     * Returns a new object of class '<em>EDIFACT Connection</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>EDIFACT Connection</em>'.
-     * @generated
-     */
-    EDIFACTConnection createEDIFACTConnection();
+	/**
+	 * Returns a new object of class '<em>EDIFACT Connection</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>EDIFACT Connection</em>'.
+	 * @generated
+	 */
+	EDIFACTConnection createEDIFACTConnection();
 
-    /**
-     * Returns a new object of class '<em>Salesforce Module Unit</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>Salesforce Module Unit</em>'.
-     * @generated
-     */
-    SalesforceModuleUnit createSalesforceModuleUnit();
+	/**
+	 * Returns a new object of class '<em>Salesforce Module Unit</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>Salesforce Module Unit</em>'.
+	 * @generated
+	 */
+	SalesforceModuleUnit createSalesforceModuleUnit();
 
-    /**
-     * Returns a new object of class '<em>SAP Table Field</em>'.
-     * <!-- begin-user-doc -->
-     * <!-- end-user-doc -->
-     * @return a new object of class '<em>SAP Table Field</em>'.
-     * @generated
-     */
-    SAPTableField createSAPTableField();
+	/**
+	 * Returns a new object of class '<em>SAP Table Field</em>'.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAP Table Field</em>'.
+	 * @generated
+	 */
+	SAPTableField createSAPTableField();
 
-    /**
-     * Returns a new object of class '<em>SAP Function Parameter</em>'.
-     * <!-- begin-user-doc -->
-     * <!-- end-user-doc -->
-     * @return a new object of class '<em>SAP Function Parameter</em>'.
-     * @generated
-     */
-    SAPFunctionParameter createSAPFunctionParameter();
+	/**
+	 * Returns a new object of class '<em>SAP Function Parameter</em>'.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAP Function Parameter</em>'.
+	 * @generated
+	 */
+	SAPFunctionParameter createSAPFunctionParameter();
 
-    /**
-     * Returns a new object of class '<em>SAP Function Param Data</em>'.
-     * <!-- begin-user-doc -->
-     * <!-- end-user-doc -->
-     * @return a new object of class '<em>SAP Function Param Data</em>'.
-     * @generated
-     */
-    SAPFunctionParamData createSAPFunctionParamData();
+	/**
+	 * Returns a new object of class '<em>SAP Function Param Data</em>'.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAP Function Param Data</em>'.
+	 * @generated
+	 */
+	SAPFunctionParamData createSAPFunctionParamData();
 
-    /**
-     * Returns a new object of class '<em>Additional Connection Property</em>'.
-     * <!-- begin-user-doc -->
-     * <!-- end-user-doc -->
-     * @return a new object of class '<em>Additional Connection Property</em>'.
-     * @generated
-     */
-    AdditionalConnectionProperty createAdditionalConnectionProperty();
+	/**
+	 * Returns a new object of class '<em>Additional Connection Property</em>'.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return a new object of class '<em>Additional Connection Property</em>'.
+	 * @generated
+	 */
+	AdditionalConnectionProperty createAdditionalConnectionProperty();
 
-    /**
-     * Returns a new object of class '<em>SAPBW Table</em>'.
-     * <!-- begin-user-doc -->
-     * <!-- end-user-doc -->
-     * @return a new object of class '<em>SAPBW Table</em>'.
-     * @generated
-     */
-    SAPBWTable createSAPBWTable();
+	/**
+	 * Returns a new object of class '<em>SAPBW Table</em>'.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAPBW Table</em>'.
+	 * @generated
+	 */
+	SAPBWTable createSAPBWTable();
 
-    /**
-     * Returns a new object of class '<em>SAPBW Table Field</em>'.
-     * <!-- begin-user-doc -->
-     * <!-- end-user-doc -->
-     * @return a new object of class '<em>SAPBW Table Field</em>'.
-     * @generated
-     */
-    SAPBWTableField createSAPBWTableField();
+	/**
+	 * Returns a new object of class '<em>SAPBW Table Field</em>'.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAPBW Table Field</em>'.
+	 * @generated
+	 */
+	SAPBWTableField createSAPBWTableField();
 
-    /**
-     * Returns a new object of class '<em>SAP Table</em>'.
-     * <!-- begin-user-doc -->
-     * <!-- end-user-doc -->
-     * @return a new object of class '<em>SAP Table</em>'.
-     * @generated
-     */
-    SAPTable createSAPTable();
+	/**
+	 * Returns a new object of class '<em>Big Query Connection</em>'.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return a new object of class '<em>Big Query Connection</em>'.
+	 * @generated
+	 */
+	BigQueryConnection createBigQueryConnection();
 
-    /**
-     * Returns a new object of class '<em>EDIFACT Column</em>'.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return a new object of class '<em>EDIFACT Column</em>'.
-     * @generated
-     */
-    EDIFACTColumn createEDIFACTColumn();
+	/**
+	 * Returns a new object of class '<em>SAP Table</em>'.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @return a new object of class '<em>SAP Table</em>'.
+	 * @generated
+	 */
+	SAPTable createSAPTable();
 
-    /**
-     * Returns a new object of class '<em>Validation Rules Connection</em>'. <!-- begin-user-doc --> <!-- end-user-doc
-     * -->
-     * 
-     * @return a new object of class '<em>Validation Rules Connection</em>'.
-     * @generated
-     */
-    ValidationRulesConnection createValidationRulesConnection();
+	/**
+	 * Returns a new object of class '<em>EDIFACT Column</em>'.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return a new object of class '<em>EDIFACT Column</em>'.
+	 * @generated
+	 */
+	EDIFACTColumn createEDIFACTColumn();
 
-    /**
-     * Returns the package supported by this factory.
-     * <!-- begin-user-doc --> <!-- end-user-doc -->
-     * @return the package supported by this factory.
-     * @generated
-     */
-    ConnectionPackage getConnectionPackage();
+	/**
+	 * Returns a new object of class '<em>Validation Rules Connection</em>'. <!-- begin-user-doc --> <!-- end-user-doc
+	 * -->
+	 * 
+	 * @return a new object of class '<em>Validation Rules Connection</em>'.
+	 * @generated
+	 */
+	ValidationRulesConnection createValidationRulesConnection();
 
-    /**
-     * copy this MetadataColumn.
-     * 
-     * @return
-     */
-    MetadataColumn copy(MetadataColumn column, String newId);
+	/**
+	 * Returns the package supported by this factory.
+	 * <!-- begin-user-doc --> <!-- end-user-doc -->
+	 * @return the package supported by this factory.
+	 * @generated
+	 */
+	ConnectionPackage getConnectionPackage();
+
+	/**
+	 * copy this MetadataColumn.
+	 * 
+	 * @return
+	 */
+	MetadataColumn copy(MetadataColumn column, String newId);
 } // ConnectionFactory

main/plugins/org.talend.model/src/main/java/org/talend/core/model/metadata/builder/connection/impl/BigQueryConnectionImpl.java

@@ -0,0 +1,333 @@
+/**
+ */
+package org.talend.core.model.metadata.builder.connection.impl;
+
+import org.eclipse.emf.common.notify.Notification;
+
+import org.eclipse.emf.ecore.EClass;
+
+import org.eclipse.emf.ecore.impl.ENotificationImpl;
+
+import org.talend.core.model.metadata.builder.connection.BigQueryConnection;
+import org.talend.core.model.metadata.builder.connection.ConnectionPackage;
+
+/**
+ * <!-- begin-user-doc -->
+ * An implementation of the model object '<em><b>Big Query Connection</b></em>'.
+ * <!-- end-user-doc -->
+ * <p>
+ * The following features are implemented:
+ * </p>
+ * <ul>
+ *   <li>{@link org.talend.core.model.metadata.builder.connection.impl.BigQueryConnectionImpl#getServiceAccountCredentialsFile <em>Service Account Credentials File</em>}</li>
+ *   <li>{@link org.talend.core.model.metadata.builder.connection.impl.BigQueryConnectionImpl#getProjectId <em>Project Id</em>}</li>
+ *   <li>{@link org.talend.core.model.metadata.builder.connection.impl.BigQueryConnectionImpl#isUseRegionEndpoint <em>Use Region Endpoint</em>}</li>
+ *   <li>{@link org.talend.core.model.metadata.builder.connection.impl.BigQueryConnectionImpl#getRegionEndpoint <em>Region Endpoint</em>}</li>
+ * </ul>
+ *
+ * @generated
+ */
+public class BigQueryConnectionImpl extends ConnectionImpl implements BigQueryConnection {
+	/**
+	 * The default value of the '{@link #getServiceAccountCredentialsFile() <em>Service Account Credentials File</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @see #getServiceAccountCredentialsFile()
+	 * @generated
+	 * @ordered
+	 */
+	protected static final String SERVICE_ACCOUNT_CREDENTIALS_FILE_EDEFAULT = null;
+
+	/**
+	 * The cached value of the '{@link #getServiceAccountCredentialsFile() <em>Service Account Credentials File</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @see #getServiceAccountCredentialsFile()
+	 * @generated
+	 * @ordered
+	 */
+	protected String serviceAccountCredentialsFile = SERVICE_ACCOUNT_CREDENTIALS_FILE_EDEFAULT;
+
+	/**
+	 * The default value of the '{@link #getProjectId() <em>Project Id</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @see #getProjectId()
+	 * @generated
+	 * @ordered
+	 */
+	protected static final String PROJECT_ID_EDEFAULT = null;
+
+	/**
+	 * The cached value of the '{@link #getProjectId() <em>Project Id</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @see #getProjectId()
+	 * @generated
+	 * @ordered
+	 */
+	protected String projectId = PROJECT_ID_EDEFAULT;
+
+	/**
+	 * The default value of the '{@link #isUseRegionEndpoint() <em>Use Region Endpoint</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @see #isUseRegionEndpoint()
+	 * @generated
+	 * @ordered
+	 */
+	protected static final boolean USE_REGION_ENDPOINT_EDEFAULT = false;
+
+	/**
+	 * The cached value of the '{@link #isUseRegionEndpoint() <em>Use Region Endpoint</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @see #isUseRegionEndpoint()
+	 * @generated
+	 * @ordered
+	 */
+	protected boolean useRegionEndpoint = USE_REGION_ENDPOINT_EDEFAULT;
+
+	/**
+	 * The default value of the '{@link #getRegionEndpoint() <em>Region Endpoint</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @see #getRegionEndpoint()
+	 * @generated
+	 * @ordered
+	 */
+	protected static final String REGION_ENDPOINT_EDEFAULT = null;
+
+	/**
+	 * The cached value of the '{@link #getRegionEndpoint() <em>Region Endpoint</em>}' attribute.
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @see #getRegionEndpoint()
+	 * @generated
+	 * @ordered
+	 */
+	protected String regionEndpoint = REGION_ENDPOINT_EDEFAULT;
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	protected BigQueryConnectionImpl() {
+		super();
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	@Override
+	protected EClass eStaticClass() {
+		return ConnectionPackage.Literals.BIG_QUERY_CONNECTION;
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	public String getServiceAccountCredentialsFile() {
+		return serviceAccountCredentialsFile;
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	public void setServiceAccountCredentialsFile(String newServiceAccountCredentialsFile) {
+		String oldServiceAccountCredentialsFile = serviceAccountCredentialsFile;
+		serviceAccountCredentialsFile = newServiceAccountCredentialsFile;
+		if (eNotificationRequired())
+			eNotify(new ENotificationImpl(this, Notification.SET,
+					ConnectionPackage.BIG_QUERY_CONNECTION__SERVICE_ACCOUNT_CREDENTIALS_FILE,
+					oldServiceAccountCredentialsFile, serviceAccountCredentialsFile));
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	public String getProjectId() {
+		return projectId;
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	public void setProjectId(String newProjectId) {
+		String oldProjectId = projectId;
+		projectId = newProjectId;
+		if (eNotificationRequired())
+			eNotify(new ENotificationImpl(this, Notification.SET, ConnectionPackage.BIG_QUERY_CONNECTION__PROJECT_ID,
+					oldProjectId, projectId));
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	public boolean isUseRegionEndpoint() {
+		return useRegionEndpoint;
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	public void setUseRegionEndpoint(boolean newUseRegionEndpoint) {
+		boolean oldUseRegionEndpoint = useRegionEndpoint;
+		useRegionEndpoint = newUseRegionEndpoint;
+		if (eNotificationRequired())
+			eNotify(new ENotificationImpl(this, Notification.SET,
+					ConnectionPackage.BIG_QUERY_CONNECTION__USE_REGION_ENDPOINT, oldUseRegionEndpoint,
+					useRegionEndpoint));
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	public String getRegionEndpoint() {
+		return regionEndpoint;
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	public void setRegionEndpoint(String newRegionEndpoint) {
+		String oldRegionEndpoint = regionEndpoint;
+		regionEndpoint = newRegionEndpoint;
+		if (eNotificationRequired())
+			eNotify(new ENotificationImpl(this, Notification.SET,
+					ConnectionPackage.BIG_QUERY_CONNECTION__REGION_ENDPOINT, oldRegionEndpoint, regionEndpoint));
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	@Override
+	public Object eGet(int featureID, boolean resolve, boolean coreType) {
+		switch (featureID) {
+		case ConnectionPackage.BIG_QUERY_CONNECTION__SERVICE_ACCOUNT_CREDENTIALS_FILE:
+			return getServiceAccountCredentialsFile();
+		case ConnectionPackage.BIG_QUERY_CONNECTION__PROJECT_ID:
+			return getProjectId();
+		case ConnectionPackage.BIG_QUERY_CONNECTION__USE_REGION_ENDPOINT:
+			return isUseRegionEndpoint();
+		case ConnectionPackage.BIG_QUERY_CONNECTION__REGION_ENDPOINT:
+			return getRegionEndpoint();
+		}
+		return super.eGet(featureID, resolve, coreType);
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	@Override
+	public void eSet(int featureID, Object newValue) {
+		switch (featureID) {
+		case ConnectionPackage.BIG_QUERY_CONNECTION__SERVICE_ACCOUNT_CREDENTIALS_FILE:
+			setServiceAccountCredentialsFile((String) newValue);
+			return;
+		case ConnectionPackage.BIG_QUERY_CONNECTION__PROJECT_ID:
+			setProjectId((String) newValue);
+			return;
+		case ConnectionPackage.BIG_QUERY_CONNECTION__USE_REGION_ENDPOINT:
+			setUseRegionEndpoint((Boolean) newValue);
+			return;
+		case ConnectionPackage.BIG_QUERY_CONNECTION__REGION_ENDPOINT:
+			setRegionEndpoint((String) newValue);
+			return;
+		}
+		super.eSet(featureID, newValue);
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	@Override
+	public void eUnset(int featureID) {
+		switch (featureID) {
+		case ConnectionPackage.BIG_QUERY_CONNECTION__SERVICE_ACCOUNT_CREDENTIALS_FILE:
+			setServiceAccountCredentialsFile(SERVICE_ACCOUNT_CREDENTIALS_FILE_EDEFAULT);
+			return;
+		case ConnectionPackage.BIG_QUERY_CONNECTION__PROJECT_ID:
+			setProjectId(PROJECT_ID_EDEFAULT);
+			return;
+		case ConnectionPackage.BIG_QUERY_CONNECTION__USE_REGION_ENDPOINT:
+			setUseRegionEndpoint(USE_REGION_ENDPOINT_EDEFAULT);
+			return;
+		case ConnectionPackage.BIG_QUERY_CONNECTION__REGION_ENDPOINT:
+			setRegionEndpoint(REGION_ENDPOINT_EDEFAULT);
+			return;
+		}
+		super.eUnset(featureID);
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	@Override
+	public boolean eIsSet(int featureID) {
+		switch (featureID) {
+		case ConnectionPackage.BIG_QUERY_CONNECTION__SERVICE_ACCOUNT_CREDENTIALS_FILE:
+			return SERVICE_ACCOUNT_CREDENTIALS_FILE_EDEFAULT == null ? serviceAccountCredentialsFile != null
+					: !SERVICE_ACCOUNT_CREDENTIALS_FILE_EDEFAULT.equals(serviceAccountCredentialsFile);
+		case ConnectionPackage.BIG_QUERY_CONNECTION__PROJECT_ID:
+			return PROJECT_ID_EDEFAULT == null ? projectId != null : !PROJECT_ID_EDEFAULT.equals(projectId);
+		case ConnectionPackage.BIG_QUERY_CONNECTION__USE_REGION_ENDPOINT:
+			return useRegionEndpoint != USE_REGION_ENDPOINT_EDEFAULT;
+		case ConnectionPackage.BIG_QUERY_CONNECTION__REGION_ENDPOINT:
+			return REGION_ENDPOINT_EDEFAULT == null ? regionEndpoint != null
+					: !REGION_ENDPOINT_EDEFAULT.equals(regionEndpoint);
+		}
+		return super.eIsSet(featureID);
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	@Override
+	public String toString() {
+		if (eIsProxy())
+			return super.toString();
+
+		StringBuilder result = new StringBuilder(super.toString());
+		result.append(" (ServiceAccountCredentialsFile: ");
+		result.append(serviceAccountCredentialsFile);
+		result.append(", ProjectId: ");
+		result.append(projectId);
+		result.append(", UseRegionEndpoint: ");
+		result.append(useRegionEndpoint);
+		result.append(", RegionEndpoint: ");
+		result.append(regionEndpoint);
+		result.append(')');
+		return result.toString();
+	}
+
+} //BigQueryConnectionImpl

main/plugins/org.talend.model/src/main/java/org/talend/core/model/metadata/builder/connection/validation/BigQueryConnectionValidator.java

@@ -0,0 +1,35 @@
+/**
+ *
+ * $Id$
+ */
+package org.talend.core.model.metadata.builder.connection.validation;
+
+/**
+ * A sample validator interface for {@link org.talend.core.model.metadata.builder.connection.BigQueryConnection}.
+ * This doesn't really do anything, and it's not a real EMF artifact.
+ * It was generated by the org.eclipse.emf.examples.generator.validator plug-in to illustrate how EMF's code generator can be extended.
+ * This can be disabled with -vmargs -Dorg.eclipse.emf.examples.generator.validator=false.
+ */
+public interface BigQueryConnectionValidator {
+	boolean validate();
+
+	boolean validateAccessToken(String value);
+
+	boolean validateServiceAccountCredentialsFile(String value);
+
+	boolean validateClientId(String value);
+
+	boolean validateClientSecret(String value);
+
+	boolean validateAuthorizationCode(String value);
+
+	boolean validateProjectId(String value);
+
+	boolean validateUseRegionEndpoint(boolean value);
+
+	boolean validateRegionEndpoint(String value);
+
+	boolean validateTokenFilePath(String value);
+
+	boolean validateAuthMode(String value);
+}

main/plugins/org.talend.model/src/main/java/org/talend/core/model/properties/BigQueryConnectionItem.java

@@ -0,0 +1,17 @@
+/**
+ */
+package org.talend.core.model.properties;
+
+
+/**
+ * <!-- begin-user-doc -->
+ * A representation of the model object '<em><b>Big Query Connection Item</b></em>'.
+ * <!-- end-user-doc -->
+ *
+ *
+ * @see org.talend.core.model.properties.PropertiesPackage#getBigQueryConnectionItem()
+ * @model
+ * @generated
+ */
+public interface BigQueryConnectionItem extends ConnectionItem {
+} // BigQueryConnectionItem

main/plugins/org.talend.model/src/main/java/org/talend/core/model/properties/impl/BigQueryConnectionItemImpl.java

@@ -0,0 +1,36 @@
+/**
+ */
+package org.talend.core.model.properties.impl;
+
+import org.eclipse.emf.ecore.EClass;
+
+import org.talend.core.model.properties.BigQueryConnectionItem;
+import org.talend.core.model.properties.PropertiesPackage;
+
+/**
+ * <!-- begin-user-doc -->
+ * An implementation of the model object '<em><b>Big Query Connection Item</b></em>'.
+ * <!-- end-user-doc -->
+ *
+ * @generated
+ */
+public class BigQueryConnectionItemImpl extends ConnectionItemImpl implements BigQueryConnectionItem {
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	protected BigQueryConnectionItemImpl() {
+		super();
+	}
+
+	/**
+	 * <!-- begin-user-doc -->
+	 * <!-- end-user-doc -->
+	 * @generated
+	 */
+	protected EClass eStaticClass() {
+		return PropertiesPackage.Literals.BIG_QUERY_CONNECTION_ITEM;
+	}
+
+} //BigQueryConnectionItemImpl

main/plugins/org.talend.model/src/main/java/org/talend/core/model/properties/validation/BigQueryConnectionItemValidator.java

@@ -0,0 +1,17 @@
+/**
+ *
+ * $Id$
+ */
+package org.talend.core.model.properties.validation;
+
+
+/**
+ * A sample validator interface for {@link org.talend.core.model.properties.BigQueryConnectionItem}.
+ * This doesn't really do anything, and it's not a real EMF artifact.
+ * It was generated by the org.eclipse.emf.examples.generator.validator plug-in to illustrate how EMF's code generator can be extended.
+ * This can be disabled with -vmargs -Dorg.eclipse.emf.examples.generator.validator=false.
+ */
+public interface BigQueryConnectionItemValidator {
+	boolean validate();
+
+}

main/plugins/org.talend.model/text/description.txt

@@ -1,31 +1,579 @@
-Model component_cache
+Model Metadata
 
 This model description is not a real EMF artifact. It was generated by the
 org.eclipse.emf.examples.generator.validator plug-in to illustrate how EMF's
 code generator can be extended.
 This can be disabled with -vmargs -Dorg.eclipse.emf.examples.generator.validator=false.
 
-Package component_cache <http://www.talend.org/component_cache>
+Package connection <http://www.talend.org/metadata/connection/2010>
 
-  Class ComponentsCache
-    Reference componentEntryMap : ComponentEntryMap<<0..*>>
+  Class Metadata -> AbstractMetadataObject
+    Reference connections : Connection<<0..*>>
 
-  Class ComponentInfo
-    Attribute originalFamilyName : EString
-    Attribute pluginExtension : EString
+  Class Connection -> AbstractMetadataObject, DataProvider
     Attribute version : EString
-    Attribute isTechnical : EBoolean
-    Attribute PluginDependencies : EString<<0..*>>
-    Attribute componentNames : EString<<0..*>>
-    Reference importType : IMPORTType<<0..*>>
-    Attribute isVisibleInComponentDefinition : EBoolean
-    Attribute uriString : EString
-    Attribute pathSource : EString
-    Attribute repositoryType : EString
-    Attribute sourceBundleName : EString
-    Attribute type : EString
-    Attribute providerId : EString
+    Reference queries : QueriesConnection
+    Attribute ContextMode : EBoolean
+    Attribute ContextId : EString
+    Attribute contextName : EString
+    Attribute compProperties : EString
+    Operation getConnectionTypeName() : String
 
-  Class ComponentEntryMap
+  Class MetadataColumn -> AbstractMetadataObject, Field
+    Attribute sourceType : EString
+    Attribute defaultValue : EString
+    Attribute talendType : EString
+    Attribute key : EBoolean
+    Attribute nullable : EBoolean
+    Reference /table : MetadataTable
+    Attribute originalField : EString
+    Attribute pattern : EString
+    Attribute displayField : EString
+    Attribute originalLength : Integer
+    Attribute relatedEntity : EString
+    Attribute relationshipType : EString
+
+  Class AbstractMetadataObject -> ModelElement
+    Attribute properties : Map<<1..1>>
+    Attribute id : EString
+    Attribute comment : EString
+    Attribute label : EString
+    Attribute readOnly : EBoolean
+    Attribute synchronised : EBoolean
+    Attribute divergency : EBoolean
+
+  Class MetadataTable -> AbstractMetadataObject, Class
+    Attribute sourceName : EString
+    Attribute tableType : EString
+    Attribute attachedCDC : EBoolean
+    Attribute activatedCDC : EBoolean
+    Reference /columns : MetadataColumn<<0..*>>
+    Reference connection : Connection
+    Reference additionalProperties : AdditionalProperties<<0..*>>
+
+  Class FileConnection -> Connection
+    Attribute Server : EString<<1..1>>
+    Attribute FilePath : EString<<1..1>>
+    Attribute Format : FileFormat<<1..1>>
+    Attribute Encoding : EString<<1..1>>
+    Attribute FieldSeparatorValue : EString<<1..1>>
+    Attribute RowSeparatorType : RowSeparator<<1..1>>
+    Attribute RowSeparatorValue : EString
+    Attribute TextIdentifier : EString
+    Attribute UseHeader : EBoolean
+    Attribute HeaderValue : EString
+    Attribute UseFooter : EBoolean
+    Attribute FooterValue : EString
+    Attribute UseLimit : EBoolean
+    Attribute LimitValue : EString
+    Attribute FirstLineCaption : EBoolean
+    Attribute RemoveEmptyRow : EBoolean
+    Attribute EscapeType : Escape<<1..1>>
+    Attribute EscapeChar : EString
+    Attribute TextEnclosure : EString
+    Attribute CsvOption : EBoolean
+
+  Class DelimitedFileConnection -> FileConnection
+    Attribute FieldSeparatorType : FieldSeparator<<1..1>>
+    Attribute splitRecord : EBoolean
+
+  Class PositionalFileConnection -> FileConnection
+
+  Class EbcdicConnection -> FileConnection
+    Attribute MidFile : EString
+    Attribute DataFile : EString
+    Attribute CodePage : EString
+    Attribute SourceFileStart : EString
+    Attribute SourceFileEnd : EString
+
+  Class MDMConnection -> Connection
+    Attribute Username : EString
+    Attribute Password : EString
+    Attribute Port : EString
+    Attribute Server : EString
+    Attribute Universe : EString
+    Attribute Datamodel : EString
+    Attribute Datacluster : EString
+    Reference schemas : Concept<<0..*>>
+    Attribute protocol : MDMConnectionProtocol<<1..1>>
+    Attribute context : String<<1..1>>
+    Attribute serverUrl : EString<<1..1>>
+    Operation getConnectionString() : String
+
+  Class DatabaseConnection -> Connection
+    Attribute DatabaseType : EString
+    Attribute DriverJarPath : EString
+    Attribute DriverClass : EString
+    Attribute URL : EString
+    Attribute dbVersionString : EString
+    Attribute Port : EString
+    Attribute Username : EString
+    Attribute Password : EString
+    Attribute ServerName : EString
+    Attribute DatasourceName : EString
+    Attribute FileFieldName : EString
+    Attribute SID : EString
+    Attribute SqlSynthax : EString
+    Attribute StringQuote : EString
+    Attribute NullChar : EString
+    Attribute DbmsId : EString
+    Attribute ProductId : EString
+    Attribute DBRootPath : EString
+    Attribute AdditionalParams : EString
+    Attribute StandardSQL : EBoolean
+    Attribute SystemSQL : EBoolean
+    Reference cdcConns : CDCConnection
+    Attribute cdcTypeMode : EString
+    Attribute SQLMode : EBoolean
+    Attribute UiSchema : EString
+    Reference parameters : AdditionalProperties<<0..*>>
+    Attribute supportNLS : EBoolean
+
+  Class SAPConnection -> Connection
+    Attribute Host : EString
+    Attribute Username : EString
+    Attribute Password : EString
+    Attribute Client : EString
+    Attribute SystemNumber : EString
+    Attribute Language : EString
+    Reference Funtions : SAPFunctionUnit<<0..*>>
+    Attribute currentFucntion : EString
+    Reference IDocs : SAPIDocUnit<<0..*>>
+    Attribute jcoVersion : EString
+    Reference additionalProperties : AdditionalConnectionProperty<<0..*>>
+    Reference BWAdvancedDataStoreObjects : SAPBWTable<<0..*>>
+    Reference BWDataSources : SAPBWTable<<0..*>>
+    Reference BWDataStoreObjects : SAPBWTable<<0..*>>
+    Reference BWInfoCubes : SAPBWTable<<0..*>>
+    Reference BWInfoObjects : SAPBWTable<<0..*>>
+
+  Class SAPFunctionUnit -> AbstractMetadataObject
+    Attribute OutputType : EString
+    Attribute OutputTableName : EString
+    Reference InputParameterTable : InputSAPFunctionParameterTable
+    Reference OutputParameterTable : OutputSAPFunctionParameterTable
+    Reference MetadataTable : MetadataTable
+    Reference connection : SAPConnection
+    Reference tables : MetadataTable<<0..*>>
+    Reference inputTables : MetadataTable<<0..*>>
+    Reference TestInputParameterTable : SAPTestInputParameterTable
+    Reference paramData : SAPFunctionParamData
+    Attribute asXmlSchema : EBoolean
+    Operation setDocument(String) : void
+
+  Class SAPIDocUnit -> AbstractMetadataObject
+    Reference connection : SAPConnection
+    Attribute programId : EString
+    Attribute gatewayService : EString
+    Attribute useXmlOutput : EBoolean
+    Attribute xmlFile : EString
+    Attribute useHtmlOutput : EBoolean
+    Attribute htmlFile : EString
+
+  Class SAPFunctionParameterColumn -> AbstractMetadataObject
+    Attribute ParameterType : EString
+    Attribute StructureOrTableName : EString
+    Attribute DataType : EString
+    Attribute Length : EString
+    Attribute Value : EString
+    Reference ParameterTable : SAPFunctionParameterTable
+    Operation setDescription(String) : void
+
+  Class SAPFunctionParameterTable -> AbstractMetadataObject
+    Reference columns : SAPFunctionParameterColumn<<0..*>>
+
+  Class InputSAPFunctionParameterTable -> SAPFunctionParameterTable
+    Reference functionUnit : SAPFunctionUnit
+
+  Class OutputSAPFunctionParameterTable -> SAPFunctionParameterTable
+    Reference functionUnit : SAPFunctionUnit
+
+  Class RegexpFileConnection -> FileConnection
+    Attribute FieldSeparatorType : FieldSeparator<<1..1>>
+
+  Class XmlFileConnection -> Connection
+    Attribute XsdFilePath : EString
+    Attribute XmlFilePath : EString
+    Attribute Guess : EBoolean
+    Attribute MaskXPattern : EString
+    Reference schema : XmlXPathLoopDescriptor<<0..*>>
+    Attribute Encoding : EString
+    Reference group : XMLFileNode<<0..*>>
+    Reference root : XMLFileNode<<0..*>>
+    Reference loop : XMLFileNode<<0..*>>
+    Attribute inputModel : EBoolean
+    Attribute outputFilePath : EString
+    Attribute fileContent : EByteArray
+    Attribute targetNameSpace : EString
+
+  Class SchemaTarget
+    Attribute RelativeXPathQuery : EString
+    Attribute TagName : EString
+    Reference schema : XmlXPathLoopDescriptor
+
+  Class QueriesConnection
+    Reference connection : Connection
+    Reference query : Query<<0..*>>
+
+  Class Query -> AbstractMetadataObject
+    Attribute value : EString
+    Reference queries : QueriesConnection
+    Attribute contextMode : EBoolean
+
+  Class LdifFileConnection -> Connection
+    Attribute value : EString<<0..*>>
+    Attribute FilePath : EString<<1..1>>
+    Attribute LimitEntry : EInt
+    Attribute UseLimit : EBoolean
+    Attribute Server : EString<<1..1>>
+
+  Class FileExcelConnection -> FileConnection
+    Attribute SheetName : EString<<1..1>>
+    Attribute sheetColumns : EString<<0..*>>
+    Attribute firstColumn : EString
+    Attribute lastColumn : EString
+    Attribute thousandSeparator : EString
+    Attribute decimalSeparator : EString
+    Attribute advancedSpearator : EBoolean
+    Attribute selectAllSheets : EBoolean
+    Attribute sheetList : List
+    Attribute generationMode : EString
+
+  Class XmlXPathLoopDescriptor
+    Attribute LimitBoucle : EIntegerObject
+    Attribute AbsoluteXPathQuery : EString
+    Reference connection : XmlFileConnection
+    Reference schemaTargets : SchemaTarget<<0..*>>
+
+  Class GenericSchemaConnection -> Connection
+    Attribute mappingTypeUsed : EBoolean
+    Attribute mappingTypeId : EString
+
+  Class LDAPSchemaConnection -> Connection
+    Attribute Host : EString
+    Attribute Port : EString
+    Attribute Protocol : EString
+    Attribute Filter : EString
+    Attribute Separator : EString
+    Attribute UseAdvanced : EBoolean
+    Attribute StorePath : EString
+    Attribute UseLimit : EBoolean
+    Attribute UseAuthen : EBoolean
+    Attribute BindPrincipal : EString
+    Attribute BindPassword : EString
+    Attribute LimitValue : EInt
+    Attribute EncryptionMethodName : EString
+    Attribute Value : EString<<0..*>>
+    Attribute SavePassword : EBoolean
+    Attribute Aliases : EString
+    Attribute Referrals : EString
+    Attribute CountLimit : EString
+    Attribute TimeOutLimit : EString
+    Attribute BaseDNs : EString<<0..*>>
+    Attribute GetBaseDNsFromRoot : EBoolean
+    Attribute ReturnAttributes : EString<<0..*>>
+    Attribute SelectedDN : EString
+
+  Class WSDLSchemaConnection -> Connection
+    Attribute WSDL : EString
+    Attribute needAuth : EBoolean
+    Attribute methodName : EString
+    Attribute parameters : List
+    Attribute UserName : EString
+    Attribute Password : EString
+    Attribute useProxy : EBoolean
+    Attribute proxyHost : EString
+    Attribute proxyPort : EString
+    Attribute proxyUser : EString
+    Attribute proxyPassword : EString
+    Attribute Value : EString<<0..*>>
+    Attribute EndpointURI : EString
+    Attribute Encoding : EString
+    Attribute timeOut : EInt
+    Attribute isInputModel : EBoolean
+    Attribute serverNameSpace : EString
+    Attribute serverName : EString
+    Attribute portNameSpace : EString
+    Attribute portName : EString
+    Reference parameterValue : WSDLParameter<<0..*>>
+    Reference outputParameter : WSDLParameter<<0..*>>
+
+  Class SalesforceSchemaConnection -> Connection
+    Attribute webServiceUrl : EString
+    Attribute userName : EString
+    Attribute password : EString
+    Attribute moduleName : EString
+    Attribute queryCondition : EString
+    Attribute useCustomModuleName : EBoolean
+    Attribute useProxy : EBoolean
+    Attribute proxyHost : EString
+    Attribute proxyPort : EString
+    Attribute proxyUsername : EString
+    Attribute proxyPassword : EString
+    Attribute batchSize : EString
+    Attribute useHttpProxy : EBoolean
+    Attribute useAlphbet : EBoolean
+    Attribute timeOut : EString
+    Reference modules : SalesforceModuleUnit<<0..*>>
+    Attribute webServiceUrlTextForOAuth : EString
+    Attribute consumeKey : EString
+    Attribute consumeSecret : EString
+    Attribute callbackHost : EString
+    Attribute callbackPort : EString
+    Attribute salesforceVersion : EString
+    Attribute token : EString
+    Attribute loginType : EString
+
+  Class CDCConnection
+    Reference connection : DatabaseConnection
+    Reference cdcTypes : CDCType<<0..*>>
+
+  Class CDCType -> AbstractMetadataObject
+    Attribute linkDB : EString
+    Reference subscribers : SubscriberTable<<0..*>>
+    Reference cdcConnection : CDCConnection
+    Attribute journalName : EString
+
+  Class SubscriberTable -> TdTable
+    Attribute system : EBoolean
+
+  Class SAPTestInputParameterTable -> SAPFunctionParameterTable
+    Reference functionUnit : SAPFunctionUnit
+
+  Class Concept -> TdTable
+    Attribute LoopExpression : EString
+    Attribute LoopLimit : EIntegerObject
+    Reference conceptTargets : ConceptTarget<<0..*>>
+    Attribute inputModel : EBoolean
+    Reference group : XMLFileNode<<0..*>>
+    Reference root : XMLFileNode<<0..*>>
+    Reference loop : XMLFileNode<<0..*>>
+    Attribute conceptType : MdmConceptType<<1..1>>
+    Attribute xPathPrefix : EString
+
+  Class ConceptTarget
+    Reference schema : Concept
+    Attribute targetName : EString
+    Attribute RelativeLoopExpression : EString
+
+  Class HL7Connection -> FileConnection
+    Attribute StartChar : EString
+    Attribute EndChar : EString
+    Reference root : HL7FileNode<<0..*>>
+    Attribute outputFilePath : EString
+
+  Class HeaderFooterConnection -> Connection
+    Attribute isHeader : EBoolean
+    Attribute imports : EString
+    Attribute mainCode : EString
+    Attribute libraries : EString
+
+  Class XMLFileNode
+    Attribute XMLPath : EString
+    Attribute RelatedColumn : EString
+    Attribute DefaultValue : EString
+    Attribute Attribute : EString
+    Attribute Order : EInt
+    Attribute Type : EString
+
+  Class WSDLParameter
+    Attribute Element : EString
+    Attribute source : EString
+    Attribute Column : EString
+    Attribute Expression : EString
+    Attribute ParameterInfo : EString
+    Attribute ParameterInfoParent : EString
+
+  Class GenericPackage -> Package
+
+  Class HL7FileNode
+    Attribute FilePath : EString
+    Attribute Order : EInt
+    Attribute Attribute : EString
+    Attribute DefaultValue : EString
+    Attribute RelatedColumn : EString
+    Attribute Repeatable : EBoolean
+
+  Class FTPConnection -> Connection
+    Attribute Host : EString
+    Attribute Port : EString
+    Attribute Username : EString
+    Attribute Password : EString
+    Attribute Mode : EString
+    Attribute Ecoding : EString
+    Attribute SFTP : EBoolean
+    Attribute FTPS : EBoolean
+    Attribute Method : EString
+    Attribute Privatekey : EString
+    Attribute Passphrase : EString
+    Attribute KeystoreFile : EString
+    Attribute KeystorePassword : EString
+    Attribute Usesocks : EBoolean
+    Attribute Proxyhost : EString
+    Attribute Proxyport : EString
+    Attribute Proxyuser : EString
+    Attribute Proxypassword : EString
+    Attribute CustomEncode : EString
+    Attribute UseFileNameEncoding : EBoolean
+    Attribute Timeout : EString
+
+  Class BRMSConnection -> Connection
+    Attribute xmlField : EString
+    Attribute urlName : EString
+    Attribute tacWebappName : EString
+    Attribute className : EString
+    Attribute moduleUsed : EString
+    Reference root : XMLFileNode<<0..*>>
+    Reference group : XMLFileNode<<0..*>>
+    Reference loop : XMLFileNode<<0..*>>
+    Attribute package : EString
+
+  Class ValidationRulesConnection -> Connection
+    Attribute isSelect : EBoolean
+    Attribute isInsert : EBoolean
+    Attribute isUpdate : EBoolean
+    Attribute isDelete : EBoolean
+    Attribute type : RuleType
+    Attribute baseSchema : EString
+    Attribute baseColumnNames : EString<<0..*>>
+    Attribute refSchema : EString
+    Attribute refColumnNames : EString<<0..*>>
+    Attribute javaCondition : EString
+    Attribute sqlCondition : EString
+    Attribute logicalOperator : LogicalOperator
+    Reference conditions : ConditionType<<0..*>>
+    Reference innerJoins : InnerJoinMap<<0..*>>
+    Attribute isDisallow : EBoolean
+    Attribute isRejectLink : EBoolean
+
+  Class ConditionType
+    Attribute inputColumn : EString<<1..1>>
+    Attribute function : Function<<1..1>>
+    Attribute operator : Operator<<1..1>>
+    Attribute value : EString
+
+  Class InnerJoinMap
     Attribute key : EString
-    Reference value : ComponentInfo<<0..*>>
+    Attribute value : EString
+
+  Class EDIFACTConnection -> Connection
+    Attribute XmlName : EString
+    Attribute FileName : EString
+    Attribute XmlPath : EString
+
+  Class EDIFACTColumn -> MetadataColumn
+    Attribute EDIColumnName : EString
+    Attribute EDIXpath : EString
+
+  Class SalesforceModuleUnit -> AbstractMetadataObject
+    Reference MetadataTable : MetadataTable
+    Reference connection : SalesforceSchemaConnection
+    Reference tables : MetadataTable<<0..*>>
+    Attribute moduleName : EString
+
+  Class AdditionalProperties
+    Attribute key : EString
+    Attribute value : EString
+
+  Class SAPTable -> MetadataTable
+    Attribute tableSearchType : EString
+
+  Class SAPTableField -> MetadataColumn
+    Attribute businessName : EString
+    Attribute refTable : EString<<0..*>>
+
+  Class SAPFunctionParameter
+    Attribute name : EString
+    Attribute type : EString
+    Attribute description : EString
+    Attribute length : EString
+    Attribute changing : EBoolean
+    Attribute testValue : EString
+    Reference children : SAPFunctionParameter<<0..*>>
+    Attribute tableResideInTables : EBoolean
+
+  Class SAPFunctionParamData
+    Reference inputRoot : SAPFunctionParameter
+    Reference outputRoot : SAPFunctionParameter
+
+  Class AdditionalConnectionProperty
+    Attribute propertyName : EString
+    Attribute Value : EString
+
+  Class SAPBWTable -> SAPTable
+    Attribute modelType : EString
+    Attribute active : EBoolean
+    Attribute sourceSystemName : EString
+    Attribute infoAreaName : EString
+    Attribute innerIOType : EString
+    Attribute category : EString
+
+  Class SAPBWTableField -> SAPTableField
+    Attribute logicalName : EString
+
+  Class BigQueryConnection -> Connection
+    Attribute ServiceAccountCredentialsFile : EString
+    Attribute ProjectId : EString
+    Attribute UseRegionEndpoint : EBoolean
+    Attribute RegionEndpoint : EString
+
+  Enum FileFormat
+    Literal UNIX = 0
+    Literal MAC = 1
+    Literal WINDOWS = 2
+
+  Enum FieldSeparator
+    Literal Tabulation = 0
+    Literal Semicolon = 1
+    Literal Comma = 2
+    Literal Space = 3
+    Literal Alt_65 = 4
+    Literal Custom_ANSI = 5
+    Literal Custom_UTF8 = 6
+    Literal Custom_RegExp = 7
+
+  Enum Escape
+    Literal Delimited = 1
+    Literal CSV = 0
+
+  Enum RowSeparator
+    Literal Custom_String = 0
+    Literal Standart_EOL = 1
+
+  Enum MDMConnectionProtocol
+    Literal HTTP = 0
+
+  Enum MdmConceptType
+    Literal INPUT = 0
+    Literal OUTPUT = 1
+    Literal RECEIVE = 2
+
+  Enum RuleType
+    Literal REFERENCE = 0
+    Literal BASIC = 1
+    Literal CUSTOM = 2
+
+  Enum Function
+    Literal Empty = 0
+    Literal Lower_case = 1
+    Literal Upper_case = 2
+    Literal Lower_case_first = 3
+    Literal Upper_case_first = 4
+    Literal Length = 5
+    Literal Match = 6
+
+  Enum Operator
+    Literal Equals = 0
+    Literal Not_equals = 1
+    Literal Greater = 2
+    Literal Lower = 3
+    Literal Greater_or_equals = 4
+    Literal Lower_or_equals = 5
+
+  Enum LogicalOperator
+    Literal And = 0
+    Literal Or = 1
+
+  DataType Map <java.util.HashMap>
+
+  DataType List <java.util.ArrayList>

main/plugins/org.talend.presentation.onboarding/META-INF/MANIFEST.MF

@@ -20,7 +20,8 @@ Require-Bundle: org.apache.log4j,
  org.eclipse.ui.workbench,
  org.talend.libraries.jackson,
  org.w3c.css.sac,
- org.apache.commons.lang
+ org.apache.commons.lang,
+ org.talend.core.runtime
 Bundle-ActivationPolicy: lazy
 Export-Package: org.talend.presentation.onboarding.interfaces,
  org.talend.presentation.onboarding.ui.managers,

main/plugins/org.talend.presentation.onboarding/build.properties

@@ -5,6 +5,7 @@ bin.includes = META-INF/,\
                plugin.xml,\
                build.properties,\
                content/,\
+               icons/,\
                schema/,\
                plugin.properties,\
                plugin_fr.properties,\