Webinar extracts – Maximize Your Productivity with ER/Studio Macros: The Magic Wand for Data Modelers

On May the 9^th, I have presented a webinar: Maximize Your Productivity with ER/Studio Macros: The Magic Wand for Data Modelers

In this post, I’ll share a video with the most interesting extracts. This video provides chapters, so do not hesitate to navigate to the ones you are the most interested by.

Among other things, you’ll see:

• • how to create a new macro from scratch
    • from ER/Studio Data Architect
    • from Microsoft Excel
  • how to customize an existing sample to tweak it as you need
  • where you can find the different documentations

Here are the links used during the presentation:

• • Documentations:
    • https://docs.embarcadero.com/products/er_studio/
    • https://docwiki.embarcadero.com/ERStudioDA/en/User_Guide
    • https://docwiki.embarcadero.com/ERStudioDA/en/Automating_ER/Studio_Data_Architect
  • The directory in which to store the macros
    • https://docwiki.embarcadero.com/ERStudioDA/en/Customizing_Standard_Model_Features_for_New_Models#Directories_tab
  • Create a macro with ER/Studio Data Architect
  • Customize an existing macro
  • Add shortcuts to your macros
    • https://docwiki.embarcadero.com/ERStudioDA/en/Adding_Macros_to_GUI_Modeling_Menus
    • (You can also check this other post which shares a macro to manage all your shortcuts)
  • Create a macro with Microsoft Excel
  • Using Quick Launch files with macros to automate repetitive tasks
    • https://docwiki.embarcadero.com/ERStudioDA/en/Running_ER/Studio_Data_Architect_Macros_from_Windows
    • https://blog.idera.com/database-tools/er-studio-data-architect/how-to-generate-a-report-from-a-macro/