Backend functions
      Back to home
      1. Knowledgebase & Help Center
      2. ChiliDataWarehouse®
      3. Backend functions

      ⚙️ Connection String

      The connection string serves as the central access point for all BI tools to connect to the SQL database.

      Important Note

      When a new connection string is generated, the old credentials become invalid. Therefore, it is essential to update the new credentials in the respective BI tools after each change.

      Screenshot-ChiliDataWarehouse-Connection-String-png

      Example:

      Server=dataconnection.chili.ch;Database=HubspotDB_Portal_2660806;User Id=l_cdw_2660806;Password=password;TrustServerCertificate=True;MultipleActiveResultSets=true

      Key Value
      Server dataconnection.chili.ch
      Database HubspotDB_Portal_1234567
      User Idl_cdw_1234567
      Password password
      Trust Server Certificate True
      Multiple Active Result Sets True

       

      Screenshot-ChiliDataWarehouse-Connection-String-result-png