asebastian's avatar
asebastian
New Member
2 years ago

SQL Import for SSR Migration

This package imports an Action that allows you to take an SQL query and convert it into a Query Definition (QD). It can also generate a report based on the generated QD.

This is intended to migrate Self-Service Reports (SSR) to the new Aras Reporting capability. The usage instructions describe how to export your SSRs as SQL queries.

Interested in this project? Check it out on GitHub!

https://github.com/ArasLabs/SQL-import-for-SSR-Migration

Contributors

AJ Sebastian, Aras Labs

License

Visit the project's LICENSE.md file for more information about licensing.

5 Comments

  • Suhas's avatar
    Suhas
    Ideator I
    3 months ago

    Hi asebastian ,

    Thanks for your quick response and guidance . I'm able to find out the Export to SQL button. 

    Regards,

    Suhas

  • asebastian's avatar
    asebastian
    New Member
    3 months ago

    Hi Suhas,

    Sorry for the confusion. The button appears in the actual editor for SSRs. The highlighted button will export your SSR to SQL: 

    I was able to get to this page from the SSR dashboard which by default is accessible in the My Innovator section on the TOC.

    AJ

  • Suhas's avatar
    Suhas
    Ideator I
    3 months ago

    Hello asebastian ,

    Thanks for the response. Please find the below screenshot:




    I have search SQL in CommandBarButton in my local environment but I'm unable to find out any SQL command button. 

    Please let me for any other information.

    Regards,

    Suhas

  • asebastian's avatar
    asebastian
    New Member
    3 months ago

    Hi Suhas,

    Can you provide a screenshot of the SSR in edit mode? The Export to SQL button is part of the OOTB solution.

    AJ

  • Suhas_Jagtap1's avatar
    Suhas_Jagtap1
    Ideator I
    3 months ago

    Hello asebastian ,

    After deploying package, I'm unable to see "Export to SQL" button on Aras 28 version after editing the Self-Service Reports. Can you please guide me?

    Regards,

    Suhas