question

PrathimaAlapati-4137 avatar image
0 Votes"
PrathimaAlapati-4137 asked Monalv-msft edited

How to use x-api-key in SSIS connection manager

we have rewritten our api's to use x-api-key now i need to use that API in my SSIS. But the http connection manager will allow only basic authentication how can this be achieved ?

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @PrathimaAlapati-4137 ,

SSIS (SQL Server Integration Service) is a data migration software which is used to extract, transform, and load the data. Apart from extracting and loading the data, SSIS can also call the API to perform a certain task. Let’s take a scenario where the failure emails are stored in the database, and it has to be initiated in the night. Now, the problem is, we don’t have any UI screen to initiate these failure emails. So, we usually go with SQL jobs which are configured to run the SSIS packages on a scheduled basis.

Please refer to the following links:
1.How To Consume Web API Through SSIS Package
2.Example using Web Services with SQL Server Integration Services
3.Download source file from website with SSIS

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.






· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PrathimaAlapati-4137 ,

May I know if you have anything to update?

Best Regards,
Mona

0 Votes 0 ·