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?
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.
- If monitoring is required:
In both cases, if possible, try to use a service template to provision services.
Hope it helps.
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.
Hi Stefan,
Can you try using this driver ?
This connector can connect to an SQL Server database, execute queries, and retrieve the responses.
Hi,
do you know why this protocol is not possible to deploy as trial?
For any other protocol deploy button is shown
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