OpenText Analytics Database

The typical implementation process for OpenText Analytics Database software involves several key steps and can vary in duration depending on the complexity and scale of the deployment.

1. Planning and Assessment:

   • Requirement Analysis: Understanding the specific needs and goals of the business.

   • Infrastructure Assessment: Evaluating existing infrastructure to determine compatibility and necessary upgrades.

2. Installation and Configuration:

   • Deployment Options: OpenText Analytics Database can be deployed in private data centers, public clouds, or hybrid environments.

   • Installation: Setting up OpenText Analytics Database on the chosen infrastructure.

   • Configuration: Customizing settings to optimize performance and meet business requirements.

3. Data Migration and Integration:

   • Data Ingestion: Importing data from various sources into OpenText Analytics Database .

   • Integration: Connecting OpenText Analytics Database with existing ETL (Extract, Transform, Load) and BI (Business Intelligence) tools.

4. Testing and Validation:

   • Performance Testing: Ensuring the system meets performance benchmarks.

   • Validation: Verifying data accuracy and system reliability.

5. Training and Support:

   • Training: Providing comprehensive training for users, which includes live, on-demand, and in-person sessions.

   • Support: Ongoing support from OpenText Analytics Database engineers and access to a community of users for troubleshooting and optimization.

OpenText Analytics Database customization process:

• Consumption Model: OpenText Analytics Database offers a usage-based or committed spend model, allowing businesses to choose a pricing structure that aligns with their usage patterns.

• Deployment Flexibility: Businesses can deploy OpenText Analytics Database in private data centers, public clouds, or hybrid environments, providing flexibility to match their infrastructure strategy.

• Client Drivers: OpenText Analytics Database supports various client drivers for different operating systems, Python, and security needs, ensuring compatibility with existing systems.

• Case Studies: Numerous case studies demonstrate how OpenText Analytics Database has been tailored to meet the needs of different organizations:

  • Criteo: Built a Big Data Center of Excellence with OpenText Analytics Database.

  • The Trade Desk: Processes 40,000 reports daily with OpenText Analytics Database

  • Simpli.fi: Delivers insights into ad campaign performance.

  • China PnR: Achieved a 422% ROI and an annual average benefit of approximately $1.9 million.

  • MassMutual: Evolved a data culture and provided fast analytics and reporting.

  • Finansbank: Unlocked a treasure vault of data.

  • Cerner: Optimized health information solutions to improve efficiency.

OpenText Analytics Database training and supports:

1. Training Programs:

   • Self-Paced Learning: On-demand courses that users can take at their own pace.

   • Instructor-Led Classes: Both virtual and in-person classes led by experienced instructors.

   • Certifications: OpenText Analytics Database offers a certification path to become a OpenText Analytics Database Certified Professional, which includes various levels of expertise.

2. Support Services:

   • 24x7 Support: Available with premium licenses, providing round-the-clock assistance for critical issues.

   • Community and Forums: Access to a user forum where customers can connect with OpenText Analytics Database engineers and other users to get quick answers to problems.

   • Knowledge Base: A vast repository of FAQs, product documentation, integration articles, and more, which can be accessed for troubleshooting and learning.

3. Professional Services:

   • Onboarding and Implementation: Personalized onboarding experiences to ensure smooth setup and integration, especially for cloud deployments like OpenText Analytics Database Accelerator.

   • Ongoing Monitoring and Upgrades: Continuous support for monitoring and upgrading the system to maintain optimal performance.

4. Additional Resources:

   • Webinars and Workshops: Regular webinars and best practices workshops to keep users updated on new features and best practices.

   • Consulting Services: End-to-end solution implementation and technology services to help improve systems and achieve business outcomes.

OpenText Analytics Database security measures:

1. Encryption:

   • Voltage Format-Preserving Encryption (FPE): OpenText Analytics Database integrates Voltage FPE to protect data in use for analytics, ensuring that sensitive data remains secure while being processed. This encryption method maintains the usability and referential integrity of the data, making it suitable for analytics without compromising security.

   • End-to-End Encryption: Data is encrypted in use, in motion, and at rest, using industry-standard protocols such as AES-256 for data at rest and SSL/TLS for data in transit.

2. Access Controls:

   • Fine-Grained Access Control: OpenText Analytics Database allows for detailed access control at the row and column levels, including column masking to restrict access to sensitive data.

   • Role-Based Access Control (RBAC): Users are assigned roles with specific permissions, ensuring that only authorized personnel can access or modify sensitive data.

3. Authentication:

   • Multi-Factor Authentication (MFA): OpenText Analytics Database supports MFA to enhance security by requiring multiple forms of verification before granting access.

   • LDAP and Kerberos: These authentication methods are supported to integrate with existing enterprise security frameworks.

4. Data Masking and Obfuscation:

   • Data Masking: OpenText Analytics Database can obfuscate or encrypt data to prevent unauthorized access and ensure compliance with data protection regulations.

5. Activity Monitoring and Auditing:

   • Real-Time Activity Monitoring: OpenText Analytics Database monitors all user actions in real-time to detect and prevent unauthorized access or data breaches.

   • Audit Trails: Comprehensive audit logs are maintained to track access and modifications to the database, which can be exported to other security domains for further analysis.

6. Database Firewall:

   • SQL Injection and Unauthorized Access Prevention: OpenText Analytics Database database firewall detects and blocks malicious SQL queries and unauthorized access attempts in real-time.

7. Compliance:

   • Regulatory Compliance: Vertica helps manage and automate compliance with various regulations, including GDPR and CCPA, by providing tools for data discovery, masking, and auditing.

OpenText Analytics Database Updates:

1. Release Frequency:

   • Quarterly Releases: OpenText Analytics Database typically releases updates on a quarterly basis. For example, the latest release, OpenText Vertica 23.3, was timed to the third quarter of 2023.

   • Continuous Updates: Since the introduction of OpenText Analytics Database version 11, the release cycle has become more continuous, with several smaller releases leading up to major versions.

2. Update Management:

   • Automated Updates: OpenText Analytics Database Accelerator, the SaaS version of OpenText Analytics Database automates the process of upgrades, backups, and installation, ensuring that the system is always up-to-date without manual intervention.

   • Documentation and Support: Detailed release notes and documentation are provided with each update to inform users about new features, changes, and any necessary actions.

   • Backward Compatibility: OpenText Analytics Database ensures that updates are backward compatible, minimizing disruptions and ensuring a smooth transition to new versions.

3. Security Patches:

   • Regular Security Patches: Security patches are included in regular updates to address vulnerabilities and enhance the overall security posture of the platform.

OpenText Analytics Database data ownership and portability:

Data Ownership

1. Projection Ownership:

   • Projections must be created in the same schema as their anchor tables. This ensures consistency and proper access control.

   • Ownership of projections does not automatically change when the anchor table is copied. This can lead to permission issues if the projection and table owners differ.

   • There is no direct command to change the owner of a projection, which can complicate ownership management.

2. Table Ownership:

   • The owner of a table can be viewed using specific SQL queries, but changing the owner requires appropriate privileges.

   • Ownership consistency is crucial for maintaining access control and ensuring that users have the necessary permissions to interact with database objects.

Data Portability

1. Data Export and Import:

   • OpenText Analytics Database allows for the export of data objects, which can be used to transfer data between different OpenText Analytics Database instances or other systems.

   • The platform supports standard data formats and integration with various data storage solutions, facilitating data movement and portability.

2. Compliance with Regulations:

   • OpenText Analytics Database integration with Voltage SecureData ensures compliance with data portability requirements under regulations like GDPR. This includes the ability to export data in a structured, commonly used, and machine-readable format.

OpenText Analytics Database scalability:

1. Elastic Scalability:

   • Eon Mode: OpenText Analytics Database in Eon Mode allows for the independent scaling of compute and storage resources. This mode is optimized for cloud environments and supports rapid scaling up or down based on workload demands.

   • Subclusters: Users can create subclusters to isolate workloads and allocate specific compute resources to different tasks. This helps in managing performance and cost efficiency by scaling resources as needed.

2. Horizontal and Vertical Scaling:

   • Horizontal Scaling: Adding more nodes to the OpenText Analytics Database cluster to handle increased data volumes and workloads. This method distributes data across multiple nodes, enhancing performance and fault tolerance.

   • Vertical Scaling: Upgrading the resources (CPU, memory, storage) of existing nodes to meet higher performance requirements. This approach is cost-effective and simpler to manage compared to horizontal scaling.

3. Hybrid Cloud Strategy:

   • OpenText Analytics Database supports hybrid cloud deployments, allowing organizations to leverage both on-premises and cloud resources. This flexibility ensures that analytics can be performed in the most suitable environment, whether for cost efficiency, performance, or regulatory compliance.

4. Automated Scaling:

   • In cloud environments, OpenText Analytics Database can automatically scale resources based on predefined policies. This includes hibernating compute nodes when not in use to save costs and rapidly provisioning them when needed.

OpenText Analytics Database terms and conditions:

Contract Renewal

1. Automatic Renewal:

   • OpenText Analytics Database subscriptions typically have an automatic renewal term. For example, the subscription will automatically renew for another 12-month period unless terminated by the customer before the end of the current term.

   • Customers are required to provide notice if they do not wish to renew their contract. Failure to do so will result in automatic renewal under the same terms.

2. Renewal Notification:

   • Customers may be required to cooperate in achieving a SaaS upgrade that Micro Focus determines is critical for the availability, performance, or security of the OpenText Analytics Database Accelerator solution. If the customer does not cooperate in a timely manner, additional fees may be charged.

Contract Cancellation

1. Cancellation Policy:

   • If a customer does not renew their contract at the end of their term, their service will be cancelled. This cancellation is effective upon the last day of the current order term.

   • Upon cancellation, expiration, or termination of the order term, Micro Focus may disable all customer access to Vertica Accelerator, and the customer must return or destroy any Micro Focus materials. The customer databases will no longer be accessible, and Micro Focus has no obligation to maintain or provide any data after decommissioning.

2. Early Cancellation Penalties:

   • For mid-month application or cancellation, the rate is calculated pro rata. A penalty will be charged for early cancellation within the contract period.

   • Cancellations or rescheduling with less than ten business days' notification will incur 100% of the offering fee.

3. Data Retrieval:

   • There is no termination data retrieval period because the data always resides in the customer environment. Customers are responsible for their data and must ensure they have retrieved it before the service is decommissioned.

OpenText Analytics Database adheres to the following compliance standards:

1. FIPS 140-2 Compliance: OpenText Analytics Database complies with the Federal Information Processing Standard (FIPS) 140-2, which defines the technical requirements for cryptographic modules used by federal agencies.

2. SRG Compliance: OpenText Analytics Database adheres to the Security Requirements Guide (SRG) compliance, which includes guidelines for securing and managing data within federal systems.

3. General Data Protection Regulation (GDPR): OpenText Analytics Database integration with Voltage SecureData helps manage and automate compliance with GDPR by providing tools for data discovery, masking, and auditing.

4. California Consumer Privacy Act (CCPA): Similar to GDPR, Vertica supports compliance with CCPA through its data protection and privacy features.

5. Industry-Standard Protocols: OpenText Analytics Database supports various industry-standard security protocols, including LDAP, Kerberos, TLS, FIPS 140-2, AWS IAM, and Apache Sentry, ensuring robust security and compliance across different environments.

6. Regulatory Compliance Automation: DataSunrise for OpenText Analytics Database provides features like activity monitoring, database firewall, data masking, and sensitive data discovery to help manage and automate compliance with various government regulations.