cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Generic DB Query in EF2: when?

AntonioSousa
DynaMight Guru
DynaMight Guru

The "Generic DB Query Plugin" is one of the most used extensions by our customers. When is the ETA for the migration to EF2?

Antonio Sousa
12 REPLIES 12

Mike_L
Dynatrace Guru
Dynatrace Guru

Hi,
Most use cases can already be handled in EF2 through the declarative SQL data sources.

Two missing features are cron scheduling and custom connection strings. Both of which is being worked on. 

Our services department is also busy with an app to provide a UI experience for the different data sources for customers who don’t want to write YAML. SQL support is the first one planned.

Mike

AntonioSousa
DynaMight Guru
DynaMight Guru

@Mike_L,

While an app is OK, please don't forget that this extension is widely used in Managed environments.

It's also very important that the new extension use the same metrics, so clients don't loose the timeseries that they already have.

Antonio Sousa

There is no new extension planned. You can call the metrics whatever you want in the yaml, including custom.db.query just like the existing one does 

The app is just to help people with creating the YAML. It will not unlock new possibilities other than that.

Mike

@Mike_L,

If I understand correctly, Dynatrace will not be migrating the Generic DB Query to EF2???

Antonio Sousa

Correct. The EF2 method is to use the SQL data source to query databases. As these extensions then are signed together with the query it is a lot more secure.

As our services team saw the need to make it even easier than writing a YAML, we are creating the app to have a UI for creating, modifying and signing YAMLs.

Managed customers are directed towards the vscode addon to simplify the creation of the YAML.

Mike

Writing your own SQL queries using extensions is easier than it sounds. I also agree with Mike that just cron scheduling (e.g. run this query exactly on every hour aligned) and your own custom JDBC string are missing. It is possible to define the interval as of today, it's just not configurable in the extension config/ui.


Certified Dynatrace Master | Alanata a.s., Slovakia, Dynatrace Master Partner

@Mike_L,

I'm without words, again!

First of all, Dynatrace stated this in November:
https://www.dynatrace.com/news/blog/unmatched-scalability-and-security-of-dynatrace-extensions-now-a...

AntonioSousa_0-1717161786702.png

So, now we know that this is not true!

More, I'm pretty sure multiple clients we have and that use it are going to be quite unhappy! Having to write the yaml, is 1 or 2 orders of magnitude difficultier than it is today. And changing one query, we have to do it all over again??? Someone hasn't really thought how clients use Dynatrace, or at least, should be using it...

Antonio Sousa

Hello Antonio, I completely agree with your opinion here.

Most clients would find it extremely cumbersome to have to define everything inside the YAML.

We have this concern as well...

Great comment @AntonioSousa 👌

Hello Antonio

All you just said is exactly the concerns we have with this new SLQ framework.

There was an extensive answer by Darek from product management on this topic a year ago here:

https://community.dynatrace.com/t5/Extensions/Custom-Database-Queries-going-to-EF-2-0/m-p/216561

Mike

@Mike_L,

I remember this thread. At that time we were unaware that EF1 would be terminated. So, I was good with it. Now, it seems more and more clear to me that we have to have a plan B for EF1 termination!

I second what @ct_27  said at the time.

And regarding what Darek said, none of it will convince the several clients I have that use the extension...

Antonio Sousa

Featured Posts