Integration server: database access using database module?

Hello everyone,

I am using Visual Dialplan and Integration Server from Apstel and currently I have a database module license problem:

When I have installed Integration Server and connected to a database, it comes with one free license for database module.

So, when I call, the dialplan is executed, it asks the Integration Server for using his database module, which is designed to simplify SQL query execution from within the dial plan against any database that provides JDBC drivers ( MS SQL, MySQL, Postgres, Sybase, HSQL, etc.).

The module will handle connection to the database server, execute the SQL query and manage the result set.

So the price would be rising a lot if we buy many licenses in case we 're using this for call center!

I want to know if there is an alternative in order to have an access to a database, execute SQL queries and return back the results?

Thank you for your answers.

There are many ways
asteriskdocs.org/en/3rd_Edition/ … sk-DB.html

I think the problem here is that the OP is assuming everyone is familiar with the products he is using and understand why he would want to use them. I am not familiar with the products and therefore don’t understand what he is really trying to do…

I don’t think this is about ways of doing things with databases but about ways of doing them with the perceived benefits of the particular products.

I think he was asking for this, and if so there are many ways to do it

[quote=“peter59”]
I want to know if there an alternative in order to have an access to a database, execute SQL queries and return back the results?

Thank you for your answers.[/quote]

Thank you for your answers,

If this link could help people to understand the software what I’m talking about:
apstel.com/apstel-integration-server/

The Integration Server contains a database module which can handle connections to the Database, execute SQL statements and management of the result set.

Unfortunately, the Apstel forum is dead so that’s why I ask here…

That page doesn’t explain what advantage it provides over the native database support in Asterisk.

The advantage it provides is the fact we can configure the connection to the database directly on the software not on the server, so it’s easier.

For information, my database server is Oracle and I am using the JDBC driver.

The native database support in Asterisk is to configure manually the files? If this is the case, how can I do this?