Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [databaselink]

DatabaseLink is a toolkit for working with SQL databases built into Mathematica.

11
votes
2answers
125 views

How to extract Bitmap image from SQL records?

I'm trying to extract image from records of the MSSQL demo database NorthWind with this codes, ...
4
votes
1answer
51 views

Local Storage of Periodically Collected Data (without using DataDrop)

I would like to take periodic measurements (e.g. noise levels and temperature in my office from a Raspberry Pi, etc.), say, every minute and have a long-reaching record of this similar to Stephen's ...
4
votes
1answer
50 views

Retrieve column data from MongoCollection

I am connecting to a mongo database from Mathematica. I can get a MongoCollection object, but can not get a column of data from it. ...
0
votes
0answers
21 views

Need help understanding SQLConnectionUsableQ

On a program that relies on database connectivity asking SQLConnectionUsableQ@conn is very important and may be asked many times while the program is running. I ...
1
vote
0answers
58 views

Probable Bug in SQLColumn condition < upper limit for SQLSelect

I have a perfectly good SQLSelect query that doesn't work if and only if it contains an extra < condition on a column already used. Details follow... This SQLselect shows that the expected data ...
1
vote
0answers
77 views

List of Financial Index in Mathematica

I have to work with different Financial Futures Index in Mathematica using the function "InteractiveTradingChart". But, I can't able to find a complete list of all the available Financial Futures ...
0
votes
0answers
34 views

SQLConnection causes kernel hangs

This question is additional question to Maintaining SQLConnections In Mathematica 10.4.1.0 (64bit). ...
3
votes
1answer
317 views

Maintaining SQLConnections

I'm using SQLConnection to database in repetitive ScheduledTask. To prevent creation of new connections, and to maintain binding ...
1
vote
0answers
107 views

What's the dataset site/provider from which Mathematica import Financial Data price?

I tried to download a lot of Financial Data Time series of different financial assets (Exchange, Commodity, Index, Stocks, etc etc...). In the most part of cases, I try to found, and download it, ...
0
votes
0answers
61 views

SQL export data

I have data imported from excel file into mathematica but mathematica automatically converts large number into scientific form and when transferring this data to sql string field i get the following .....
0
votes
0answers
30 views

How to set primary key in SQLCreateTable to be auto_increment

I'm trying to create a table using SQLCreateTable. What I need is auto incremented primary key. My table will be growing in time and I don't want to check previous value of primary key every time I ...
4
votes
1answer
69 views

Context of SQLBinary in Package

I have the following code for a simple key value store for binary data: ...
4
votes
0answers
85 views

Mathematica not releasing RAM

The following code is supposed to sequentially read data from a large CSV file and put it row by row into an SQL server. Although I thought RAM consumption should be constant the system keeps asking ...
2
votes
1answer
49 views

How to select a SQLConnection from SQLConnections[] by its “Name” property?

When creating a SQLConnection you can give it a name with the "Name" option. The connections are also added to the output of the ...
8
votes
1answer
126 views

Why has this SQLInsert behaviour changed?

Using Mathematica 11.1 to insert into a MySQL table with this schema... ...
3
votes
2answers
473 views

I have a bigdata CSV file as a single table of five columns and almost 10 million rows

I need to examine the bigdata file with a database/DBMS and have used MS Office 365/Access successfully so to do, import and query. I have also tried, many times, to open a MMA 10.4 database link ...
2
votes
1answer
104 views

Connection to SQL server - Failed

I have a test database created by the colleagues from IT department and I can also access / see it using MS SQL Server Management Studio 2016. However, I cannot establish a connection to it from ...
18
votes
1answer
259 views

DatabaseLink and Libreoffice odb

Preface In scientific projects, I often deal with large Excel files from partners as this is unfortunately still the way to store data. Always, one of my first steps after importing the data is to ...
2
votes
0answers
72 views

SQL Group By using SQLSelect

I would like to use the SQLSelect[] function in Mathematica 11 to get aggregated data from a large database. Is using SQLExecute ...
1
vote
0answers
35 views

Integer data type mapping problem with SQLInsert in DatabaseLink package

I am working with a following SQL table named "ticket". Now let's see the data types for the columns. ...
4
votes
0answers
238 views

How to OpenSQLConnection with JDBC for “Microsoft Excel”?

I have a very large Microsoft Excel file that will not Import even after setting a 5GB heap size for Java as follows. ...
3
votes
0answers
47 views

Error in DatabaseLink when trying to select from multiple tables

I've noticed a rather inconvenient (assumed) bug when selecting data joined across multiple SQL tables. Example: ...
11
votes
3answers
1k views

JDBC-to-ODBC bridge gone. How to connect to SQL Server now in case of Windows Authentication?

Connecting to our corporate SQL servers using JDBC never worked for me, perhaps related to the Windows Authentication method that is necessary in our network. However, I found out that configuring the ...
0
votes
0answers
36 views

How to pass a table type parameter to SQLExecute?

In MS SQL Server 2016 I have a table type parameter: CREATE TYPE dbo.Ids AS TABLE (Id INTEGER NOT NULL); and a stored procedure: ...
7
votes
2answers
629 views

How to speed up interpreting numbers from strings?

In processing a large text file I have batches from ReadList of 100,000 Records of the form. ...
1
vote
0answers
67 views

Using MemberQ or Contains* in a query fails

Using MemberQ or Contains* in a query fails: ...
3
votes
0answers
194 views

How do I insert Unicode into a MySQL database?

I'm having trouble transferring Unicode strings from one MySQL database to another using DatabaseLink` functions. Here is my failed attempt to read a string from ...
2
votes
0answers
121 views

Random sample from sql database uniformly over time [closed]

I'd like to sample rows from a table uniformly over time, here is the naive way to do this: SELECT * FROM table ORDER BY RAND() LIMIT 10000 Unfortunately, ...
3
votes
1answer
175 views

Cloud Form Function Database

I am trying to build a web inventory application using a SQLite database hosted in the cloud home directory. I have a database in the home directory and I can query that database while in the code ...
4
votes
0answers
53 views

Mathematica 10.3 on Windows 10 Home Premium Connection to SQL Server 2016 [duplicate]

Having installed sql server 2016 evaluation copy. I have setup a sample database using sql server management studio. Typed the following in mathematica ...
1
vote
0answers
118 views

Using Mathematica to connect to Cloudera Impala

I am trying to connect to Cloudera Impala via Mathematica, but so far I have not been able to do so. Has anyone ever done it? I have been able to connect to it via R using the JDBC or ODBC interface ...
4
votes
1answer
161 views

Connection to SQL server databases from Mathematica

I am an SQL developer and very new to Mathematica. As per my requirement I need to make a connection from Mathematica to my sql server database, after which my client will do some analysis with the ...
5
votes
1answer
210 views

SQLInsert'ing Null into a table (not SQLite)

Is it possible to insert Null values using DatabaseLink, without formatting the query string manually? Hans found (below) that this works for SQLite, so it appears ...
1
vote
1answer
218 views
1
vote
0answers
206 views

Awkward DatabaseLink JDBC Error [closed]

I've created a GUI application (a database editor) that uses DatabaseLink and it is currently working fine on my PC (M10.02, Windows 7) and on a clients's PC (CDF Player Pro 10.02, Windiws 8). While ...
1
vote
1answer
84 views

How to specify the number of precision digits for columns using DatabaseLink functions and options

Some databases (e.g. MySQL) does not store decimal places for seconds unless the number of digits needed is directly specified (e.g. DATETIME(4) for 4 digits) when creating the table in the database. ...
0
votes
0answers
90 views

Mathematica SQL command that counts records in table

Is there a DatabaseLink command other than SQLExecute that can be used to count the total records in a database table?
1
vote
0answers
47 views

How to identify primary keys in an existing database table

I would like to identify the primary keys in a DB table using DatabaseLink commands trying to exclude SQLExecute. It seems like SQLTableInformation or SQLColumnInformation may not show that ...
2
votes
0answers
88 views

OpenSQLConnection SSPI Library Not Loaded [duplicate]

I am attempting to open a connection to SQL Server with Windows Authentication (SSPI) using OpenSQLConnection and JDBC. ...
2
votes
1answer
61 views

Is there a way to define primary keys using SQLCreateTable?

I would like to create a db table and specify the primary key columns using the command SQLCreateTable. I know I could use SQLExecute but in this case I'm only interested in the right parameters for ...
0
votes
2answers
119 views

Performing analysis of data extracted from an SQL database

Below is an SQL query that I generated using DatabaseExplorer as well as a small sample of the result. How, att this point, can I perform analysis on the results ...
0
votes
1answer
138 views

Error Using Mysql In Mathematica

I'm using Mathematica, and accessing mysql through mysql (Connector/J). When I try to update a field in my table using WHERE statement, all the rows get updated <...
4
votes
0answers
171 views

Is it possible to specify GMT as default in OpenSQLConnection or JDBC?

I'm connecting to a PostgreSQL database, with tables containing TIMESTAMPs with timezone, using ...
11
votes
1answer
1k views

Slow work of SQLInsert with MS SQL Server in V10

This question is very similar to: Slow work of SQLInsert with SQLite, but for MS SQL Server. Unfortunately the use of SQLBeginTransaction and ...
5
votes
2answers
864 views

SQLite and Mathematica

I want to connect to a local database with Mathematica. I used DB Browser for SQLite to create the database with a single table and then exported it locally as a .sql file. To access the database I ...
4
votes
1answer
307 views

How to get data from DB into dataset with keys

I'm a Mathematica newbie and I have the following problem: I connect to a Oracle DB and read out a set of variables, further on I want to histogram some of the variables. A Dataset seems to be the ...
1
vote
0answers
48 views

Need a recommendation for managing a database link

I want to make a package which needs to have a external database link. But it is hard for me to have an idea about how to manage the database link. I want the link to be connected as long as I use the ...
7
votes
2answers
300 views

Connecting to Microsoft SQL with version 10

After upgrading to version 10, functions relying on a connection to a Microsoft SQL database no longer work. When I attempt to open a connection with something like: ...
6
votes
1answer
402 views

How to update bundled SQLite library (or driver?) in V10 for OS X

I've been using undocumented Database functions with Mathematica V9 to acces my SQLite database, which is a Firefox-generated database that contains cookies. ...
1
vote
1answer
99 views

How can I “ORDER BY” using SQLSelect?

A pretty straightforward problem, you would think, but I cannot seem to find the answer in the documentation for SQLSelect. The query I want to run is the following: ...