WaveMaker Docs

WaveMaker Docs

  • Get started
  • Widgets
  • How-to
  • Releases
  • Login
  • Start free trial

›- Data services

Getting started

  • Introduction
  • Walkthrough

App design

  • UI Overview
  • Create Pages
  • Designing Pages
  • Widgets Composition
  • Page Configure

    • Page Layout
    • Page Artefacts
    • Partial Page
    • Page Parameters
    • Navigation
    • Events
    • Examples

    Apply Styles

    • Themes
    • Templates

Backend

  • Backend Services
  • Introduction to API Designer

- Data services

  • Database Services Overview
  • Database Tools
  • Database Designing

    • Working with Databases
    • Data Modelling
    • DataBase Schema Modes
    • Working with DB Schema
    • Database Views
    • Temporal Support

    Accessing Database

    • Accessing Database
    • ORM Artifacts

    Queries and Procedures

    • Working with Queries
    • Working with Stored Procedures
    • Version Queries & Procedures
    • Blob Queries and Procedures
    • Queries & Procedures - Java Services

    Database Variables & API

    • Database CRUD
    • Database APIs
    • Database Service APIs

- Web services

  • Web Services Overview
  • Services

    • REST Services
    • Secure Server-side Properties
    • REST Services using OAuth 2.0
    • Working with SOAP Services
    • Working with WebSockets

    Web Service Variables & API

    • Web Services Variable
    • Web Service APIs

- Java services

  • Java Service
  • Java Services

    • Java Integration Services
    • Variables for Invocation
    • Generated REST APIs (API Designer)

    Java Services Variables & API

    • Variable for Java Service
    • Java Service APIs

    Manifest files

    • 3rd Party Libraries
    • Using 3rd party JavaScript files
    • Using 3rd party jar files

- Security services

    App Security

    • Overview
    • Authentication
    • Authorization
    • Access Levels & Permissions
    • Login Configuration
    • SSL Encryption
    • XSS antisamy policy configuration
    • OWASP
    • Central Authentication System
    • Token Based Authentication
    • SAML Integration

    Security Variable and API

    • Security Variables
    • Remember Me
    • Variable for Security Service
    • Security Service APIs

Integration

  • Service Integration
  • Variables

    • Variables Overview
    • Model Variable
    • Device Variables
    • Variable Binding

    Actions

    • Actions
    • Navigation Action
    • Login Action
    • Logout Action
    • Timer Action
    • Notification Action

    Events

    • Events
    • JavaScript Access

Developer options

  • Test and Run (Preview) Apps
  • Import, Export & Update Apps
  • Project Shells
  • Localization
  • Developer Integration

    • Project User Management
    • Developer Collaboration
    • Debugging
    • Extending the Application using IDEs

    Deployment

    • Release Management
    • Configuration Profiles
    • Build Options for App Deployment
    • One-Click Deployment
    • Manage Deployed Apps

    Configuring Web Server

    • Deploy to Web Server Overview
    • Building a War from a WaveMaker Project
    • AWS
    • Azure
    • Google Cloud
    • Deploy to Tomcat
    • WebSphere
    • JBoss - WildFly
    • WebLogic Server

Develop extensions

  • Create Prefab
  • Use Cases - Prefabs
  • Create Themes
  • Create Template
  • Artifacts Repository

Mobile app

  • Building Hybrid Mobile Apps
  • Native Device Support
  • First Mobile App
  • Mobile Design

    • Mobile Page Design
    • Gesture Support
    • Mobile Tabbar
    • Mobile Navbar

    Mobile Installer

    • Test Run (Preview)
    • Debugging Mobile Apps
    • Testing Hybrid Mobile Apps using WaveLens
    • Mobile Build - Android
    • Mobile Build - Phonegap
    • Mobile Build - Manual

    Mobile Integrations

    • Mobile Integrations - Amazon Mobile Analytics
    • Mobile Integrations - Amazon SNS
    • Using Push Notifications in Mobile Device
    • Invoking Web App APIs in Mobile Apps

    Offline Features

    • Offline Data Support
    • Implementation
    • Switching between Offline and Online Mode

Enterprise

  • Setup Guide
  • Launching Instances
  • DEB Installer - Private AMI
  • Add external VCS Configuration
  • Custom Apps Capacity
  • Setting up WME
  • Configuration
  • Adding Capacity
  • Maintenance
  • Upgrading
Edit

Database Tools

Learn what database tools you can use to work with database services in WaveMaker.


WaveMaker provides database tools to connect to your development and deployment database servers in the cloud. You can execute scripts and run the commands supported by the database server. To access the database tools, click on DB Tools located at the bottom of your project workspace, when in the Databases Resource page.

DB Shell

DB Shell is one of the database tools which simplify the management of your development and deployment databases. DB Shell is a command-line interface to execute DDL (Data Definition Language) and DML (Data Modification Language) commands supported by the database server.

note

DB Shell can be used only for the database hosted on Cloud supporting MariaDB ver 10.2.

Upon clicking DB Tools from Databases Resource page, you will be shown the DB Shell- MariaDB Cloud tab which connects to the development database server and displays a command-line interface to execute database commands.

DB Scripts

WaveMaker also makes it simple to execute SQL scripts on your database servers.

  1. From the DB Tools dialog, click the Script tab.
  2. You can either Import or Export DB.
note

Script execution does not work on IE9 browsers

Import Database

Import Database can be used to import an external data source into the WaveMaker and work with it. A data source will be replicated within WaveMaker. Importing an existing database will result in overwriting of the WaveMaker copy with the original data source, i.e. any changes made to the database within WaveMaker will be lost. In order to retain the changes made within WaveMaker, an export is essential.

note

Note that once you run the script, you need to physically Import the Database from the Databases Resource + icon or use the link from the success screen.

Things to be aware of

Key things to note while importing databases include:

  • WaveMaker supports major SQL data types. In case the imported database uses any other data type, those will be converted to the closest matching data type.
  • Sequence-generated primary key columns will not be mapped during database import. It will be converted to assigned generator type. To retain the original sequence-generation, you need to manually change the generator type to sequence; give a generator name, save and re-import the database.
  • The configuration fields should be entered based on the type of database used.

Script Execution

Click on the Import tab and use the following steps to execute a script:

  1. Select the database server on which the script needs to be executed by selecting from the options in the Host field. Currently, the only server option is MariaDB Cloud database server.
  2. Enter the Database Name.
note

A database with this name must exist in the selected database server. You can create one using the DB Shell if the database doesn't exist.

  1. Click Choose File to locate and upload the script file to be executed. Make sure you choose a valid script file.
  2. Click on the Execute button. After the script executes, the status of the script execution is displayed.
  3. Once you have executed the script, the database is ready for import. Import the Database from the Databases Resource + icon or use the link from the success screen.

Export Database

Export Database can be used to export the database within WaveMaker to an external data source. Click on the Export tab and use the following steps to execute a script:

  1. Select the database server on which the script needs to be executed by selecting from the options in the Host field. Currently, the only server option is MariaDB Cloud database server.
  2. Enter the Database Name. Select from the list provided.
  3. Select Schema Only to export the Schema without data. To get the data and schema – do not check Schema only option – click GET Data Dump will get the schema and data.
  4. Click on the Get Data Dump button. After the script executes, the status of the script execution is displayed.
Last updated on 9/11/2019 by rnaresh
← Database Services OverviewWorking with Databases →
  • DB Shell
  • DB Scripts
  • Import Database
    • Things to be aware of
  • Script Execution
  • Export Database
WaveMaker
  • PRICING
  • PARTNERS
  • CUSTOMERS
  • ABOUT US
  • CONTACT US
Terms of Use | Copyright © 2013-2019 WaveMaker, Inc. All rights reserved.