Group Abstract

Message Boards

11.1K Views

10 Replies

0 Total Likes

View groups...

Follow this post

Share this post:

GROUPS:

Data Science Mathematica External Programs and Systems Import and Export Wolfram Language

Posted 8 years ago

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

10 Replies

Sort By:

Posted 8 years ago

There is not a standard .sql format as each sql database has unique features so it is usually meant to be used within the same system. To export data from say MySQL into Mathematica you could use the mysqldump command with the --tab option: https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#mysqldump-format-options But you should be able to connect to MySQL directly using DatabaseLink. The access denies error that you are getting can probably be solved by using the MySQL GRANT command.

POSTED BY: Gustavo Delfino

Posted 8 years ago

No I cant see .sql format as option

POSTED BY: petr stanek

Posted 8 years ago

Can you import the file with Import[]

POSTED BY: Michiel van Mens

Posted 8 years ago

SQLText file

POSTED BY: petr stanek

Posted 8 years ago

what is the file format?

POSTED BY: Michiel van Mens

Posted 8 years ago

I have created dump of my Sql database. When I want to create sql connection, I will replace "localhost:1521/aaaa" by C://.......... . Is that correct? But this error appears JDBC::error: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "\Users............................"'.

POSTED BY: petr stanek

Posted 8 years 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.