Hi I have connection to SQL database via Azure Active Directory. How can I connect it to Mathematica.
I have no idea how I can use this http://reference.wolfram.com/language/DatabaseLink/ref/OpenSQLConnection.html.
I can not see way to set path to database.
Do you know how to connect to it without Mathematica? What SQL database are you using?
This is a example on my laptop. I work with Oracle on my local machine:
'aaaa' is the name of the database
'bbbb'/çcc' is my password & username to connect to my local database.
And then I can make my first SQL statement:
var=SQLExecute[$connection,"select * from tabelname WHERE ROWNUM <= 972"];
Our back office adminer - Mysql , or Power BI
to transform to Mathematica
but It failed.
"Username" -> "xxxxx", "Password" -> "xxxx"]
JDBC::error: Access denied for user 'name@'localhost' (using password: YES)
Password is correct, but I have read only access. So I do not know if this is the reason why it failed.
We use also Power BI.