FTP Connections

DSS Connection name	Host	Port	User	Password	Freely usable by	Purpose	For servers
mercatoelettrico	download.mercatoelettrico.org	21	PIERLUIGIDELI	5L17D10G	Soda Ash (Rosignano Site)	Electricity information from the energy provider for the Soda Ash Rosignano plant in Italy	All
engie_ROSEN	ftp01.gdfsuez.it	21	SRV-TEMPERATURE	Engie01102018	Soda Ash (Rosignano Site)	ENGIE energy production predictions & actuals for the cogenerator	All

MS SQL Servers

DSS Connection name	Host	Port	Instance	Database	User	Password	Freely usable by	Purpose	Owner
Public-SQL-DSS-Test	wdcpabp21.eua.solvay.com	51248	WDCPABP21\PACM_DBPRD	DATAIKU-Public-test	dss-public-writer-test	39Okl4vRVZJd	All (test serv)	For any user in the test environment to use.
Confidential-SQL-DSS-Test	wdcpabp21.eua.solvay.com	51248	WDCPABP21\PACM_DBPRD	DATAIKU-Confidential-test	DATAIKU-Confidential-test	Hmrf4XBU2YbC	Case by case.	For tests on confidential data.
Public-SQL-DSS	wdcpabp21.eua.solvay.com	51248	WDCPABP21\PACM_DBPRD	DATAIKU-Public-prod	dss-public-writer-prod	1e4WtR8xTnCY	All (Prod serv)	For all to use on non-confidential data
Confidential-SQL-DSS-Prod	wdcpabp21.eua.solvay.com	51248	WDCPABP21\PACM_DBPRD	DATAIKU-Confidential-prod	dss-confidential-writer-prod	7sQuBLS4f6l4	Case by case.	To use for cases where data is more confidential
PACM_TST	wdcpabp21.eua.solvay.com	51248		PACM_DBTST	PACM_TST	vh%6ZK*D	SBS BD&A	Test DB for Predictive Credit Management
PACM_PRD	wdcpabp21.eua.solvay.com	51248		PACM_DBPRD	PACM_PRD	PACM567w@r	SBS BD&A	Production DB for Predictive Credit Management
winlims_report_prod	150.251.112.240	50465	WDCSLVBP32\WL_DBPRD	WEBLIMS	REPORT_WBLMS	Report13	Novecare	Access to the Weblims novecare (quality lab results)	Philppe Neyrval

Connection Name	GCP Project	Service Account	Private Key Path	BigQuery Link	GCP Project Link	Purpose	Usable by
BQ_Prognoz_Datalab	solvay-data-catalog-lab	dataiku-bigquery@solvay-data-catalog-lab.iam.gserviceaccount.com	/home/dataiku/dss_data/solvay-data-catalog-lab-902a39fa014b.json	https://bigquery.cloud.google.com/welcome/solvay-data-catalog-lab	https://console.cloud.google.com/home/dashboard?project=solvay-data-catalog-lab	Production database for ECI Data Catalog	Every Analyst
BigQuery_Sandbox	bi-gcp-sandbox	dss-bigquery@bi-gcp-sandbox.iam.gserviceaccount.com	/home/dataiku/ GServiceAccounts/dss-bigquery@bi-gcp-sandbox.json	https://bigquery.cloud.google.com/welcome/bi-gcp-sandbox		Connector initially set up for SES (meteoFrance)

Connection Name	Host	Database	Port	User	Password	Usable by	Purpose	For server
SES_VENDOHM	35.195.227.102	warehouse	5432	postgre	<ENGUERRAN TO COMPLETE>	All analyses	Access to Energy Services Vendohm energy datasets	All