Message Boards Message Boards

Connect a database in Azure to Mathematica?

GROUPS:

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.

POSTED BY: petr stanek
Answer
27 days ago

Do you know how to connect to it without Mathematica? What SQL database are you using?

POSTED BY: Gustavo Delfino
Answer
26 days ago

This is a example on my laptop. I work with Oracle on my local machine:

Needs["DatabaseLink`"]
Needs["JLink`"]
$connection=OpenSQLConnection[JDBC["Oracle","localhost:1521/aaaa"],"Username"->"bbbb","Password"->"cccc"]

'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"];
POSTED BY: Michiel van Mens
Answer
25 days ago

Our back office adminer - Mysql , or Power BI

POSTED BY: petr stanek
Answer
20 days ago

-Mysql I tried https://www.mkyong.com/jdbc/how-to-connect-to-mysql-with-jdbc-driver-java/ to transform to Mathematica but It failed. OpenSQLConnection[JDBC["MySQL(Connector/J)", "locahost"], "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.

POSTED BY: petr stanek
Answer
20 days ago

Group Abstract Group Abstract