docs.visulate.netProduct Overview Visulate for Oracle

Visulate for Oracle support@visulate.com 321 698 5198 Visulate for Oracle Supporting Oracle database developers and DBAs Oracle developers and DBAs are often frustrated by inadequate documentation for databases whose schemas have changed over a number of years. Visulate addresses this problem by using Oracle’s internal data dictionary to generate documentation. Users supply read-only connection details for one or more the databases. Visulate queries the data dictionary for each connection. Results can be viewed via a browser based UI or REST API calls. It was developed by Peter Goldthorp a Google certified cloud architect with over 25 years of product development experience at Oracle and OCI. With Visulate you can spend less time analyzing Oracle environments and accelerate your migration to the Cloud Learn More Features Database Documentation Search and browse the data dictionary in multiple databases. Dependency Analysis Query the database’s dependency model to identify dependencies between objects. CSV File Generation Run SQL statements to review table contents and generate CSV files. Code Generation Extract SQL statements from PL/SQL procedures. Generate code from database metadata API Support REST APIs for all application features. Cloud native An enterprise-ready Kubernetes application on Google Cloud Marketplace. Common use cases On-Premises to Cloud Migrations Document and analyze on-premises environments prior to migration. Review system utilization for capacity planning. Identify lift and shift” projects and candidates for conversion to microservices or other database engines. Document custom code in E-Business Suite databases. Review the contents of old databases. Identify targets for consolidation or decommissioning. Data Extracts Analyze star, snowflake and 3NF schemas in the Oracle data warehouse. Execute queries to review data values and prototype denormalized structures. Generate CSV from SQL statements for download as files or streaming to Cloud Storage. Generate code stubs from Oracle table and PL/SQL metadata for use in ETL tools. Replicate data from Oracle via REST APIs. Application Development Review Oracle schemas to identify Oracle specific data types and indexes. Examine custom PL/SQL and other database related program logic in stored procedures, packages and triggers. Extract SQL statements and business logic. Rewrite in other languages. Visulate for Oracle Product Overview Quickstart How-to guides Database analysis Dependency analysis PL/SQL analysis CSV file generation Code Generation E-Business Suite Database Concepts Application Architecture Setup Installation Setup a database account Register a database Autonomous Database Registration SQL Query Engine configuration Configure your network Add a TLS Certificate IAP Configuration Update to a later version...