How to access our test/production Mendix database and edit data

1
Hi, I need to edit data directly in the test/production Mendix database. I am not able to find the steps to do so. Please guide. Thanks.
asked
4 answers
1

Hi Romil,

 

You can download the backup from the sprinter portal. You can manage your backups from the backups page.

 

and from here you can define which environment you want, and create a snapshot from the current database. Then select the snapshot and click download

You will get three options. Number 2 and 3 are self explanatory, and number 1 are Files and Database combined. If you download the full backup. it will be in a compressed format. You can use 7zip to extract the files twice, until you get access to the db and file folders. In the db folder, you will have the .db file which you can use in the blog post below. 

 

Here is a blog post to help you 

 

http://www.nolanramsey.com/blog/2015/5/29/how-to-use-your-mendix-cloud-database-locally

 

If you want to include files when you run locally,  copy all the contents in the file folder, and navigate to your mendix projects deployment directory

\deployment\data\files

and replace the contents in our deployment directories file folder, with the contenets from the cloud backup.

answered
1

You can also use the Java API if you need direct database access: https://apidocs.mendix.com/7/runtime/com/mendix/datastorage/DataStorage.html

Some examples can be found here: https://github.com/ako/QueryApiBlogPost

answered
0

Hi,

I'm new to Mendix: just started today my learning path.

Very inspiring, indeed. Then a question came to mind: what about the DB ? Is it accessible ? How ?

I haven't found an ultimate answer.

Snapshots are ok. OData export even more.

But in the real world I'd like to have full access to data, like running a query on the fly on a table with millions of records.

Or even mass update a set of records.

Being cut away from my data makes me feel very uncomfortable.

Is there any other solution other than snapshots and export ?

answered
0

Hi Bruno, 

If you run in the Mendix Cloud, you cannot access your data by connecting directly to your database. In this case you can alter your data via

  • Download database, modify data locally and upload the modified database
  • Modify via conversion scripts
  • Modify via pages

 

If you want to have totally access to your database you could deploy your database on-premise. 

answered