FTP Connections

DSS Connection nameHostPortUserPasswordFreely usable byPurposeFor servers

mercatoelettrico

download.mercatoelettrico.org21PIERLUIGIDELI5L17D10GSoda Ash (Rosignano Site)Electricity information from the energy provider for the Soda Ash Rosignano plant in Italy All

engie_ROSEN

ftp01.gdfsuez.it21SRV-TEMPERATUREEngie01102018
Soda Ash (Rosignano Site)ENGIE energy production predictions & actuals for the cogenerator

All


T_GN_ftpwdcwmap11.eua.solvay.com8000MESUser????Administrators

SFTP Connections

DSS Connection nameHostPortUserPasswordFreely usable byPurposeFor servers

SAP_BW_WBD_dev

wbdsapr3.ibm.be.solvay.com22sftpbwfea62JajSBS BD&ARead and Write BW filesAll

SAP_BW_WBQ_quality

wbqsapr3.ibm.be.solvay.com22sftpbwfea62JajSBS BD&ARead and Write BW files (Novecare Data Cleaning)All

SAP_BW_WBP_prod

wbpsapr3.ibm.be.solvay.com22sftpbw
fea62JajSBS BD&ARead and Write BW files (Novecare Data Cleaning)

All


EEX-Group-Bernburgsftp.datasource.eex-group.com22EEX_6719????Every Analyst

T_GN_sftpwdcwmap11.eua.solvay.com8000MESUser????Soda_Ash_Torrelavega

Test_PP2_SSHpp222sftptnld????BDA_SBS

Test_SFTP_MDFpp222BE001637????BDA_SB


PF1_prod_SFTPpf1sapr3.ibm.be.solvay.com22sftpdtkuutLCrmN88administratorsRead SAP reportsIBM


BW accounts

EnvironmentHostPortUserPasswordFreely usable byPurposeFor servers

SAP_BW_WBD_dev

wbqsapr332BCAST03Welcome2020SBS BD&Acall SAP functions with pyRFC (Novecare Data Cleaning)All

SAP_BW_WBQ_quality

wbqsapr332BCAST03Welcome2020SBS BD&Acall SAP functions with pyRFC (Novecare Data Cleaning)All

SAP_BW_WBP_prod

wbpsapr300BCAST03Welcome2020
SBS BD&Acall SAP functions with pyRFC (Novecare Data Cleaning)

All


MS SQL Servers

DSS Connection nameHostPortInstanceDatabaseUserPasswordFreely usable byPurposeOwner

Public-SQL-DSS-Test

wdcpabp21.eua.solvay.com51248WDCPABP21\PACM_DBPRDDATAIKU-Public-testdss-public-writer-test39Okl4vRVZJdAll (test serv)For any user in the test environment to use.
Confidential-SQL-DSS-Testwdcpabp21.eua.solvay.com51248WDCPABP21\PACM_DBPRDDATAIKU-Confidential-testDATAIKU-Confidential-testHmrf4XBU2YbCCase by case.For tests on confidential data.
Public-SQL-DSSWDCSLVBP31.eua.solvay.com50996
WDCPABP21\PACM_DBPRDDATAIKU-Public-proddss-public-writer-prod1e4WtR8xTnCYAll (Prod serv)For all to use on non-confidential data
Confidential-SQL-DSS-Prodwdcpabp21.eua.solvay.com51248WDCPABP21\PACM_DBPRDDATAIKU-Confidential-proddss-confidential-writer-prod7sQuBLS4f6l4Case by case.To use for cases where data is more confidential

PACM_TST

wdcpabp21.eua.solvay.com51248
PACM_DBTSTPACM_TSTvh%6ZK*DSBS BD&ATest DB for Predictive Credit Management

PACM_PRD

wdcpabp21.eua.solvay.com51248
PACM_DBPRDPACM_PRDPACM567w@rSBS BD&AProduction DB for Predictive Credit Management

winlims_report_prod

 150.251.112.24050465WDCSLVBP32\WL_DBPRD WEBLIMSREPORT_WBLMSReport13 NovecareAccess to the Weblims novecare (quality lab results)Philppe Neyrval
CemLab10.80.94.51-1SQLEXPRESSCEMLabDBANALYTIC1????RI

Dynasys_ForecastingWDCSLVBD31.eua.solvay.com-1SLV1_DBDEVDYNASYS_ITFdataiku_ds????BDA_SBS

ELD_SESWDCSLVBP31.eua.solvay.com-1SLV1_DBPRDELDSESELDSES_Read????SES_Agregat

ENERGY_PRODWDCSLVBP31.eua.solvay.com-1SLV1_DBPRDENERGYDispatching????SES_Agregat

ENERGY_TESTWDCSLVBT31.eua.solvay.com-1SLV1_DBTSTENERGY_TSTDispatching????SES_Agregat

NonPublic-SQL-DSS-ProdWDCSLVBP31.eua.solvay.com50996WDCSLVBP31\SLV1_DBPRDDATAIKU-Confidential-proddss-confidential-writer-prod????NonPublic_DSS

SES_DBDEVWDCSLVBD31.eua.solvay.com-1SLV1_DBDEVDATALAKE_SESSwanLake_SES????SES_Agregat

SES_DBPRDWDCSLVBP31.eua.solvay.com-1SLV1_DBPRDDATALAKE_SESSwanLake_SES????SES_Agregat

SES_DBTSTWDCSLVBT31.eua.solvay.com-1SLV1_DBTSTDATALAKE_SESSwanLake_SES????SES_Agregat

YOU_CL-PRDnohdc31e3306
you_prodfriedman.michael????administrators

Salesforce (with dataiku plugin)

Connection NameClient IDClient SecretAccount EmailPasswordSecurity TokenPurposeUsable byRemarks
SalesForce UAT3MVG9GXbtnGKjXe6zGleLik_LumtFPmJcODNYV4ImdX9j_10jVmH2piW4yu4mIGRn7uHFVpawZN2swVxcVUfp0DF933019B210BFF7998EAF37D632035476D15320D4A8BBD2F69BC5F3A99A622daitaku.integration@solvay.com.crm.uat1wn7btc8iy'' (blank)read and update accountsSBS BD&A
SalesForce (Prod)3MVG9GXbtnGKjXe6zGleLik_LumtFPmJcODNYV4ImdX9j_10jVmH2piW4yu4mIGRn7uHFVpawZN2swVxcVUfp0DF933019B210BFF7998EAF37D632035476D15320D4A8BBD2F69BC5F3A99A622daitaku.integration@solvay.com.crm1wn7btc8iy'' (blank)read and update accountsSBS BD&A

SalesForce (Prod)

rq: connection actually used as of 2022/03/11

3MVG9GXbtnGKjXe6zGleLik_LumtFPmJcODNYV4ImdX9j_10jVmH2piW4yu4mIGRn7uHFVpawZN2swVxcVUfp0DF933019B210BFF7998EAF37D632035476D15320D4A8BBD2F69BC5F3A99A622dataiku@solvay.com.sppNDVctbMKiwrfhrXV1'' (blank)
update plugin to v1.2.1 to allow blank		read and update accountsSBS BD&Aleave "sandbox instance?" checkbox unchecked

BigQuery

Connection NameGCP ProjectService AccountPrivate Key PathBigQuery LinkGCP Project LinkPurposeUsable by

BQ_Prognoz_Datalab

solvay-data-catalog-labdataiku-bigquery@solvay-data-catalog-lab.iam.gserviceaccount.com/home/dataiku/dss_data/solvay-data-catalog-lab-902a39fa014b.jsonhttps://bigquery.cloud.google.com/welcome/solvay-data-catalog-labhttps://console.cloud.google.com/home/dashboard?project=solvay-data-catalog-labProduction database for ECI Data CatalogEvery Analyst

BigQuery_Sandbox

bi-gcp-sandboxdss-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)



BigQuery_AppVisibility_Devsolvay-dev-sbs-app-visibilitydss-bigquery@solvay-dev-sbs-app-visibility.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dss-bigquery@solvay-dev-sbs-app-visibility.jsonhttps://bigquery.cloud.google.com/welcome/solvay-dev-sbs-app-visibility

BDA_SBS
BigQuery-Industrial-Prod-SodaAsh-Rosignanosolvay-ind-conso-prodsoda-ash-rosignano@solvay-ind-conso-prod.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/solvay-ind-conso-prod-a1a5c4d08908.jsonhttps://bigquery.cloud.google.com/welcome/solvay-ind-conso-prod
Rosignano Prod

Soda_Ash


BigQuery_ECI_labsolvay-data-catalog-labdataiku-bigquery@solvay-data-catalog-lab.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dataiku-bigquery@solvay-data-catalog-lab.json


ECI
BigQuery_ECI_Prodsolvay-data-catalog-proddataiku-bigquery@solvay-data-catalog-prod.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dataiku-bigquery@solvay-data-catalog-prod.json


ECI


BigQuery_IOT_Datalake_Devsolvay-iot-datalake-devdss-bigquery@solvay-iot-datalake-dev.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dss-bigquery@solvay-iot-datalake-dev.json


Every Analyst
BigQuery_MES_CONSOLIDATION_GCP_SANDBOXmes-consolidation-gcp-sandboxros-so-reader@mes-consolidation-gcp-sandbox.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/ros-so-reader@mes-consolidation-gcp-sandbox.json


Industrial
BigQuery_PCM_Devpredict-credit-mgt-v2-devdss-bigquery@predict-credit-mgt-v2-dev.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dss-bigquery@predict-credit-mgt-v2-dev.json


BDA_SBS
BigQuery_predict-credit-mgt-v2-devpredict-credit-mgt-v2-devdss-bigquery@predict-credit-mgt-v2-dev.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dss-bigquery@predict-credit-mgt-v2-dev.json


SBSOTCCM
BigQuery_predict-credit-mgt-v2-preprodpredict-credit-mgt-v2-preproddss-bigquery@predict-credit-mgt-v2-preprod.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dss-bigquery@predict-credit-mgt-v2-preprod.json


SBSOTCCM
BigQuery_predict-credit-mgt-v2-prodpredict-credit-mgt-v2-proddss-bigquery@predict-credit-mgt-v2-prod.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dss-bigquery@predict-credit-mgt-v2-prod.json


SBSOTCCM
BigQuery_rni-datalake-batteries-devrni-datalake-batteries-devdss-bigquery@rni-datalake-batteries-dev.iam.gserviceaccount.com

/home/dataiku/GServiceAccounts/BigQuery_rni-datalake-batteries-dev.json




RI
BigQuery_Solvay-Ind-Conso-Dev_TORRELAVEGAsolvay-ind-conso-prodgbq-torrelavega-dk@solvay-ind-conso-prod.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/solvay-ind-conso-prod-93316eef1a13.json


BDA_SBS
BigQuery_Solvay-Ind-Conso-Prod_PASADENAsolvay-ind-conso-prodgbq-pasadena@solvay-ind-conso-prod.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dss-bigquery@solvay-ind-conso-prod_PASADENA.json


Pasadena
BigQuery_Solvay-Ind-Conso-Prod_TORRELAVEGAsolvay-ind-conso-prodgbq-torrelavega-dk@solvay-ind-conso-prod.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/BigQuery_Solvay-Ind-Conso-Prod_TORRELAVEGA.json


BDA_SBS
BigQuery_solvay-rni-datalake-bat-ppdsolvay-rni-datalake-bat-ppddss-bigquery@solvay-rni-datalake-bat-ppd.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/BigQuery_solvay-rni-datalake-bat-ppd.json


RI_Batteries
BigQuery_solvay-silica-synthesis-devsolvay-silica-synthesis-devdss-bigquery@solvay-silica-synthesis-dev.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/BigQuery_solvay-silica-synthesis-dev.json


administrators
BigQuery_Support_Kpi_Prdsolvay-support-kpi-prddss-bigquery@solvay-support-kpi-prd.iam.gserviceaccount.com/home/dataiku/GServiceAccounts/dss-bigquery@solvay-support-kpi-prd.json


SBSContactCenter

McKinsey

BQ_commercial_data_cleaning_devcommercial-data-cleaning-dev
/home/dataiku/GServiceAccounts/BQ_commercial_data_cleaning_dev.json




BigQuery-solvay-prod-sbs-app-visibilitysolvay-prod-sbs-app-visibilitydss-bigquery@solvay-prod-sbs-app-visibility.iam.gserviceaccount.com






CX_GBQ_A_PRJ-DATA-TAVAUX-UAT-FLUORESprj-data-tavaux-pre-prodsa-dss-automuat-tavaux-fluores@prj-data-tavaux-pre-prod.iam.gserviceaccount.comAsk Tavaux project admins or GCP project "prj-data-tavaux-pre-prod" owner 

For Tavaux projectsGR_TAVAUX_ADM, GR_TAVAUX_FLUORES
CX_GBQ_A_PRJ-DATA-TAVAUX-UAT-IXANprj-data-tavaux-pre-prodsa-dss-automuat-tavaux-ixan@prj-data-tavaux-pre-prod.iam.gserviceaccount.comAsk Tavaux project admins or GCP project "prj-data-tavaux-pre-prod" owner 

For Tavaux projectsGR_TAVAUX_ADM, GR_TAVAUX_IXAN
CX_GBQ_A_PRJ-DATA-TAVAUX-UAT-PVDFprj-data-tavaux-pre-prodsa-dss-automuat-tavaux-pvdf@prj-data-tavaux-pre-prod.iam.gserviceaccount.comAsk Tavaux project admins or GCP project "prj-data-tavaux-pre-prod" owner 

For Tavaux projects

GR_TAVAUX_ADM,

GR_TAVAUX_PVDF

CX_GBQ_PRJ-DATA-TAVAUX-UAT-STEP_BIOprj-data-tavaux-pre-prodsa-dss-automuat-tavaux-stepbio@prj-data-tavaux-pre-prod.iam.gserviceaccount.comAsk Tavaux project admins or GCP project "prj-data-tavaux-pre-prod" owner 

For Tavaux projects

GR_TAVAUX_ADM,

GR_TAVAUX_STEP_BIO

CX_GBQ_A_PRJ-DATA-TAVAUX-DEV-FLUORESprj-data-tavaux-devsa-dss-design-tavaux-fluores@prj-data-tavaux-dev.iam.gserviceaccount.comAsk Tavaux project admins or GCP project "prj-data-tavaux-dev" owner 

For Tavaux projects

GR_TAVAUX_ADM,

GR_TAVAUX_FLUORES

CX_GBQ_A_PRJ-DATA-TAVAUX-DEV-IXANprj-data-tavaux-devsa-dss-design-tavaux-ixan@prj-data-tavaux-dev.iam.gserviceaccount.comAsk Tavaux project admins or GCP project "prj-data-tavaux-dev" owner 

For Tavaux projects

GR_TAVAUX_ADM,

GR_TAVAUX_IXAN

CX_GBQ_A_PRJ-DATA-TAVAUX-DEV-PVDFprj-data-tavaux-devsa-dss-design-tavaux-pvdf@prj-data-tavaux-dev.iam.gserviceaccount.comAsk Tavaux project admins or GCP project "prj-data-tavaux-dev" owner 

For Tavaux projects

GR_TAVAUX_ADM,

GR_TAVAUX_PVDF

CX_GBQ_PRJ-DATA-TAVAUX-DEV-STEP_BIOprj-data-tavaux-devsa-dss-design-tavaux-stepbio@prj-data-tavaux-dev.iam.gserviceaccount.comAsk Tavaux project admins or GCP project "prj-data-tavaux-dev" owner 

For Tavaux projects

GR_TAVAUX_ADM,

GR_TAVAUX_STEP_BIO

Google Cloud Storage

Connection NameProject key

Private Key

Service accountBucketPathUsable byPurpose
bi-gcp-sandbox-FM100bi-gcp-sandbox/home/dataiku/GServiceAccounts/dss-bigquery@bi-gcp-sandbox.jsondss-bigquery@bi-gcp-sandbox.iam.gserviceaccount.comfm100temporary
administrators
Cloudstorage_rni-datalake-batteries-devrni-datalake-batteries-dev/home/dataiku/GServiceAccounts/Cloudstorage_rni-datalake-batteries-dev.jsondss-bigquery-storage-service-a@rni-datalake-batteries-dev.iam.gserviceaccount.comrni_bucket


cloudstorage_sandboxbi-gcp-sandbox/home/dataiku/GServiceAccounts/dss-bigquery@bi-gcp-sandbox.jsondss-bigquery@bi-gcp-sandbox.iam.gserviceaccount.comdataikudss
Every Analyst
cloudstorage_spp_inputbi-gcp-sandbox/home/dataiku/GServiceAccounts/dss-bigquery@bi-gcp-sandbox.jsondss-bigquery@bi-gcp-sandbox.iam.gserviceaccount.comdataikudss/SPPSPPCommercial
cloudstorage-Poseidon-Devsolvay-gcp-poseidon-dev/home/dataiku/GServiceAccounts/dataiku@solvay-gcp-poseidon-dev.jsondataiku@solvay-gcp-poseidon-dev.iam.gserviceaccount.comsolvay-gcp-poseidon-dev-files-prepared
BDA_SBS
cloudstorage-sbsappvisibility-devsolvay-dev-sbs-app-visibility/home/dataiku/GServiceAccounts/cloudstorage-sbsappvisibility-dev.jsondss-gcs@solvay-dev-sbs-app-visibility.iam.gserviceaccount.comsolvay-dev-sbs-app-visibility-ingest
BDA_SBS
cloudstorage-sbsappvisibility-prodsolvay-dev-sbs-app-visibility/home/dataiku/GServiceAccounts/cloudstorage-sbsappvisibility-prod.jsondss-gcs@solvay-prod-sbs-app-visibility.iam.gserviceaccount.comsolvay-prod-sbs-app-visibility-ingest
BDA_SBS
commercial_data_cleaning_prdcommercial-data-cleaning-prod/home/dataiku/GServiceAccounts/commercial_data_cleaning_prd.json
commercial-data-prd
BDA_SBS
commercial-data-cleaning-devcommercial-data-cleaning-dev/home/dataiku/GServiceAccounts/commercial-data-cleaning-dev.jsondss-bigquery@commercial-data-cleaning-dev.iam.gserviceaccount.comcommercial-cleaning-data-dev
BDA_SBS
extract_freshdesk_tickets_xmlsolvay-support-kpi-prd/home/dataiku/GServiceAccounts/extract_freshdesk_tickets_xml.json
extract-freshdesk-tickets-xml-eu
BDA_SBS
gsc-testbi-gcp-sandbox/home/dataiku/GServiceAccounts/gsc-test.jsondss-cloud@bi-gcp-sandbox.iam.gserviceaccount.comdataikudss
BDA_SBS
PCM_Bucketpredict-credit-mgt-v2-dev/home/dataiku/GServiceAccounts/dss-bigquery@predict-credit-mgt-v2-dev.jsondss-bigquery@predict-credit-mgt-v2-dev.iam.gserviceaccount.compredict-credit-mgt-v2-dev-dss
administrators
predict-credit-mgt-v2-dev-dsspredict-credit-mgt-v2-dev/home/dataiku/GServiceAccounts/dss-bigquery@predict-credit-mgt-v2-dev.jsondss-bigquery@predict-credit-mgt-v2-dev.iam.gserviceaccount.compredict-credit-mgt-v2-dev-dss
administrators
predict-credit-mgt-v2-preprod-dsspredict-credit-mgt-v2-preprod/home/dataiku/GServiceAccounts/dss-bigquery@predict-credit-mgt-v2-preprod.jsondss-bigquery@predict-credit-mgt-v2-preprod.iam.gserviceaccount.compredict-credit-mgt-v2-preprod-dss
administrators
predict-credit-mgt-v2-prodpredict-credit-mgt-v2-prod/home/dataiku/GServiceAccounts/dss-bigquery@predict-credit-mgt-v2-prod.jsondss-bigquery@predict-credit-mgt-v2-prod.iam.gserviceaccount.compredict-credit-mgt-v2-prod-dss
administrators
S3_cloud_storagebi-gcp-sandbox/home/dataiku/GServiceAccounts/dss-bigquery@bi-gcp-sandbox.jsondss-bigquery@bi-gcp-sandbox.iam.gserviceaccount.coms3_analytics_solvay
Every analyst
solvia_datasolvay-support-kpi-prd/home/dataiku/GServiceAccounts/solvia_data.json
solvia-data
BDA_SBS
CX_GCS_A_PRJ-DATA-TAVAUX-UAT-FLUORES prj-data-tavaux-pre-prodAsk Tavaux project admins or GCP project "prj-data-tavaux-pre-prod" owner sa-dss-automuat-tavaux-fluores@prj-data-tavaux-pre-prod.iam.gserviceaccount.comcs-ew1-data-tavaux-uat-fluores
GR_TAVAUX_ADM, GR_TAVAUX_FLUORESFor Tavaux projects
CX_GCS_A_PRJ-DATA-TAVAUX-UAT-IXANprj-data-tavaux-pre-prodAsk Tavaux project admins or GCP project "prj-data-tavaux-pre-prod" owner sa-dss-automuat-tavaux-ixan@prj-data-tavaux-pre-prod.iam.gserviceaccount.comcs-ew1-data-tavaux-uat-ixan
GR_TAVAUX_ADM, GR_TAVAUX_IXANFor Tavaux projects
CX_GCS_A_PRJ-DATA-TAVAUX-UAT-PVDFprj-data-tavaux-pre-prodAsk Tavaux project admins or GCP project "prj-data-tavaux-pre-prod" owner sa-dss-automuat-tavaux-pvdf@prj-data-tavaux-pre-prod.iam.gserviceaccount.comcs-ew1-data-tavaux-uat-pvdf

GR_TAVAUX_ADM,

GR_TAVAUX_PVDF

For Tavaux projects
CX_GCS_PRJ-DATA-TAVAUX-UAT-STEP_BIOprj-data-tavaux-pre-prodAsk Tavaux project admins or GCP project "prj-data-tavaux-pre-prod" owner sa-dss-automuat-tavaux-stepbio@prj-data-tavaux-pre-prod.iam.gserviceaccount.comcs-ew1-data-tavaux-uat-step-bio

GR_TAVAUX_ADM,

GR_TAVAUX_STEP_BIO

For Tavaux projects
CX_GCS_A_PRJ-DATA-TAVAUX-DEV-FLUORES prj-data-tavaux-devAsk Tavaux project admins or GCP project "prj-data-tavaux-dev" ownersa-dss-design-tavaux-fluores@prj-data-tavaux-dev.iam.gserviceaccount.comcs-ew1-data-tavaux-dev-fluores

GR_TAVAUX_ADM,

GR_TAVAUX_FLUORES

For Tavaux projects
CX_GCS_A_PRJ-DATA-TAVAUX-DEV-IXANprj-data-tavaux-devAsk Tavaux project admins or GCP project "prj-data-tavaux-dev" ownersa-dss-design-tavaux-ixan@prj-data-tavaux-dev.iam.gserviceaccount.comcs-ew1-data-tavaux-dev-ixan

GR_TAVAUX_ADM,

GR_TAVAUX_IXAN

For Tavaux projects
CX_GCS_A_PRJ-DATA-TAVAUX-DEV-PVDFprj-data-tavaux-devAsk Tavaux project admins or GCP project "prj-data-tavaux-dev" ownersa-dss-design-tavaux-pvdf@prj-data-tavaux-dev.iam.gserviceaccount.comcs-ew1-data-tavaux-dev-pvdf

GR_TAVAUX_ADM,

GR_TAVAUX_PVDF

For Tavaux projects
CX_GCS_PRJ-DATA-TAVAUX-DEV-STEP_BIOprj-data-tavaux-devAsk Tavaux project admins or GCP project "prj-data-tavaux-dev" ownersa-dss-design-tavaux-stepbio@prj-data-tavaux-dev.iam.gserviceaccount.comcs-ew1-data-tavaux-dev-step-bio

GR_TAVAUX_ADM,

GR_TAVAUX_STEP_BIO

For Tavaux projects


MySQL

Connection NameHostDatabasePortUserPasswordUsable byPurposeFor server

commercial_datacleaning_dev

34.77.28.212commercial_data_cleaning_dev_latest3306dataikunovecarecleaning2018SBS BD&AStore frontend suggestions for Mappy (Novecare data cleaning)design ibm
gcp-datagrow-dev-novecare 35.241.133.252 novecare_datagrow 3306 dssdesign H5G+6;5JMxyts2@ Datagrow

 design ibm

commercial_datacleaning_prod35.241.224.206commercial_data_cleaning_prd3306dataikuqFCn3xLkYGrzSBS BD&AStore frontend suggestions for Mappy (Novecare data cleaning)all automation


Postgre-SQL

Connection NameHostDatabasePortUserPasswordAdditional PropertiesUsable byPurposeFor server
SES_VENDOHM35.195.227.102warehouse5432postgre<ENGUERRAN TO COMPLETE>
All analysesAccess to Energy Services Vendohm energy datasetsAll
commercial_data_cleaning_dev34.77.28.212commercial_data_cleaning_dev5432dataiku????
administrators

DataCatalogBDA35.195.86.202datacatalog5432datac????sslcert = /home/dataiku/certificates/client-key-datacalalogueBDA-PostgreSQL.pemBDA_SBS

Spinetta_dss_mainarc-spi-pgsql.eua.solvay.comspi_dataiku5432spi_dataiku

TvIJl3X7aqtXTegalrCla2Qmqt5ser

ssl = true

sslfactory = org.postgresql.ssl.NonValidatingFactory

AllMain DB for Spinetta DevSpinetta Dev
Spinetta_automation_mainarc-spi-pgsql.eua.solvay.comspi_automation5432spi_automation

ssl = true

sslfactory = org.postgresql.ssl.NonValidatingFactory

AllMain DB for Spinetta ProdSpinetta Prod

10.216.208.10dss-test-automation-sql5432pbe_webappPricebackend!

sslcert : pbe-webapp-test-auto-client-cert.pem

sslkey : pbe-webapp-test-auto-client-key.pem

sslrootcert : pbe-webapp-test-auto-server-ca.pem

sslmode : verify-ca

ssl : true

certificates.zip

Pricing webapp TestRead-only access to PBE_MASTER_front_end_dataset by pricing webappPricing webapp Test

10.218.152.7dss-prod-automation-sql5432pbe_webappPricebackend!

sslcert : pbe-webapp-prod-auto-client-cert.pem
sslkey : pbe-webapp-prod-auto-client-key.pk8
sslrootcert : pbe-webapp-prod-auto-server-ca.pem
sslmode : verify-ca
ssl : true

certificates.zip

Pricing Webapp Prod

Read-only access to PBE_MASTER_front_end_dataset by pricing webappPricing webapp Prod


ElasticSearch

Connection NameHostPortUserPasswordUsable byPurpose
Sandbox_ElasticSearch130.211.62.378080gael????All analyses
Talend_UAT150.251.113.939200 <none> ????


Oracle

Connection NameHostPortService NameUserPasswordUsable byPurpose
SES_IRM_PRODux11db.ibm.be.solvay.com1530IRMPRODINTERFACE????SES_Agregat
SES_IRM_TESTux13db.ibm.be.solvay.com1531IRMTESTINTERFACE????SES_Agregat



Salesforce

Remedy Instance (Infrastructure Tickets)




  • No labels