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.

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