Skip to main content

LS Data Director

LS Data Director is a data management and synchronization tool for LS Central systems. This guide covers setup, configuration, and usage of LS Data Director.

Overview​

LS Data Director provides:

  • Data Synchronization - Synchronize data between systems
  • Data Management - Manage and transform data
  • Import/Export - Import and export data from various sources
  • Data Validation - Validate data integrity
  • Scheduling - Automated data processing

Prerequisites​

Before setting up LS Data Director, ensure you have:

  • ✅ LS Central system installed
  • ✅ Database access credentials
  • ✅ Network connectivity
  • ✅ Required licenses
  • ✅ Administrative permissions
  • ✅ Understanding of data structures

Installation​

Step 1: System Requirements​

  1. Hardware Requirements

    • Windows Server or Windows 10/11
    • Minimum 4GB RAM (8GB+ recommended)
    • Sufficient disk space
    • Network connectivity

  2. Software Requirements

    • .NET Framework (latest version)
    • SQL Server connectivity
    • LS Central components
    • Required drivers

Step 2: Install LS Data Director​

  1. Access the Installer

    • Ensure you are connected to the same network as the shared storage server
    • Navigate to the network path: 
      \\172.16.16.3\d\Setup\Server Install\4- Install Data Sync
    • Locate the installer file: LS.DataDirector.3.02.104.Setup.exe
    • Run the installer executable
    Network Access
    • Network Connection Required: You must be connected to the same network as the shared storage server
    • IP Address Varies: The IP address (172.16.16.3) may change from branch to branch
    • Verify IP: Confirm the correct IP address for your branch before accessing the network path

  2. Installation Wizard Steps

    • Select Destination Location

      • Default location: C:\Program Files (x86)\LS Retail\Data Director 3
      • Click Next to continue or Browse to select a different location

    • Select Additional Tasks

      • Check the following options:
        • ✅ Install DD Service
        • ✅ Install Client Tools
        • ✅ Install DD Add-ins files for NAV/BC SRV
        • ✅ Install Incoming DD Web Service
      • Click Next to continue

    • IIS Web Application Setup (if applicable)

      • Web Site name: Default Web Site
      • Web Service name: DDWebService (recommended to leave as default)
      • Web Service File Path: C:\inetpub\wwwroot\DDWebService
      • Click Next to continue

    • Ready to Install

      • Review the installation summary:
        • Destination location
        • Additional tasks to be installed
      • Click Install to begin installation

  3. Initial Configuration

    • Set up database connections
    • Configure service accounts
    • Set up file locations
    • Configure logging
Installation Best Practices
  • Install on a server with good network connectivity
  • Use dedicated service accounts
  • Configure appropriate file permissions
  • Set up logging for troubleshooting

Configuration​

Database Connections​

  1. Configure Source Database

    • Set up connection to source database
    • Test connectivity
    • Verify permissions
    • Configure connection settings

  2. Configure Target Database

    • Set up connection to target database
    • Test connectivity
    • Verify permissions
    • Configure connection settings

Connection Settings​

SettingDescriptionExample
Server NameSQL Server instanceSERVER01\NAVINSTANCE
Database NameTarget databaseNAV_Database
AuthenticationWindows/SQL AuthWindows Authentication
Connection TimeoutTimeout in seconds30

Data Synchronization​

Setting Up Sync Jobs​

  1. Create Sync Job

    • Open LS Data Director
    • Create new synchronization job
    • Configure source and target
    • Set up mapping rules

  2. Configure Sync Rules

    • Define data mapping
    • Set up transformation rules
    • Configure filters
    • Set conflict resolution

  3. Schedule Synchronization

    • Set sync frequency
    • Configure schedule
    • Set up notifications
    • Test sync process

Sync Types​

  • Full Sync - Complete data synchronization
  • Incremental Sync - Only changed data
  • One-Time Sync - Manual synchronization
  • Scheduled Sync - Automated synchronization
Sync Best Practices
  • Use incremental sync for large datasets
  • Schedule syncs during off-peak hours
  • Monitor sync performance
  • Test sync procedures regularly

Data Import/Export​

Importing Data​

  1. Prepare Data Source

    • Format data correctly
    • Validate data structure
    • Check data quality
    • Prepare import file

  2. Configure Import

    • Select import source
    • Map fields
    • Set validation rules
    • Configure error handling

  3. Execute Import

    • Run import process
    • Monitor progress
    • Review import logs
    • Verify imported data

Exporting Data​

  1. Configure Export

    • Select data to export
    • Choose export format
    • Set up filters
    • Configure output location

  2. Execute Export

    • Run export process
    • Monitor progress
    • Verify exported data
    • Archive export files

Data Validation​

Validation Rules​

  1. Set Up Validation

    • Define validation rules
    • Configure data checks
    • Set up error handling
    • Configure notifications

  2. Common Validations

    • Required field checks
    • Data format validation
    • Range validation
    • Referential integrity

Error Handling​

  • Log Errors - Record validation errors
  • Skip Invalid Records - Continue processing
  • Stop on Error - Halt on first error
  • Report Errors - Generate error reports

Scheduling​

Creating Scheduled Jobs​

  1. Define Job

    • Create synchronization job
    • Configure job parameters
    • Set up dependencies
    • Configure notifications

  2. Schedule Job

    • Set execution schedule
    • Configure recurrence
    • Set up conditions
    • Test schedule

Schedule Options​

  • Daily - Run once per day
  • Weekly - Run on specific days
  • Monthly - Run on specific dates
  • Custom - Custom schedule pattern

Monitoring & Logging​

Monitoring Jobs​

  1. Job Status

    • Monitor job execution
    • Check job history
    • Review success/failure rates
    • Identify issues

  2. Performance Monitoring

    • Track execution times
    • Monitor resource usage
    • Identify bottlenecks
    • Optimize performance

Logging​

  • Enable Logging - Configure log levels
  • Log Locations - Set log file paths
  • Log Retention - Configure log retention
  • Log Analysis - Review logs regularly

Troubleshooting​

Common Issues​

IssueSolution
Connection ErrorsCheck database connectivity, verify credentials, check firewall
Sync FailuresReview sync logs, check data mapping, verify permissions
Performance IssuesOptimize queries, check indexes, review sync frequency
Data ErrorsValidate source data, check mapping rules, review validation

Diagnostic Steps​

  1. Check Connections

    • Verify database connectivity
    • Test connection strings
    • Check network connectivity
    • Review firewall rules

  2. Review Logs

    • Check application logs
    • Review sync logs
    • Analyze error messages
    • Identify patterns

  3. Verify Configuration

    • Check job configuration
    • Verify mapping rules
    • Review schedule settings
    • Confirm permissions

Best Practices​

Configuration​

  • ✅ Use appropriate sync frequency
  • ✅ Configure proper error handling
  • ✅ Set up monitoring and alerts
  • ✅ Document all configurations
  • ✅ Test changes in staging first

Performance​

  • ✅ Use incremental sync when possible
  • ✅ Optimize data queries
  • ✅ Schedule during off-peak hours
  • ✅ Monitor resource usage
  • ✅ Regular performance tuning

Security​

  • ✅ Use secure connections
  • ✅ Implement proper authentication
  • ✅ Limit access permissions
  • ✅ Encrypt sensitive data
  • ✅ Regular security audits

Questions?​

For questions about LS Data Director:

  • Contact your Technical Team Lead
  • Reach out to the Head of Software Department
  • Check LS Central documentation
  • Review system administration guides

Need help? Don't hesitate to reach out! 🚀

Last updated on by shellatomic