is added to the Warehouse, which is the ‘live’ part of the database, where it can be accessed by TFD users. Analysis is performed on this data. Adding New Sources The process for adding new sources of information is broadly the same for information held within Bristol City Council or held by external organisations. Leads within the Insight Bristol team will connect with either internal or external managers to secure agreement to share information; negotiating to agree a method of data transfer, frequency of transfer, which data will be shared and for what purpose. These agreements will either amount to a one-way sharing of information (i.e. a partner organisation sends the council their data) or bilateral sharing (i.e. data is shared both ways). For external organisations, they will agree to either providing Bristol City Council access to their database or to one of their staff spending time weekly/monthly/etc uploading the data to some mechanism for sharing. This may be through a portal, secure email or SSH File Transfer Protocol (SFTP) set up between the two organisations. As outlined, direct connections are the preferred method of transfer for internal datasets. This sharing is all underpinned by information sharing agreements signed between the organisations, with updates/the creation of Data Protection Impact Assessments and updates to privacy notices. Once this process is agreed, the TFD technical lead can start writing the scripts to incorporate the new data into the database and the relevant frontend views. They follow a structured process, and it typically amounts to less than a day’s work – the majority of time is taken negotiating the information governance arrangements. Social Finance Limited +44 (0) 20 7770 6836 87 Vauxhall Walk, London SE11 5HJ socialfinan