FEATURED CONTENT Securing and Optimizing Your SSIS to Amazon S3 Connections |
Amazon S3 often plays a central role in file-based integration workflows, whether as a staging location, archive layer, or exchange point between systems. When bringing S3 into an SSIS package, choosing the right authentication and network setup is an important part of building a secure and maintainable solution.
In this blog, we review the supported authentication options in KingswaySoft's Amazon S3 Connection Manager, including Access Key, Run as IAM Role, and Anonymous access. We also cover VPC Link for private routing and show how the connection can be reused across SSIS tasks and components.
Key Highlights from the Blog: Understand when to use Access Key, Run as IAM Role, or Anonymous authentication. Learn how VPC Link can help secure Amazon S3 traffic in regulated environments. See how the Amazon S3 Connection Manager can be used across file transfer and data flow components.
|
FEATURED TECHNIQUE
Reusing Recordsets Across SSIS Data Flows |
When the same source data is needed across multiple stages of an SSIS package, repeated service calls can add complexity, increase execution time, and introduce data consistency issues. Capturing the data once and reusing it later can help keep packages more efficient and easier to maintain.
In this blog, we show how KingswaySoft's Premium Recordset Source can be used with an SSIS object variable to reuse previously captured recordsets across separate data flows. Using a Shopify example, we demonstrate how to retrieve data once, store child records for later use, and continue downstream processing without additional API calls.
Key Highlights from the Blog: Learn how to capture records in an SSIS object variable for later reuse. See how Premium Recordset Source can restore saved recordsets into downstream data flows. Understand how this approach helps reduce repeated service calls and maintain data consistency.
|
FEATURED SOLUTION
Centralized SQL Server Agent Job Monitoring with SSIS and Splunk |
|
Monitoring SQL Server Agent jobs across multiple database servers can be difficult when execution history must be reviewed separately on each instance. Centralizing that telemetry helps operations teams gain better visibility into job health, identify failures faster, and track execution trends across environments.
In this blog, we show how to use KingswaySoft's Premium SQL Server Source to retrieve SQL Server Agent job metadata and stream it into Splunk using the REST Destination component and Splunk’s HTTP Event Collector API. We also cover incremental loading using a checkpoint table so only new job history records are processed in each run.
Key Highlights from the Blog: Learn how to retrieve SQL Server Agent job execution metadata from SQL Server system tables. See how to send structured job telemetry to Splunk using the HTTP Event Collector API. Understand how checkpoint-based incremental loading can support scalable centralized monitoring.
|
PLATFORM UPDATE
Salesforce SOAP API Login Retirement: Redefining How Integrations Authenticate |
Salesforce is shifting away from legacy SOAP API login() authentication, and this change has important implications for teams managing existing Salesforce integrations. Understanding how your current connections authenticate is an important step toward avoiding disruption and planning a smooth transition to supported modern authentication approaches.
Key Highlights from the Article: What the SOAP API login() retirement means for existing integrations. The error users may encounter when legacy SOAP login authentication is still in use. How OAuth-based authentication helps maintain Salesforce connectivity going forward.
|
NEW VIDEO RESOURCE
Getting Started with Firestore Components |
This video introduces the Firestore Components available in the SSIS Integration Toolkit. It covers how to configure the Firestore Connection Manager and work with the Firestore Source and Destination components to read and write Firestore data within SSIS integration projects. |
We are always looking to showcase the work of organizations achieving meaningful results through integration. Participating in a case study is an opportunity to highlight your success, gain visibility within your industry, and share your story with a broader audience.
If this is something you'd be interested in, you may contact us at marketing@kingswaysoft.com or submit the details using the form below. |
We Want to Hear From You! |
We would love to hear from you. We want to make sure that your interactions with us are easy and smooth. Fill us in - it will only take 3 minutes. Your feedback is greatly appreciated and will help improve your future experience with us. |
|
|
|
