Connection to database with username having special characters

Database Support
#1

Hello Helical Insight,

I am using Helical Insight 3.1. I am unable to make a connection to my MySQL database. It is not accepting special characters in the username. My DBpolicy requires special character as a must in the username. How can I use a username with special characters to establish a connection that I can use to make reports?

Thanks,
Sesa.

#2

Hello Sesa,

In version 3.1, special characters are not accepted for the username of datasource connection at the frontend.

Following work around can be applied:

  1. Create a connection to the database using a username that does not have any special characters.

  2. Edit globalConnections.xml file located at …/hi/hi-repository/System/Admin/

This file contains information of all the connections that are created from the frontend.

  1. Browse to the connection that you have established. You can see the username and password tags. Replace the username and password with the required username and password (with special characters).

image

The password may be in encrypted format, but accepts plain text as well.

  1. Save the file. You will now be able to create a metadata from this connection.

Please Note: From version 4.0 RC2 onwards, special characters are supported from the frontend.

Thanks,
Helical Insight.