sql statements in sql connectors

  • Klaus79
        4 years ago #23280

        Hello,

        does anybody know if it is possible to get an overview/list of sql statements used in sql connector calls.

         

         

        Best regards

        Klaus

        Christian Kleinschroth
            Has successfully completed the online course Introduction
            Has successfully completed the online course Intermediate (200)
            Has successfully completed the online course Advanced (300)
            Has successfully completed the online course Basics (100)
            Has successfully completed the online course Advanced (310)
            Has successfully completed the online course Advanced (320)
            Has successfully completed the Intermediate Certification
            Has successfully completed the Advanced Certification
          4 years ago #23283
          Up
          0
          Down
          ::

          Hello Klaus,

           

          the SQL Statement is visible in the Logs & Monitoring Component see screenhot attachted.

          SQL Log

          Klaus79
              4 years ago #23284
              Up
              0
              Down
              ::

              Hello Christian,

              yeah, that’s true but I do not mean that.

              I’ve about 15 sql connectors and maybe more than 100 connector calls.

              I need an overview which attributes are used in a result or in where-clause in which connector call in which connector because unfortunately I’ve to split connectors for secure reasons (e.g. for attribute encryption).

              Therefore I’ve to analyze all connector calls…

               

              Best regards

              Klaus

              Christian Kleinschroth
                  Has successfully completed the online course Introduction
                  Has successfully completed the online course Intermediate (200)
                  Has successfully completed the online course Advanced (300)
                  Has successfully completed the online course Basics (100)
                  Has successfully completed the online course Advanced (310)
                  Has successfully completed the online course Advanced (320)
                  Has successfully completed the Intermediate Certification
                  Has successfully completed the Advanced Certification
                4 years ago #23294
                Up
                0
                Down
                ::

                Hello Claus,

                in this case it is a lot easier to monitor all incoming sql queries directly in the database (for e.g. via mysql query log etc) instead within simplifier.

                Klaus79
                    4 years ago #23296
                    Up
                    0
                    Down
                    ::

                    Hello Chris,

                    but that means I’ve to execute all scenarios which costs a lot of time.

                    Is there no option within Simmplifier to get that overview?

                    Maybe Simplifier staff could do it once a time directly at database level?

                     

                    Best regards

                    Klaus

                  Viewing 5 posts - 1 through 5 (of 5 total)

                  You must be logged in to reply to this topic.