Skip to main content
Question

I am doing training on Implementation Professional course on celonis. I tried to create a Data connection with the same information given by the exercise but it fails with this error while testing a connection. Please let me know how to resolve this.

  • July 28, 2021
  • 2 replies
  • 6 views
.
Level 0

Error:

onnection test failed, please check the Data Connection's configuration and ensure that the system is running: Unexpected error when creating database connection: Cannot create PoolableConnectionFactory (Login failed for user 'Training_CelonisDataEngnieer'. ClientConnectionId:d8366093-8a42-4b38-a7a0-043660558f92)

    2 replies

    gabriel.okaba11
    Celonaut
    Forum|alt.badge.img+2

    Hi Suganya,

     

    are you using the following configuration?

    Just tested and it is working. Make sure you are selecting the MSSQL Server (native) and connection type Direct

     

    Name: P2P Data Connection

    Connection type: Direct

    Type: Microsoft SQL Server (native)

    Host: 3.120.99.40

    Port: 1433

    Database Name: celonis

    Schema Name: Training

    Username: Training_CelonisDataEngineer

    PW: Celonis123!

    Maximum Parallel Table Extractions (Advanced Settings): 1

     

    Best,

    Gabriel

    Gabe
    P
    Level 1
    • pamela.resur
    • Level 1
    • October 28, 2022

    I have the same issue, I double checked the configuration stated in the exercise and it is correct.

    What could be the error?

     

    Is there a value for Advanced Settings > Validate Certificate?

    Community Code of ConductAccessibility statement