Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
12/08/2023 10:47 AM - edited 12/13/2023 11:51 AM
Hi all,
Hoping to gain some clarification on the EPIC connector. The following is what I found in the Epic connector guide [Using Classic Integration (saviyntcloud.com)]:
Epic provides exports of EMP and SER data in an XML format with Microsoft Excel tags. Saviynt provides a custom extension jar to convert these XML files to CSV files used for account and access import.
Based on the above, we have several questions on implementing the Epic connector on Saviynt for import functionality:
Thanks in advance for any assistance with these questions.
Regards,
Jake
12/11/2023 11:56 PM
Hi @jake,
We are looking into your request and we will keep you posted.
12/12/2023 12:12 AM
Hi @jake,
Kindly let us know if you are following the below mentioned documentation for EPIC connector.
Link:-https://docs.saviyntcloud.com/bundle/EPIC-Guide/page/Content/Understanding-Integration-between-EIC-and-EPIC.htm
12/12/2023 10:37 AM
Hi,
Thank you for the reply. We are following this integration guide: https://docs.saviyntcloud.com/bundle/Epic-v23x/page/Content/About-this-guide.htm [EPIC Connector]. All of the questions in my original post are based on my analysis of using the above EPIC Connector for the integration with Saviynt.
We are looking for Saviynt's Epic connector to return accounts and entitlements [templates and subtemplates]. To achieve this, which option/connector is the preferred/recommended option by Saviynt?:
1. [LDAP Connector] https://docs.saviyntcloud.com/bundle/EPIC-Guide/page/Content/Understanding-Integration-between-EIC-a...
2. [EPIC / EPIC (EPIC) Connector] https://docs.saviyntcloud.com/bundle/Epic-v23x/page/Content/About-this-guide.htm
Based on your responses, we will investigate further into what connector to use.
Please advise, thank you!
Best,
Jake
12/13/2023 01:45 AM
Hi @jake,
Thanks for the update ,I am working internally for your request and we will keep you posted.
12/13/2023 11:47 AM - edited 12/13/2023 11:48 AM
Hi @DixshantValecha ,
Thank you for looking into this. I have updated the original set of questions in my original post.
Regards,
Jake
12/14/2023 11:47 AM
Hi @DixshantValecha ,
Curious if there are any updates to this request. Thank you for checking into this.
Regards,
Jake
01/09/2024 12:22 AM
Dear @jake,
I appreciate your patience, and I have gathered the necessary information in response to your recent inquiries. Below are the details:
Regarding questions 1 and 6, I am currently investigating these internally and will provide you with updates shortly.
For your question about Epic XML files, it is essential to copy these files onto the Saviynt server. This allows Saviynt to utilize a custom JAR for converting the XML files into CSV format.
The custom JAR responsible for converting Epic XML exports into CSV files is provided by Saviynt. To utilize this functionality, the JAR needs to be installed on the Saviynt server. Please note that it does not come pre-installed for customers using the Epic connector. Should you require assistance with the installation process, feel free to reach out to Saviynt support.
Yes, you can use a consistent file name, provided that the file name remains unchanged.
In the context of importing accounts and entitlements, the "EMP_DATA_MAPPING_JSON" parameter on the connection JSON form is crucial. You can utilize the sample JSON provided in the connector guide as a foundation for customization. This sample JSON serves as a basic mapping of CSV file fields to corresponding Saviynt fields. Feel free to modify this mapping to align with your specific requirements.
7.Clarification on the "EPIC (EPIC)" connection type: "EPIC (EPIC)" serves as a connection template specifically designed for the "EPIC" connection type.
Please review the information provided, and should you have any further inquiries or require additional details, Please let us know.
01/16/2024 01:28 AM
Hi @jake,
12/22/2023 05:41 AM
Hi @jake,
Thank you for your patience. We are presently in the process of concluding our response with the internal team. Upon receiving confirmation, we will promptly provide you with an update.
02/15/2024 08:36 PM
Hello Dixshant,
Thanks for your prompt response. Our Saviynt technical expert also recommended us to use the Staging DB connector which will get data EPIC DB.
I have these following questions on the Staging DB method:
1. How data gets from Epic to the recommended intermediary database? Does the client has to write any SQL queries to pull data into the intermediary database from the EPIC DB? Do we have the SQL scripts to pull data which I can recommend it to the client?
2. I see that the staging DB should be SQL serve DB? What is the recommended version of the SQL staging DB?
Here is the flow of data from EPIC DB to Staging DB:
Waiting for your response......I have recommended the client staging DB option and we w
Thanks
Sunil
06/21/2024 04:01 AM
Hi @sangitaladi and @sunrashinkar,
Please provide the document link you are referencing that includes the above mentioned snapshot.
03/11/2024 12:16 PM
Hello Saviynt Team,
A response on my above set of questions is highly appreciated.
Tks
Sunil
03/18/2024 12:57 PM
Hello Saviynt
Any update on my above questions.
Tks
Sunil
03/18/2024 11:15 PM
Hi @sunrashinkar,
Thanks for your patience,We are reviewing your request and we will keep you posted on the same.
04/03/2024 01:13 AM
Hi Team
A gentle reminder on the above request.
Regards
Sangita ladi
04/03/2024 04:59 AM
Hi,
Thank you for your patience. We are currently conducting internal investigations regarding your request, and we will provide you with an update shortly.
04/08/2024 05:00 AM
Hi Team
A gentle reminder on the above queries.
Regards
Sangita Ladi
06/21/2024 04:08 AM
Hi @sangitaladi and @sunrashinkar,
Please provide the document link you are referencing that includes the mentioned snapshot.