dsccommunity / dsccommunity/SqlServerDsc
SqlIntegrationServicesCatalog: Resource to perform the initial creation of the Integration Services Catalog
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Resource proposal
Microsoft has documented how to problematically create the SSIS Catalog here https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver16#to-create-the-ssisdb-catalog-programmatically
It would be beneficial if the SqlServerDsc was able to incorporate this additional capability, to automate another part of configuring a SQL Server.
Proposed properties
| Property | Type qualifier | Data type | Description | Default value | Allowed values |
|---|---|---|---|---|---|
| CatalogPassword | Password | String | Password utilized to encrypt the Integration Services Catalog | None | None |
Special considerations or limitations
None.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with Microsoft's SSIS Catalog creation documentation linked in the issue, then inspect the existing SqlServerDsc resources for patterns. Done means adding a resource that automates initial Integration Services Catalog creation and accepts CatalogPassword for encryption.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100