Quick Start with ODataDB

Table of Contents

• Quick Start on Windows
• Quick Start on Linux

Quick Start on Windows

Quick steps with the portable package:

1. Download the ODataDB portable package.
2. Unzip it to any folder on a local drive.
3. Run odatadb.exe in the odatadb subfolder.

Quick steps with the installer package:

1. Download the ODataDB installer package.
2. Unzip it to any folder on a local drive.
3. Run setup.exe to install the ODataDB.
4. Run odatadb.exe in the C:\Program Files\ODataDB\odatadb folder.

You have to see the following console app:

If you do not see the console, run the setup.exe wizard from the odatadb folder and follow wizard steps to install ASP.NET Core Runtime.

Alternatively, download and install the Hosting Bundle, which includes the ASP.NET Core Runtime and IIS support, at

• https://dotnet.microsoft.com/en-us/download/dotnet/8.0

When you see the console app, open the shown URL: http://localhost:5002/ or https://localhost:5002/

You have to see the index page.

Click on the mssql-023 connection and open the cashbook table of the online sample:

At this point, you have the correctly installed application and online samples to try ODataDB features.

Then try to connect to your local SQL Server, MySQL, and Postgres databases, from the home page or using the direct URLs:

• http://localhost:5002/edit/mssql/
• http://localhost:5002/edit/mysql/
• http://localhost:5002/edit/pgsql/

You may view and edit data. And this is free!

You may connect to remote databases, adding a server and database into the connection segment like /edit/mssql:mssql.savetodb.com,AzureDemo100/.

At this point, you have tried the local and remote connections.

Now run the setup.exe wizard from the odatadb folder or ODataDB Setup link from the Start menu.

The wizard allows configuring an IIS website, IIS application, or a Windows service, and HTTPS.

You may read more about installing ODataDB under IIS.

You may add connections to all your servers and databases. See details in appsettings and ODataDB endpoints.

Quick Start on Linux

Quick steps with the portable package:

1. Download the ODataDB package.
2. Unzip it and copy the odatadb folder to the /var/www folder.
3. Go to the /var/www/odatadb folder and run: dotnet odatadb.dll

You have to see the following response:

If ODataDB cannot start, install the ASP.NET Core Runtime using instructions at

• https://dotnet.microsoft.com/en-us/download/dotnet/8.0

When you start ODataDB, try to get data using a command like this:

curl http://localhost:5002/v4/mssql-023/cashbook

You have to see data from an online SQL Server database.

Press Ctrl-C to close the app and see the next steps in how to install ODataDB on Linux.