SQL server snap - Unexpected Re-throwing connection error
Hi Community, I was trying to access SQL server via snaplogic but I wasn’t successful as I was facing an issue with the connection. Below are the two error messages when I tried with different plexes. Error while validating with groundplex Failed to validate account: Failed to retrieve a database connection. Cause: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “Unexpected rethrowing”. (Reason: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “Unexpected rethrowing”.; Resolution: Address the reported issue.) Error while validating with cloudplex: Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host ***********************, port 1433 has failed. Error: “null. 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: “null. 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.) JDBC drives that I used: mssql-jdbc-9.4.0.jre8 mssql-jdbc-7.4.1.jre8 mssql-jdbc-10.2.0.jre8.jar mssql-jdbc-7.4.1.jre11.jar* Details: I would really appreciate if anyone could help me on this. Thank you.
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.
Box account with our own Box connected app
Hi, Today while creating the Box account, SnapLogic internally uses a connected app in Box (client_id=4y9mpks2hql3xchpudijkct1vfhwwklx), it is not possible to override this with our own connected app. Due to this at the Box side all the API calls are registered against “Snaplogic app” connected app. There is no way to track which project in SnapLogic is actually using the APIs. In our case we have many projects uses Box, each have their own quota of Box usage, since SnapLogic is using same connected app at the Box side we are not able to govern the Box usage accurately. Is there a way or implementation plan in progress to allow feed in out own client_id for Box account? Regards, Sripathi
