Questions tagged [databaselink]

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

Filter by
Sorted by
Tagged with
1 vote
0 answers
21 views

Where is the ODBC driver in DatabaseLink for Microsoft Access?

I have an access database file which 925MB. When trying to establish connection with it using: ...
user avatar
  • 8,105
1 vote
0 answers
26 views

How to specify table names in DatabaseLink for access database that have spaces in the names?

I am able to establish the connection with the access database as follows: ...
user avatar
  • 8,105
0 votes
1 answer
57 views

Querying ( e.g. ) Google Trends Data with Mathematica front-end

Mathematica has some excellent data query and analysis methods, but can also perform as a front-end to an SQL database. Having worked as an SQL DBA in the past I would like to investigate further what ...
user avatar
2 votes
1 answer
90 views

OpenSQLConnection fails - due to some Java problem?

After upgrading to 12.3, I can no longer connect to an MS SQL Server using OpenSQLConnection. Apparently due to some problem with Java(?). I tried to reinstall JRE 8, but no change. DatabaseExplorer[] ...
user avatar
  • 477
4 votes
1 answer
103 views

Can't connect to MS SQL using Active Directory Integrated Services via DatabaseLink

We have a data lake in here that uses MS SQL Server 12.02 and connects using the active directory integrated services authentication. The standard driver would not work ...
user avatar
  • 9,128
3 votes
1 answer
80 views

Retrieve the Date/Time difference in a MongoCollection

Each of my MongoDB documents contain two date-string timestamps: namely a LogOndt and LogOffdt timestamp. For example: ...
user avatar
1 vote
2 answers
108 views

How to access an English-Chinese dictionary database file correctly?

Now I have an English-Chinese dictionary database file (This database source file comes from this website and this file can be downloaded by clicking "点此下载". After downloading, you can ...
user avatar
3 votes
0 answers
123 views

error database connection MMA 12.2

I work with MMA 12.0. When I want to make a connection with met Oracle Database, I do: ...
user avatar
0 votes
0 answers
56 views

Mathematica fails to load welcome screen: "Authentication Required"

Problem When I open Mathematica 12.1.0 on windows 10, I get an "Authentication Required" window during the splash screen. The auth window has no input or buttons, and the text in the window ...
user avatar
  • 31
7 votes
1 answer
177 views

How to map MS SQL Server onto the Entity Framework?

I created a reference using the following: ...
user avatar
  • 8,105
20 votes
1 answer
704 views

What are the benefits of Entity Classes for Databases?

To me, using the older database functionality is much simpler: ...
user avatar
  • 30.3k
8 votes
1 answer
239 views

How to do a database query on substrings?

With the package DatabaseLink I can open a connection to my MYSQL database. Then I can use SQL commands like ...
user avatar
  • 9,859
1 vote
2 answers
68 views

Insert a DateObject into MySQL database?

I want to use Mathematica to do some SQL tasks like insert. However, I have difficulty in inserting date into SQL. Here is an example. ...
user avatar
  • 1,389
12 votes
2 answers
847 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, ...
user avatar
  • 2,379
4 votes
1 answer
133 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 ...
user avatar
  • 1,117
5 votes
1 answer
136 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. ...
user avatar
1 vote
0 answers
76 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 ...
user avatar
  • 2,410
0 votes
0 answers
39 views

SQLConnection causes kernel hangs

This question is additional question to Maintaining SQLConnections In Mathematica 10.4.1.0 (64bit). ...
user avatar
  • 900
3 votes
1 answer
327 views

Maintaining SQLConnections

I'm using SQLConnection to database in repetitive ScheduledTask. To prevent creation of new connections, and to maintain binding ...
user avatar
  • 900
0 votes
0 answers
95 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 .....
user avatar
  • 8,105
0 votes
0 answers
47 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 ...
user avatar
4 votes
1 answer
90 views

Context of SQLBinary in Package

I have the following code for a simple key value store for binary data: ...
user avatar
4 votes
0 answers
96 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 ...
user avatar
  • 8,105
2 votes
1 answer
58 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 ...
user avatar
  • 39.3k
8 votes
1 answer
165 views

Why has this SQLInsert behaviour changed?

Using Mathematica 11.1 to insert into a MySQL table with this schema... ...
user avatar
  • 29.1k
3 votes
2 answers
593 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 ...
user avatar
  • 31
2 votes
1 answer
185 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 ...
user avatar
  • 703
19 votes
1 answer
435 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 ...
user avatar
  • 111k
2 votes
0 answers
99 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 ...
user avatar
1 vote
0 answers
43 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. ...
user avatar
  • 14.2k
4 votes
0 answers
489 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. ...
user avatar
  • 39.3k
3 votes
0 answers
53 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: ...
user avatar
  • 10.6k
11 votes
3 answers
2k 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 ...
user avatar
0 votes
0 answers
81 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: ...
user avatar
  • 39.3k
8 votes
2 answers
778 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. ...
user avatar
  • 39.3k
1 vote
0 answers
84 views

Using MemberQ or Contains* in a query fails

Using MemberQ or Contains* in a query fails: ...
user avatar
  • 30.3k
4 votes
1 answer
280 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 ...
user avatar
  • 141
2 votes
0 answers
181 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, ...
user avatar
  • 30.3k
3 votes
1 answer
255 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 ...
user avatar
4 votes
0 answers
74 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 ...
user avatar
  • 8,105
1 vote
0 answers
135 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 ...
user avatar
  • 161
4 votes
1 answer
209 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 ...
user avatar
  • 41
5 votes
1 answer
247 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 ...
user avatar
  • 8,342
1 vote
1 answer
339 views

Package functions not loaded after successful `Get` (`<<`) [closed]

I have the following package: ...
user avatar
  • 39.3k
1 vote
0 answers
234 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 ...
user avatar
1 vote
1 answer
93 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. ...
user avatar
0 votes
0 answers
122 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?
user avatar
1 vote
0 answers
52 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 ...
user avatar
2 votes
0 answers
97 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. ...
user avatar
  • 39.3k
2 votes
1 answer
79 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 ...
user avatar