on premise airbyte can connect to on premise vertica database ?

Yes, on-premise Airbyte can connect to an on-premise Vertica database. You will need to set up the Vertica connector in Airbyte and choose an existing database or create a new one that will be used to store synced data from Airbyte [source](https://docs.airbyte.com/integrations/destinations/vertica). To use the Vertica destination, you'll need a Vertica server version 11.0 or above. You'll also need the following information to configure the Vertica destination: - Host - The host name of the server. - Port - The port number the server is listening on. Defaults to the VSQL™ standard port number (5433). - Username - Password - Default Schema Name - Database - JDBC URL Params (optional) You also need to ensure your Vertica database can be accessed by Airbyte. If your database is within a VPC, you may need to allow access from the IP you're using to expose Airbyte [source](https://docs.airbyte.com/integrations/destinations/vertica). You also need a Vertica user with the permissions to create tables, write rows, and create schemas. You can create such a user by running the following commands:

sql CREATE USER airbyte_user WITH PASSWORD '<password>';   GRANT CREATE, TEMPORARY ON DATABASE <database> TO airbyte_user;

[source](https://docs.airbyte.com/integrations/destinations/vertica) Please note that the Vertica destination connector supports Full Refresh Sync but does not support Incremental - Append Sync, Incremental - Append + Deduped, and Namespaces [source](https://docs.airbyte.com/integrations/destinations/vertica).

on premise airbyte can fetch data from the following datasource? - mongo DB - maaria DB - Microsoft SQL - SAP (ERP) - amplitude

Sorry @Muhammad Umar Iqbal, I seem to be having a bit of trouble. Don't worry though, I've pinged my support folks and they will try to fix me up! 🧑‍💻 Perhaps try again in 5mins?