Cloud Database

Your Cloud Database for your content is an SQL database and an integral part of your Loftware Cloud. This database allows you to establish a secure, centralized, and universally accessible dynamic data storage for your cloud labeling environment. This is the database that your Loftware Cloud users can work with when they design and share their labels or solutions.

Setup your Cloud Database:

1. Go to Administration > Storage > Cloud Database for Your Content.

2. Click the Create labeling database button. The New labeling database window opens.

3. Type in your user name and set the password. You will need these credentials later when connecting to the Cloud database from your labels, solutions, or configurations. The credentials are also mandatory if you want to connect to the database using your database editing software.

   Note

   You can connect to the Cloud database using any compatible SQL tool. Loftware recommends Microsoft SQL Server Management Studio.

   The SQL user name you create is assigned administrator permissions in your SQL database. You can define additional SQL users in Microsoft SQL Server Management Studio. For example, you can limit SQL users to specific tables in your (one) SQL database, or for security, define a "working user" that is not an administrator.

4. Click Create. When the window closes, your database is ready. You see Cloud Database information under Cloud database for your content:

   • Status displays your Cloud Database creation date.

   • Connection string example displays the connection string format for your Cloud Database in the cloud. To connect your Loftware clients to this database, update the connection string with your Loftware Cloud account user name and password.

Connect to your Cloud database:

1. In Control Center go to Administration > Storage > Cloud Database for Your Content.

2. Copy the Server name from the Connection string example.

   

3. Open Microsoft SQL Server Management Studio.

4. The Connect to Server window opens. Paste the Server name from the Connection string example.

   

5. Set Authentication to SQL Server Authentication.

6. Type in your database credentials.

7. Click Options and go to Connection Properties tab. Copy the database name from the Connection string example to the Connect to database field.

8. Click Connect.

Your Cloud Database is set up and ready to use in Control Center.

Cloud Database User Permissions

Loftware Control Center allows different users to access Cloud Database with different levels of permissions.

The SQL user name you create is assigned administrator permissions in your SQL database. You can define additional SQL users in Microsoft SQL Server Management Studio (or similar SQL management tools). For example, you can limit SQL users to specific tables in your SQL database, or for security, define users that are not administrators.

Since the database instance does not allow adding logins directly, add database users and roles using Transact-SQL (T-SQL) commands.

Below are the options for different user roles and their respective permissions:

• Administrators have full access to the database. They can create, modify, and delete database structures and manage all user permissions. The initial login created from the cloud setup is assigned administrator permissions.

• Label designers have permissions to select, insert, delete, and update data. This role is ideal for users who need to design and manage labels, requiring more access than a printer operator but less than an administrator.

  Example

  T-SQL command to create a user with select, insert, delete, and update permissions:

  CREATE USER [DATA_MANAGER] WITH PASSWORD = '';

  EXEC sp_addrolemember N'db_datareader', N'DATA_MANAGER';

  EXEC sp_addrolemember N'db_datawriter', N'DATA_MANAGER';
  

• Printer operators have read-only access to the database. They can view data but cannot make any modifications. This role is suitable for users who need to print labels without altering the database content.

  Example

  T-SQL command to create a read-only user:

  CREATE USER [OPERATOR] WITH PASSWORD = '';

  EXEC sp_addrolemember N'db_datareader', N'OPERATOR';