Ask The Expert Series on March 8, 2022 
Monarch & Monarch Server(Automator)

The Session began with a brief overview of Classic Mode Overview in Monarch Complete v.2021 before diving into the LIVE Questions. 

The Session began with our Expert reviewing the following:

• Session began with Chris providing overview of utilizing/working in Classic Mode of Monarch Complete.
  
  • Shared how one may set default setting to launch in DPS Mode within Monarch Complete v.2020 and older
  • Latest Monarch Complete does not offer that option/setting. By default launches in DPS Mode unless opening a Classic Model which will launch in Classic Mode.
  • Online Help Guide - Chapters 6-15 for Classic Mode
  • Online Help Guide - Chapters 1-5 for DPS Mode
• Chris reviewed the various Menu options: Home, Report, Table, Summary
• Within Classic Mode: one may utilize color scheme to show limits.  Currently not available in DPS Mode. 
  
  

LIVE Questions submitted:

Monarch:
1.  It has been a while since I've worked within Classic.  When I attempt to start a Classic session, I get all confused on even how to start. My attempts to start Classic end me up in the configuration part of the application.  Using Altair Monarch v.2020.1.  The onscreen help appears to be focused on Data Prep Studio?

• Once selecting the Online help, you will want to navigate to Chapter 6-15 for tips on working within Classic Mode. 

2.  Can you add a SQL Table to Classic for Lookup on this?  {Discussed at approx. 50-minutes into the session}

• Yes.  Via Classic through External Lookup.  Set up the ODBC connection prior, then utilize the Lookup.  This is where DPS can perform this task a bit "nicer"/easier with Lookup.  Classic just returns the 1st row whereas, DPS doe not limit the relationship.  External Lookup through Class and ADD function from the Design Window. 

3.  Padding a field: is that first character or last character?

• It is space between fields when using fixed length fields.  If you had three fields, each one character wide, containing A, B, and C, the default fixed width table would be "A B C".  With the "pad" each field with one extra space option ticked, so it would be "A  B  C".    

 

Monarch Server:
1.  When we have a connection and write to a table where we have the option to Overwrite or Append data to.  I want to change the default to never be Overwrite - I want that to be Append. Is there a way we can change that?

•  Sorry, it is not possible to change the default setting.  It will be remembered once you set it, of course, but all options will still be available. 
  

PART II:   It is just that when it creates a table the max limits of the data type is 4000 characters... that's not right to assume that. 

•  We believe DPS removes this restriction for most formats.  The team will need to understand the data type that is being exported to test/verify. 

 

Additional Resources:

Monarch Classic- Home              Classic Mode: Summary View               Classic Mode: Export View

Classic Mode: Report View         Classic Mode: Table View                      Creating External Lookup (Classic)

Monarch Server(Automator) Guide