Podcast
Questions and Answers
What do you need to do for changes made within administrative tools to take effect?
What do you need to do for changes made within administrative tools to take effect?
- Access product improvement metrics
- Update the database drivers
- Restart the server (correct)
- Redownload the server log
Which option is not available in the Admin menu for users running HA instances?
Which option is not available in the Admin menu for users running HA instances?
- User Configuration (correct)
- Manage Backups
- Download Server Log
- Audit Product Improvement Metrics
What is contained in the downloaded server log file 'catalina.out'?
What is contained in the downloaded server log file 'catalina.out'?
- Client session details
- Encrypted messages
- Server logs in plaintext (correct)
- Database queries
Which menu option allows you to manage database drivers in Matillion ETL?
Which menu option allows you to manage database drivers in Matillion ETL?
Which action will occur if you click on 'Matillion ETL Updates' in the Admin menu?
Which action will occur if you click on 'Matillion ETL Updates' in the Admin menu?
Why is it recommended to immediately download the server log file after an error occurs?
Why is it recommended to immediately download the server log file after an error occurs?
In which mode is the 'Manage Groups' feature available in Matillion ETL?
In which mode is the 'Manage Groups' feature available in Matillion ETL?
What action can admins perform using the 'Manage Permissions' feature in Matillion ETL?
What action can admins perform using the 'Manage Permissions' feature in Matillion ETL?
When is the 'Audit Log' feature accessible in Matillion ETL?
When is the 'Audit Log' feature accessible in Matillion ETL?
What is the purpose of enabling 'Product Improvement Metrics' in Matillion ETL?
What is the purpose of enabling 'Product Improvement Metrics' in Matillion ETL?
What does the 'Migrate' feature in Matillion ETL enable users to do?
What does the 'Migrate' feature in Matillion ETL enable users to do?
Where can Matillion ETL be backed up from if not through the in-client Admin menu?
Where can Matillion ETL be backed up from if not through the in-client Admin menu?
What is the recommended action before upgrading an instance in Matillion ETL?
What is the recommended action before upgrading an instance in Matillion ETL?
What must a new user do before being added to a project in Matillion ETL?
What must a new user do before being added to a project in Matillion ETL?
How can users control access to Matillion ETL in terms of security?
How can users control access to Matillion ETL in terms of security?
What is the purpose of the 'Set Realm Parameters' form in Matillion ETL?
What is the purpose of the 'Set Realm Parameters' form in Matillion ETL?
In Matillion ETL, what action is necessary to enable SSL?
In Matillion ETL, what action is necessary to enable SSL?
Why are passwords entered via User Configuration displayed in plaintext?
Why are passwords entered via User Configuration displayed in plaintext?
What happens if External security is chosen in Matillion ETL?
What happens if External security is chosen in Matillion ETL?
What is the significance of uploading SSL certificates in Matillion ETL?
What is the significance of uploading SSL certificates in Matillion ETL?
What is the purpose of the 'Manage Database Drivers' function in Matillion ETL?
What is the purpose of the 'Manage Database Drivers' function in Matillion ETL?
What is the best course of action before enabling SSL in Matillion ETL?
What is the best course of action before enabling SSL in Matillion ETL?
What is the main goal of the guide for new Matillion ETL users?
What is the main goal of the guide for new Matillion ETL users?
Which panel in the Matillion ETL interface can be used to access Components, Shared Jobs, and Environments?
Which panel in the Matillion ETL interface can be used to access Components, Shared Jobs, and Environments?
What is the purpose of the Admin Menu in Matillion ETL?
What is the purpose of the Admin Menu in Matillion ETL?
Which menu option in Matillion ETL allows users to access a list of options related to the current Project?
Which menu option in Matillion ETL allows users to access a list of options related to the current Project?
What key functionality does the Shared Jobs and Environments Panel provide in Matillion ETL?
What key functionality does the Shared Jobs and Environments Panel provide in Matillion ETL?
In Matillion ETL, where can users access a list of options related to the current Project?
In Matillion ETL, where can users access a list of options related to the current Project?
What can be done in the 'Manage Project' option in Matillion ETL?
What can be done in the 'Manage Project' option in Matillion ETL?
What is the primary purpose of the 'Version Manage Versions' feature in Matillion ETL?
What is the primary purpose of the 'Version Manage Versions' feature in Matillion ETL?
What action does the 'Admin' option 'Manage Credentials' in Matillion ETL allow users to perform?
What action does the 'Admin' option 'Manage Credentials' in Matillion ETL allow users to perform?
In Matillion ETL, what does the 'Manage OAuth' feature enable users to configure?
In Matillion ETL, what does the 'Manage OAuth' feature enable users to configure?
What can be done using the 'Data Sharing Export' option in Matillion ETL?
What can be done using the 'Data Sharing Export' option in Matillion ETL?
Which action is NOT possible using the 'Recycle Bin' feature in Matillion ETL?
Which action is NOT possible using the 'Recycle Bin' feature in Matillion ETL?
'Change My Password' in Matillion ETL allows users to:
'Change My Password' in Matillion ETL allows users to:
'Manage Shared Jobs' in Matillion ETL enables users to:
'Manage Shared Jobs' in Matillion ETL enables users to:
'Manage Error Reporting' in Matillion ETL is used to:
'Manage Error Reporting' in Matillion ETL is used to:
'Add Environment' in Matillion ETL is used to:
'Add Environment' in Matillion ETL is used to:
What type of jobs generally manipulate data in the form of tables?
What type of jobs generally manipulate data in the form of tables?
How can users link multiple components together in Matillion ETL?
How can users link multiple components together in Matillion ETL?
What must all Orchestration Jobs start with in Matillion ETL?
What must all Orchestration Jobs start with in Matillion ETL?
What do the rings around a component on the job canvas represent in Matillion ETL?
What do the rings around a component on the job canvas represent in Matillion ETL?
What is the purpose of adding notes on the job canvas in Matillion ETL?
What is the purpose of adding notes on the job canvas in Matillion ETL?
In Matillion ETL, what is the purpose of the Components Panel?
In Matillion ETL, what is the purpose of the Components Panel?
How are the available components updated when switching between Orchestration and Transformation jobs in Matillion ETL?
How are the available components updated when switching between Orchestration and Transformation jobs in Matillion ETL?
Which feature in Matillion ETL allows users to perform custom calculations on table columns?
Which feature in Matillion ETL allows users to perform custom calculations on table columns?
Why do Transformation Jobs and Orchestration Jobs have different sets of components in Matillion ETL?
Why do Transformation Jobs and Orchestration Jobs have different sets of components in Matillion ETL?
'Job Canvas' in Matillion ETL allows users to __________.
'Job Canvas' in Matillion ETL allows users to __________.
What does the Environments panel in Matillion ETL describe?
What does the Environments panel in Matillion ETL describe?
What is the primary purpose of the Properties Panel in Matillion ETL?
What is the primary purpose of the Properties Panel in Matillion ETL?
In Matillion ETL, what functionality does the Lineage tab offer within the Properties Panel?
In Matillion ETL, what functionality does the Lineage tab offer within the Properties Panel?
What can users do by right-clicking on a component in the Canvas in Matillion ETL?
What can users do by right-clicking on a component in the Canvas in Matillion ETL?
Which tab in the Tasks Panel of Matillion ETL allows users to search the current project for matching components?
Which tab in the Tasks Panel of Matillion ETL allows users to search the current project for matching components?
What feature does the Admin dropdown menu provide to users with 'Admin' privileges in Matillion ETL?
What feature does the Admin dropdown menu provide to users with 'Admin' privileges in Matillion ETL?
In Matillion ETL, what are the Properties tabs commonly used for?
In Matillion ETL, what are the Properties tabs commonly used for?
'Run just that single component' is an option available when doing what in Matillion ETL?
'Run just that single component' is an option available when doing what in Matillion ETL?
In Matillion ETL, what is the primary function of the 'Tasks' tab in the Tasks Panel?
In Matillion ETL, what is the primary function of the 'Tasks' tab in the Tasks Panel?
What is displayed in the 'Notices' tab within the Admin Menu in Matillion ETL?
What is displayed in the 'Notices' tab within the Admin Menu in Matillion ETL?
What is the purpose of the 'Manage Groups' feature in Matillion ETL?
What is the purpose of the 'Manage Groups' feature in Matillion ETL?
What action can be performed using the 'Download Server Log' option in Matillion ETL?
What action can be performed using the 'Download Server Log' option in Matillion ETL?
What information can users access through the 'Support Information' option in the Help dropdown menu in Matillion ETL?
What information can users access through the 'Support Information' option in the Help dropdown menu in Matillion ETL?
What does enabling 'Product Improvement Metrics' in Matillion ETL allow users to do?
What does enabling 'Product Improvement Metrics' in Matillion ETL allow users to do?
What is the main function of 'Restart Server' in Matillion ETL?
What is the main function of 'Restart Server' in Matillion ETL?
How does 'Manage Database Drivers' contribute to functionality within Matillion ETL?
How does 'Manage Database Drivers' contribute to functionality within Matillion ETL?
What does 'Manage Backups' entail in terms of functionality in Matillion ETL?
What does 'Manage Backups' entail in terms of functionality in Matillion ETL?
What benefit does enabling SSL in Matillion ETL provide?
What benefit does enabling SSL in Matillion ETL provide?
What is the primary purpose of 'Manage Permissions' in Matillion ETL?
What is the primary purpose of 'Manage Permissions' in Matillion ETL?
Study Notes
Admin Menu Overview
- The Admin dropdown menu allows administrators to access various administrative tools.
- Only administrators can view and access the Admin menu.
- Some options may be unavailable for users running HA (clustered) instances.
Admin Menu Tools
- Download Server Log: downloads the Tomcat Catalina server logs of the Matillion ETL instance.
- Matillion ETL Updates: opens the Matillion ETL Updates pop-up window.
- User Configuration: allows admins to manage users, internal and external security, and SSL.
- Manage Groups: allows admins to create, edit, and remove groups (only available in Enterprise Mode).
- Manage Permissions: allows admins to adjust permission settings for groups (only available in Enterprise Mode).
- Audit: shows a list of significant activity within a Matillion ETL instance (only available when in a project and only in Enterprise Mode).
- Product Improvement Metrics: allows the collection of anonymous usage data to help Matillion build a better product.
- Migrate: allows transferring certain resources from one instance to another.
- Restart Server: allows admins to restart the Matillion ETL instance.
- Manage Database Drivers: allows uploading JDBC drivers for use with Database Query components.
- Manage Backups: allows testing and scheduling automatic backups of the instance.
User Configuration
- Internal Security: uses an instance-based database of username, passwords, and privileges.
- External Security: uses an existing directory server (e.g., OpenLDAP or Microsoft Active Directory).
- SSL: allows enabling SSL and uploading SSL certificates to validate the identity of the server.
Other Features
- Shared Jobs Panel: allows users to bundle entire workflows into a single custom component.
- Environments Panel: lists environments associated with the current instance, along with their schemas, tables, and columns.
- Properties Panel: displays detailed information about a component, including properties, export, sample, metadata, lineage, SQL, and help.
- Tasks Panel: shows information about tasks that have been run during the current session.
- Admin Menu: allows administrators to manage the Matillion ETL instance.### Navigation Panel
- Displays all available jobs in a Matillion ETL project
- No limit to the number of jobs in a project
- Double-clicking a job opens it on the Job Canvas
- Right-clicking in the panel allows creating, deleting, importing, exporting jobs, and creating job folders
Job Types
- Orchestration Job: loads and unloads data to tables and file storage, staging data
- Transformation Job: manipulates data in the form of tables
- Each job is made up of a series of tasks, each represented by a "component"
Job Canvas
- Displays the contents of a selected job
- Each open job is represented by a tab above the job canvas
- Components can be found in the Components panel and dragged onto the job canvas
- Components must be linked together in the order they will be executed
Component Connections
- Green / Success: Continue to the next component if executed successfully
- Red / Failed: Continue to the next component if failed to execute
- Grey / Unconditional: Continue to the next component regardless of success or failure
- Blue / Iterate: Continue to another component (regarding iterator components)
Components Panel
- A collapsible list of all components available to the currently selected job type
- Search field at the top allows searching for specific components by name
- Each component embodies a particular function, from moving data to performing custom calculations
- Components are named according to their function
Shared Jobs and Environments Panel
- Allows managing user privileges and access rights
- Configures and manages HTTP and HTTPS requests
- Manages database drivers, backups, and groups (Enterprise Mode only)
- Displays a log of all activity on the Matillion ETL instance
Help Menu
- Provides a list of useful information about Matillion ETL
- Includes getting support, sending advanced enquiries, and managing connections
- Displays information about the current Matillion ETL version and licenses
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Learn about the various administrative tools available in the Matillion ETL instance via the Admin dropdown menu. Explore options such as managing user configurations, SSL, database drivers, backups, groups, permissions, auditing, metrics, and migrating notes. Note that only administrators can access this menu.