Is it possible to disable database encryption? For example, matomo_log_link_visit_action.idvisitor is an encrypted field, can this be decrypted at the database layer so that I can read it directly from the database without using the Matomo API?
@onairmarc why do you needs such feature?
My business utilizes Microsoft PowerBI and some custom business intelligence software. By this data being decrypted, we can move faster in our BI Database development. We’d like to avoid needing to run a extraction job via the API if we can help it since we already have a lot of extraction jobs running from third-party systems. This data is already in our database, so we’d like to be able to query it directly.
Perhaps having the option to select which fields are decrypted would allow for some security to remain in place.
Please let me know if you have any additional questions.
Isn’t it jus a blob (that must be converted into INT)?
It appears that it is a Binary(8) column
What if you convert it as INT or string (VARCHAR)?
If you prefer to see the binary data in hexadecimal form, you can make your SQL server convert it in the query:
Thank you @Lukas! This is exactly what I needed!