Connect to an external SQL database

Solved489 views
0
0 Comments

Hi Dojo,

we have an external SQL database and I want to connect our Dataminer to it.
There are information’s which we than use to create services in Dataminer.

What would be the best approach? Using a Automation script and receive the data and after that trigger service template to create the services?

Stefan Schedletzky [DevOps Enabler] Selected answer as best 4th February 2025

2 Answers

1
18.57K 2 Comments

Hi Stefan,

For this use case, you could proceed as follows:

  • Ingest stage:
    Use the connector indicated by Arun to interface with the DB. This connector will enable you to control and monitor the data ingestion process effectively.
  • Processing/provisioning stage:
    Depending of your requirements, you could use either an automation script or a connector:

    • If monitoring is required:
      A driver is the recommended approach. You can use an alarm template to monitor the provisioning, and maintain logs of previous provisioning executions. A connector can also facilitate CRUD operations for service provisioning.
    • If monitoring is not required:
      If you only need to provision services without monitoring the process, an automation script is a suitable option.

In both cases, if possible, try to use a service template to provision services.

Hope it helps.

Stefan Schedletzky [DevOps Enabler] Selected answer as best 4th February 2025
Stefan Schedletzky [DevOps Enabler] commented

Hi Miguel,
thanks as usual for your detailed answer. Could you give me a link for CRUD operations for service porvisioning inside a connector? How I can interact with the service template from the connector?
BR,
Stefan
Miguel Obregon [SLC] [DevOps Catalyst] commented

Hi Stefan,
Apologies for the delay in my reply. I had a look and the class library supports only reading, creation, and deletion operations for services. You can find more information in DataMiner Docs:
https://docs.dataminer.services/develop/api/types/Skyline.DataMiner.Core.DataMinerSystem.Common.IDma.html

I could not find the update operation though. Let me know if you need to update services so I can further investigate.

The only remark here is that these methods don't use service templates.

Hope it helps.
1
4.01K 1 Comment

Hi Stefan,

Can you try using this driver ?
This connector can connect to an SQL Server database, execute queries, and retrieve the responses.

Generic SQL Query | Catalog

Stefan Schedletzky [DevOps Enabler] Posted new comment 4th February 2025
Stefan Schedletzky [DevOps Enabler] commented

Hi,
do you know why this protocol is not possible to deploy as trial?
For any other protocol deploy button is shown