Solix CDP Application Retirement Remote

Course Highlights

  • Overview
  • Structured Data Migration
  • Semi-Structured Data Migration
  • UnStructured Data Migration
  • Tools - Scheduler
  • Enterprise Business Record (EBR)
  • Data Access
  • Retention Management & Legal Hold

About this Course

The Solix CDP Application Retirement training equips participants with the expertise to efficiently retire large volumes of data from legacy databases to target databases. Leveraging Solix CDP's capabilities, participants learn to seamlessly move bulk data between sources, such as legacy applications, while preserving table structures in the target database. By designing criteria based on metadata, participants can identify data for retirement in the application database effectively. Solix CDP Application Retirement provides a viable solution for transferring data between databases and heterogeneous sources with efficiency. Through this training, participants acquire the knowledge and skills needed to execute bulk migrations successfully, optimizing data management processes and facilitating smooth transitions from legacy systems to modern infrastructures.

  • Overview
    • Overview of Solix Common Data Platform (CDP)
    • Overview of Solix CDP Architecture
    • Application Retirement Overview
    • Application retirement – Best Practices
    • Role Based User Setup
    • User & user profile setup
    • Connectivity – Structured, Semi-Structured and unstructured data source
    • Defining Source and Target
    • Knowledge Base Creation
    • KB Population
    • Data Migration & Validation
  • Structured Data Migration
    • Bulk Migration
    • Validations
  • Semi-Structured Data Migration
    • Bulk Migration
    • Validations
  • UnStructured Data Migration
    • Bulk Migration
    • Validations
    • Unitary (Drag N Drop) File archiving
  • Tools - Scheduler
  • Enterprise Business Record (EBR)
  • Data Access
    • Data Access Tools overview
    • Solr Indexing and Search
    • Using SQL Editor
    • EBR’s
    • Reports
    • Forms
    • File Archive Report / File Explorer
  • Retention Management and Legal Hold
    • Retention Management workflow
    • Creating Retention Policy
    • Assigning Retention Policy
    • Approving Notification & Retention policy execution
    • Retention Audit Report
    • Legal Hold Configuration
    • Applying Legal Hold
    • Legal Hold Search
  • Overview of Service Reports & Metadata Audit Reports

Solix CDP Data Access Remote

Course Highlights

  • Solix CDP Overview
  • Solix Data Access Tools
  • Archive Forms
  • Solix SOLR Text Search
  • EBRs from Target
  • SQL Editor

About this Course

The Data Access service training within the Solix Common Data Platform (CDP) equips participants with advanced skills in utilizing a comprehensive reporting tool. This tool enables seamless access to target data objects and empowers users to generate customized reports and forms with querying capabilities while maintaining data integrity for compliance purposes. Participants gain proficiency in constructing queries at both table and object levels, tailoring reports to specific requirements. Additionally, the training introduces the concept of compound objects, facilitating the creation of reports and forms that access migrated data on the target platform through heterogeneous data objects like views, tables, EBR configurations, table metadata views, and materialized views.

  • Solix CDP Overview
  • Solix Data Access Tools
    • Archive Reports
      • Creating Archive Reports
      • Building Archive Reports with dynamic criteria
      • Various Formatting options
      • Downloading Reports
    • Archive Forms
      • Build form with Single Table
      • Build form with Multiple Tables
    • Solix SOLR Text Search
      • Implementation
      • Wildcard Search
      • Complex Query
      • Advanced Search
      • Data Indexing
    • EBRs from Target
      • Create EBR from Target data
      • EBR with Column Aliases
      • Create Reports on EBRs
      • EBR with various options
    • SQL Editor
      • Write SQL queries on target data
      • Save and Assign SQL Queries
  • Accessing File attachments through File policy creation and assignment
  • File Archiving Report
  • File Explorer
  • View Builder & Materialized Views
  • Service Reports
  • Meta Data Audit Reports

Solix CDP Active Archiving Remote

Course Highlights

  • Overview of Solix Common Data Platform(CDP)
  • Data quality assessment
  • Defining relationships
  • De-Coupled archiving
  • Tools - Scheduler
  • Data access
  • Retention management and legal hold

About this Course

The Enterprise Active Archiving training focuses on the practice of transferring inactive or historical data to separate storage devices for long-term retention, freeing up primary storage resources and optimizing database performance. Solix CDP serves as a bridge between primary and archival storage, enabling seamless access to archived data. A key feature is the ability to submit archive or dearchive requests for approval, ensuring data governance and relevance. Solix CDP supports archiving from multiple sources into a unified storage, streamlining the process and providing centralized management. This training equips organizations with the tools to effectively manage data lifecycles, optimize storage, and ensure regulatory compliance.

  • Overview
    • Overview of Solix Common Data Platform
    • Overview of CDP Architecture
    • Role Based User Setup
    • User and user profile setup
    • Defining source and target
    • Knowledge Base Creation
    • Knowledge Base Population
  • Data Quality Assessment
    • Ability to check incoming data
    • Understanding of CDP data quality requirements
    • Validation
    • Active archiving best practices
  • Defining Relationships
  • Tightly Coupled Archiving
    • Data Active Archiving
    • De-archiving
    • Validations
  • De-Coupled Archiving
    • Active Archiving
    • De-archiving
    • Validations
  • Tools - Scheduler
    • Automating periodic Archiving using scheduler
  • Catch-up Archiving
    • Automating catch-up archiving
  • Enterprise Business Record (EBR)
    • Source EBR
    • Target EBR
  • Data Access
    • Data Access Tools Overview
    • Solr Indexing and Search
    • Using SQL Editor
    • Reports
    • Forms
  • Retention Management and Legal Hold
    • Retention Management Workflow
    • Creating Approval Policy
    • Creating Retention Policy
    • Assigning Retention Policy
    • Approving Notification & Retention policy execution
    • Retention Audit Report
    • Legal Hold Configuration
    • Applying Legal Hold
    • Legal Hold Search
  • Overview of Service Reports & Metadata Audit Reports

Solix CDP Installation Course

Course Highlights

  • Solix CDP 3.0 - Architecture
  • Software Requirements
  • Hardware Recommendations
  • Solix CDP 3.0 Repository Architecture
  • Solix CDP 3.0 Dev Ops Process
  • Additional Software Requirements

About this Course

The Solix CDP Installation Course is designed to provide comprehensive training on the installation process of the Solix CDP, empowering participants with the knowledge and skills necessary for successful deployment. Throughout this course, participants will gain a deep understanding of the installation procedures, configuration options, and best practices for setting up the Solix CDP environment. From initial setup to advanced configurations, this course equips learners with the expertise needed to effectively install and configure the Solix CDP, ensuring seamless integration within organization's data infrastructure.

  • System Administrator Training
    • Solix CDP 3.0 - Architecture (including HA)
    • Software Requirements
    • Hardware Recommendations
    • OS & Disk storage allocation
    • Backup Storage
    • Sudo user for the Installation & Internet access
    • CA certificates for HTTPS (SSL) access to CDP3.0 services, Private Key & Cert files Conversion
    • Email ID for Metrics Alerts
    • CDP 3.0 App access ports
    • Software download URLs behind Proxy & Ports needed to be open
    • Linux commands needed for different environments & SELinux Configuration
    • Solix CDP 3.0 Repository Architecture
    • Solix Repository Deployment Process
    • Deploying Solix Repository Multi-Node Cluster (CN & WN)
    • Create your first Database
    • Adding new Worker Node to existing cluster
    • Enable SSL for Solix Repository & Metadata DB Nodes
    • Copy SSL files to CN, WN, and Metadata Nodes
    • Configure key & cert file in the PostgreSQL.conf file
    • Verify the Encryption
    • Solix CDP 3.0 Dev Ops Process
    • Microservices Kubernetes Deployment Architecture
    • Installation and configuration of Tools
    • Solix CDP Metadata Deployment Process
    • Executing Metadata scripts through the Docker container
    • NFS Server Installation & JDBC Drivers, SSL Configuration
    • Deploying CDP 3.0 using Rancher
    • Monitoring and Alerting
    • Install Java 11
    • Install Zookeeper
    • Install Solr
    • Enable SSL for Solr
    • Backup & Restore Solr data
    • Node_exporter for host metrics
    • Postgres_exporter for Solix Repository metrics
    • Solr exporter for Solr Server metrics
    • Prometheus for host & services metrics collection
    • Alertmanager for emailing alerts
    • Grafana for metrics dashboard
    • PgAdmin web console for Solix Repository

Solix CDP Administrator Course

Course Highlights

  • Overview
  • Controlling data access through Entities
  • Dashboard Settings
  • Login & Password Management
  • Overview of Data Access Tools
  • Production Cutover process

About this Course

The Administrative Course equips participants with vital skills and knowledge for adeptly managing and configuring the Solix CDP environment. Participants gain hands-on experience in tasks such as setting up data connections, configuring extraction parameters, and ensuring data integrity. Additionally, they learn to establish target databases, define storage locations, and manage user access. The course covers configuring storage repositories, creating knowledge bases for data organization, and setting up metadata repositories.

  • Overview
    • Overview & architecture of Solix Common Data Platform (CDP)
    • Overview of use cases (AR, AA, DG, DM etc.)
    • Role based access
    • Define user profiles
    • Define users, roles, and privileges
    • Define Source and target (for Structured and Unstructured Data)
    • Knowledge base creation
    • Assign KB and profile to users
    • Overview of KB population, Data Migration and Validation
  • Controlling data access through Entities
    • Create entities
    • Assign objects to entities
    • Assign entity to users
  • Dashboard settings
  • Login & password management
  • Overview of Data Access tools
    • Search
    • Reports
    • Forms
    • SQL Editor
    • EBRs
  • Service reports & metadata audit reports
  • Email configuration setup
  • SSL setup
  • LDAP/AD setup and onboarding users
  • Overview of SSO setup
  • Hadoop config setup in Solix CDP
  • SDLC
  • Solix CDP instances, environments (Dev, Test, and Prod)
  • Production cutover process
    • KB export & import
    • Data/Files copy
  • Overview of Data Governance (Data Retention & Legal Holds)
  • Release management

Solix CDP – SAP Application Retirement

Course Highlights

  • Overview
  • Part 1 - SAP Bulk Migration
  • Part 2 - SAP Application Retirement
  • Retention Management and Legal Hold

About this Course

The training program delves into Solix CDP's capabilities for facilitating data migration from pool tables and cluster tables within SAP applications. Participants will explore the process whereby Solix CDP initiates calls to AR Attachments RFC to handle the extraction of attachments from GOS/DMS, followed by the File Move RFC for transferring attachments to the Solix CDP server. Subsequently, Solix CDP coordinates the movement of attachments to designated storage configurations like Azure Blob Storage or S3 Bucket.

Additionally, the training sheds light on Solix CDP's ability to extract data from Source ADK files and ingest it into a target database, providing participants with a holistic understanding of data migration within the Solix CDP ecosystem. Through practical demonstrations and hands-on exercises, participants will gain proficiency in utilizing Solix CDP to seamlessly migrate SAP application data, ensuring efficient data management and storage.

  • Overview
    • Overview of Solix Common Data Platform (CDP)
    • Overview of Solix CDP Architecture
    • Application Retirement Overview
    • SAP Application Retirement Overview, Workflow
    • Application Retirement – Best Practices
    • Role Based User Setup
    • User and User Profile setup
    • Connectivity – Structured, Unstructured and Semi-Structured
    • Defining Source and Target
    • Knowledge Base Creation
    • KB Population
    • Data Migration & Validation
  • Part 1 - SAP Bulk Migration
    • Install Solix CDP Add-on for SAP
    • Configure SAP Applications in CDP
    • SAP Bulk Migration – ADK Files (CSV files)
    • SAP Bulk Migration – Pool and cluster tables (CSV files)
    • SAP Bulk Migration – Unstructured (Attachments)
  • Part 2 - SAP Application Retirement
    • Data Access Tools Overview
    • Solr Indexing and Search
    • Using SQL Editor
    • EBR’s
    • Reports
    • Forms
  • Retention Management and Legal Hold
    • Retention Management Workflow
    • Creating Approval Policy
    • Creating Retention Policy
    • Assigning Retention Policy
    • Approving Notification & Retention policy execution
    • Retention Audit Report
    • Legal Hold Configuration
    • Applying Legal Hold
    • Legal Hold Search

Solix CDP – SAP Active Archiving

Course Highlights

  • Overview
  • Data Quality Assessment
  • Defining Relationships
  • Tightly Coupled Archiving
  • De-Coupled Archiving
  • Tools - Scheduler
  • Catch-up Archiving
  • Enterprise Business Record (EBR)
  • Data Access
  • Retention Management and Legal Hold

About this Course

The Solix CDP SAP Data Archiving training equips participants with the skills and knowledge needed to efficiently archive and delete SAP data using the Solix CDP platform. This specialized program covers the entire archiving process, from triggering remote calls to SAP application for generating ADK files to moving ADK and CSV files to the Solix CDP NFS repository. Participants will learn to navigate the SAP archiving screen, maintain configurations, execute archive configurations, and utilize preprocessing to ensure data readiness before archiving. Additionally, insights into Solix CDP's enhancement of SAP archiving, including reloading SAP data back onto the SAP database, will be provided.

  • Overview
    • Overview of Solix Common Data Platform (CDP)
    • Overview of Solix CDP Architecture
    • Role Based User Setup
    • User and User Profile setup
    • Defining Source and Target
    • Knowledge Base Creation
    • Knowledge Base Population
  • Data Quality Assessment
    • Ability to check incoming data
    • Understanding of Solix CDP Data Quality requirements
    • Validation
    • Active Archiving Best Practices
  • Defining Relationships
  • Tightly Coupled Archiving
    • Data Active Archiving
    • De-archiving
    • Validations
  • De-Coupled Archiving
    • Active Archiving
    • De-archiving
    • Validations
  • Tools - Scheduler
    • Automating periodic Archiving using scheduler
  • Catch-up Archiving
    • Automating catch-up archiving
  • Enterprise Business Record (EBR)
    • Source EBR
    • Target EBR
  • Data Access
    • Data Access Tools Overview
    • Solr Indexing and Search
    • Using SQL Editor
    • Reports
    • Forms
  • Retention Management and Legal Hold
    • Retention Management Workflow
    • Creating Approval Policy
    • Creating Retention Policy
    • Assigning Retention Policy
    • Approving Notification & Retention policy execution
    • Retention Audit Report
    • Legal Hold Configuration
    • Applying Legal Hold
    • Legal Hold Search
  • Overview of Service Reports & Metadata Audit Reports

Solix CDP Active Archiving

Course Highlights

  • Overview
  • Data Quality Assessment
  • Defining Relationships
  • Tightly Coupled Archiving
  • De-Coupled Archiving
  • Tools - Scheduler
  • Catch-up Archiving
  • Enterprise Business Record (EBR)
  • Data Access
  • Retention Management and Legal Hold

About this Course

The Enterprise Active Archiving training focuses on the practice of transferring inactive or historical data to separate storage devices for long-term retention, freeing up primary storage resources and optimizing database performance. Solix CDP serves as a bridge between primary and archival storage, enabling seamless access to archived data. A key feature is the ability to submit archive or dearchive requests for approval, ensuring data governance and relevance. Solix CDP supports archiving from multiple sources into a unified storage, streamlining the process and providing centralized management. This training equips organizations with the tools to effectively manage data lifecycles, optimize storage, and ensure regulatory compliance.

  • Overview
    • Overview of Solix Common Data Platform (CDP)
    • Overview of Solix CDP Architecture
    • Role Based User Setup
    • User and User Profile setup
    • Defining Source and Target
    • Knowledge Base Creation
    • Knowledge Base Population
  • Data Quality Assessment
    • Ability to check incoming data
    • Understanding of CDP Data Quality requirements
    • Validation
    • Active Archiving Best Practices
  • Defining Relationships
  • Tightly Coupled Archiving
    • Data Active Archiving
    • De-archiving
    • Validations
  • De-Coupled Archiving
    • Active Archiving
    • De-archiving
    • Validations
  • Tools - Scheduler
    • Automating periodic Archiving using scheduler
  • Catch-up Archiving
    • Automating catch-up archiving
  • Enterprise Business Record (EBR)
    • Source EBR
    • Target EBR
  • Data Access
    • Data Access Tools Overview
    • Solr Indexing and Search
    • Using SQL Editor
    • Reports
    • Forms
  • Retention Management and Legal Hold
    • Retention Management Workflow
    • Creating Approval Policy
    • Creating Retention Policy
    • Assigning Retention Policy
    • Approving Notification & Retention policy execution
    • Retention Audit Report
    • Legal Hold Configuration
    • Applying Legal Hold
    • Legal Hold Search
  • Overview of Service Reports & Metadata Audit Reports

Solix CDP Data Access

Course Highlights

  • Solix CDP Overview
  • Solix Data Access Tools
  • Archive Forms
  • Solix SOLR Text Search
  • EBRs from Target
  • SQL Editor

About this Course

The Data Access service training within the Solix Common Data Platform (CDP) equips participants with advanced skills in utilizing a comprehensive reporting tool. This tool enables seamless access to target data objects and empowers users to generate customized reports and forms with querying capabilities while maintaining data integrity for compliance purposes. Participants gain proficiency in constructing queries at both table and object levels, tailoring reports to specific requirements. Additionally, the training introduces the concept of compound objects, facilitating the creation of reports and forms that access migrated data on the target platform through heterogeneous data objects like views, tables, EBR configurations, table metadata views, and materialized views.

  • Solix CDP Overview
  • Solix Data Access Tools
    • Archive Reports
      • Creating Archive Reports
      • Building Archive Reports with dynamic criteria
      • Various Formatting options
      • Downloading Reports
    • Archive Forms
      • Build form with Single Table
      • Build form with Multiple Tables
    • Solix SOLR Text Search
      • Implementation
      • Wildcard Search
      • Complex Query
      • Advanced Search
      • Data Indexing
    • EBRs from Target
      • Create EBR from Target data
      • EBR with Column Aliases
      • Create Reports on EBRs
      • EBR with various options
    • SQL Editor
      • Write SQL queries on target data
      • Save and Assign SQL Queries
  • Accessing File attachments through File policy creation and assignment
  • File Archiving Report
  • File Explorer
  • View Builder & Materialized Views
  • Service Reports
  • Meta Data Audit Reports

Solix CDP Application Retirement

Course Highlights

  • Overview
  • Structured Data Migration
  • Semi-Structured Data Migration
  • UnStructured Data Migration
  • Tools - Scheduler
  • Enterprise Business Record (EBR)
  • Data Access
  • Retention Management & Legal Hold

About this Course

The CDP Application Retirement training equips participants with the expertise to efficiently retire large volumes of data from legacy databases to target databases. Leveraging SCDP's capabilities, participants learn to seamlessly move bulk data between sources, such as legacy applications, while preserving table structures in the target database. By designing criteria based on metadata, participants can identify data for retirement in the application database effectively. SCDP Application Retirement provides a viable solution for transferring data between databases and heterogeneous sources with efficiency. Through this training, participants acquire the knowledge and skills needed to execute bulk migrations successfully, optimizing data management processes and facilitating smooth transitions from legacy systems to modern infrastructures.

  • Overview
    • Overview of Solix Common Data Platform
    • Overview of CDP Architecture
    • Application Retirement Overview
    • Application retirement – Best Practices
    • Role Based User Setup
    • User & user profile setup
    • Connectivity – Structured, Semi-Structured and unstructured data source
    • Defining Source and Target
    • Knowledge Base Creation
    • KB Population
    • Data Migration & Validation
  • Structured Data Migration
    • Bulk Migration
    • Validations
  • Semi-Structured Data Migration
    • Bulk Migration
    • Validations
  • UnStructured Data Migration
    • Bulk Migration
    • Validations
    • Unitary (Drag N Drop) File archiving
  • Tools - Scheduler
  • Enterprise Business Record (EBR)
  • Data Access
    • Data Access Tools overview
    • Solr Indexing and Search
    • Using SQL Editor
    • EBR’s
    • Reports
    • Forms
    • File Archive Report / File Explorer
  • Retention Management and Legal Hold
    • Retention Management workflow
    • Creating Retention Policy
    • Assigning Retention Policy
    • Approving Notification & Retention policy execution
    • Retention Audit Report
    • Legal Hold Configuration
    • Applying Legal Hold
    • Legal Hold Search
  • Overview of Service Reports & Metadata Audit Reports