Builder Studio Reference

Reference guide for Builder Studio.

Databases

Databases supported for 'Import Tables' are MySQL, PostgreSQL, Oracle, MS SQL Server. Please contact us for further help on databases.

Supported Database Versions for Import

Database	id	JDBC Driver	Database Versions
Oracle	oracle	ojdbc8.jar	Oracle 21c, 19c, 18c, and 12.2
MS SQL Server	mssql	10.2.1.jre8	SQL Server 2019 (2017, 2016, 2014, 2012)
PostgreSQL	psql	42.5.1	PostgreSQL 8.2 or newer
MySQL	mysql	5.1.49	MySQL Server ver 5.0, 5.5
MySQL Newer Ver	mysql2	8.0.30	MySQL Server 8.0, 5.7 and 5.6

Importing From MariaDB database using MySQL connection type

Based on information from page MariaDB versus MySQL: Compatibility and stackoverflow, below seems version compatibility matrix to use MySQL connection type for importing tables from MariaDB.

MySQL	id	Compatible with MariaDB
MySQL 5.1	mysql	MariaDB 5.1, 5.2, 5.3
MySQL 5.5	mysql	MariaDB 5.5
MySQL 5.6	mysql2	MariaDB 10.0
MySQL 5.7	mysql2	MariaDB 10.2

Connecting Databases

Connection examples of providing URL as per db type :

• Oracle (oracle)

jdbc:oracle:thin:@127.0.0.1:1521:XE

• MS SQL Server (mssql)

jdbc:sqlserver://127.0.0.1:1433;databaseName=EMDB;encrypt=true;trustServerCertificate=true;

• PostgreSQL (psql)

jdbc:postgresql://localhost:5432/emdb?useUnicode=true&characterEncoding=utf8

• MySQL (mysql)

jdbc:mysql://localhost:3306/DBNAME?useUnicode=true&characterEncoding=utf8

Also provide database user and password.

Databases Data Types Mapping to EasyManage Types

MySQL and PostgreSQL

Db Data Type (lowercase) --> EasyManage Type

• char --> CHAR
• *binary* --> STREAM
• *blob* --> STREAM
• *bytea* --> STREAM
• bit --> CHAR
• datetime --> DATETIME
• date --> DATE
• time --> TIME
• timestamp --> DATETIME
• *int* --> NUMBER
• *serial* --> NUMBER
• *numeric* | *decimal* | *float* | *real* | *money* | *double* --> FLOAT
• *text* --> TEXT
• *bool* --> BOOLEAN
• Any Other --> CHAR

Oracle

Oracle Type --> EasyManage Type

• 'CHAR'--> 'CHAR'
• 'NCHAR'--> 'CHAR'
• 'VARCHAR2'--> 'CHAR'
• 'NVARCHAR2'--> 'CHAR'
• 'NUMBER'-->'NUMBER'
• 'FLOAT'--> 'FLOAT'
• 'DATE'--> 'DATE'
• 'TIMESTAMP'--> 'DATETIME'
• 'BOOLEAN'-->'CHAR'
• 'LONG'-->'STREAM'
• 'RAW'-->'STREAM'
• 'LONG RAW'-->'STREAM'
• 'ROWID'-->'CHAR'
• 'UROWID'-->'STREAM'
• 'CLOB'-->'STREAM'
• 'NCLOB'-->'STREAM'
• 'BLOB'-->'STREAM'
• Any Other -->'CHAR'

MS SQL Server

Db Data Type (lowercase) --> EasyManage Type

• char | nchar | varchar | nvarchar --> CHAR
• date --> DATE
• time --> TIME
• *datetime* --> DATETIME
• *int* --> NUMBER
• *numeric* | *decimal* | *float* | *real* | *money* | *smallmoney* --> FLOAT
• *text* --> TEXT
• uniqueidentifier --> CHAR
• bit --> CHAR
• *image* | *binary* | *varbinary* --> STREAM
• Any Other --> CHAR

Databases Specific Details for APIs

Some database specific implementation and understanding is required for APIs. Please refer to REST and GraphQL and Backend Reference docs for the same.

Solutions with Mgrating or Merging Databases

EasyManage can be used to migrate or merge databases. You can connect to one or more databases and import schemas. Then generate app and apis. The result projects can be setp to work against single (same or) new database type.

User Data Deleting

User Data : How To delete all your data in Builder Studio?

After project is running and if you do not need to iterate building or for privacy and data security reasons,

• You can delete all your data in Builder Studio, such as
  • Folders and tables created by yourself or
  • Folders, tables, and other objects created after importing tables
• Also you can delete or wipe clean your project configurations and settings from inside your account, including Db sources configured, generated code and builds.

Here are some details and navigation steps to clean-up:

• Builder Studio Data
  • Delete Folders from "Studio - Explore Tables", then
    • Settings → Trash
    • Select Actions: Refresh Trash Tree, Empty Trash, Empty Trash Deep
• To Delete Db sources configured
  • Import Tables → New Db Source → Db Sources List → Del (each)
• Project Configure → Settings
  • Update Datasource Properties section fields to blank
• To delete generated code
  • Build | Factory → Delete Gen Folders → Delete (each)

tip

If your folders are in-accessible, not showing in Explorer → Refresh Category Tree

• Also perform this action before and after Builder Studio Data deleting,
• How to Refresh Category Tree →
  • Dashboard → "Studio - Explore Tables" → Refresh Category Tree (in top right side bar), or
  • Settings → Refresh Category Tree
  • → do Refresh for Inbox and Trash