AWS S3 Connection failure
Hello, I am trying to connect to the AWS S3 bucket with the Access Key Id and Secret access key using the AWS S3 Account type in Snaplogic. But it fails to validate and throws an error Failed to validate account:Cause: Access Denied (Service: Amazon S3; Status Code: 403 Using the same credentials I am able to connect with AWS S3 Bucket using AWS CLI and in PostMan as well by selecting Authorization type as AWS Signature. Can someone please help to identify why it is failing to connect in Snaplogic only?
SQL Server account connection setup failing with multiple error
Hello Community, We are trying to setup SQL server account in Snaplogic, however, getting below error Invalid username password- Able to login with windows authentication in microsoft sql management studio Failed to validate account: Failed to retrieve a database connection. Cause: Login failed for user ‘\empid’. ClientConnectionId:27dc1f0c-b783-4327-8d10-c77c82f6c198 (Reason: Login failed for user ‘\empid’. ClientConnectionId:27dc1f0c-b783-4327-8d10-c77c82f6c198; Resolution: Ensure credentials are valid, multiple attempts with invalid credentials may result into account getting locked) If we use domainname/instancename in HOSTNAME, getting below error Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host /, port 1433 has failed. Error: “/. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”. (Reason: The TCP/IP connection to the host /, port 1433 has failed. Error: “/. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.; Resolution: Address the reported issue.) version - 13.0.5 Here are our account settings - Hostname: abc.bot.com/mydatabase port:1433 DBname:emp_name username: abc\123 password:<> Also, Please share sample account settings for our reference. Thank you in advance.
Workday Account Creation
Here are few steps on how to create a Workday Account for the Workday Read and Write Snaps. There are some important facts that you must know in order to create a Workday Account in SnapLogic. Here is a screenshot of the basic Workday Account Creation dialog box As you can see, there are some important fields. Label: An account Label for you to easily identify this Workday Account. This will be visible in your accounts section. Username: The Workday Account User Name (Typically an ISU - Integration System User) through which the workday connection is made with proper security configured on that account. Password: The workday account password Version: Typically the latest version just in numbers. As of this writing, it is “28.0” (Quotes not needed) Your Tenant and Host follow a combination of details assigned to you by Workday. Tenant: Typically a tenant name is assigned and allocated by Workday. During implementations, it will have _impl<1> as a suffix as negotiated during the implementations. The tenant name is usually a negotiated acronym during the Workday Implementations. Every environment has a different tenant name as is a general practice in multi-tenanted environments. So, be sure to find out the tenant name and environment you are connecting to. Host: This is often a quirky item where there is a lot of confusion. This is no different if you have already connected to Workday using Workday studio, EIBs etc. Typically Workday has multiple data centers and each customer is assigned a data center and a disaster recovery data center. So the host name is generally established during the implementation phases. As of this article’s date, Workday has 3 data centers and their respective derivation of information is as follows. These are directly quoted from Workday Community websites and can be verified if you have access to the Workday Community. 1. Portland 2. Ashburn 3. Dublin Remember that host name determines where and which environment you are connecting to. These vary during implementation times before you are in production and will change significantly after you are in production The other way you can get the host name is from the REST or Workday URL from a custom report developed in Workday. Once you have the custom report, click on Actions–>View URLs–> Copy the hyperlink for the Workday or Rest or any other URL on that page. The host name is the first part of the report URL. Hope this helps a bit in configuring the account for Workday. You can use the Workday Dynamic Account in case if you want to use variables to determine your connection details. The Dynamic Account supports Expressions.