Prerequisites
This page provides a checklist of requirements to help you to prepare for data generation jobs. Completing these steps ensures the Syntho application is correctly configured, accessible, and ready for data generation and management. Please follow each step to confirm your setup meets all prerequisites.
1. Deployment and Initial Setup
Application Deployment: Ensure the application is deployed successfully, and the UI is accessible. Verify that the first admin user can log in, see Deployment Guide for more information.
User Accounts and Access Management:
Ensure that admin and user accounts are set up.
Credentials (username/password) are distributed securely, adhering to internal policies of User Management Guide.
2. Database Access Configuration
Source Database: Confirm that day-to-day users do not require access to the source database.
Destination Database: Ensure users have access to the destination database, allowing operations such as table truncation, which is required for multiple data generation runs.
3. Workspace Configuration
Workspace Creation: Create a workspace following the Workspace Setup Guide.
Database Connection Test: Verify that the source database is available and accessible within the Syntho application by performing a connection test:
In the Syntho application, navigate to Workspace Settings and select Database Connections.
Input the connection details for both source and destination databases and select Test Connection.
Ensure a successful connection is indicated by a green checkmark, confirming access to both databases.
4. Data Alignment and Preparation
Data Types Alignment: Ensure data type consistency between source and destination databases. Data types should be appropriately set:
Date columns as
Date
Integer columns as
Integer
Decimal columns as
Decimal/Float
Schema Consistency: The destination database must have the same tables and columns as the source database but should remain empty, with write access enabled.
Datasets
To enhance the user experience, we provide sample datasets tailored to different use cases. For testing purposes, users can access a multi-table dataset, while for analytics, we offer a single-table dataset. Additionally, a two-table sequence dataset is available for sequence-based modeling and evaluation. These datasets serve as a practical starting point for exploring Syntho's features and capabilities.
Single-table dataset (for analytics)
Choose any of the tables from covid dataset. There are 16 tables.
Two-table sequence dataset (for sequence-based modeling)
Multi-table dataset (for testing)
Last updated