and more in a single search tool across platforms. Read the announcement here. |
07/22/2022 07:35 AM
Hi Team,
Is there a way to export a Saviynt report to external database?
Thanks
Padmalochan
Solved! Go to Solution.
07/22/2022 07:58 AM
07/22/2022 08:02 AM
Thanks Rushikesh for the inputs.
07/25/2022 09:32 AM
Hi @padma03 - If the answer provided by Rushikesh answered your question, please click the "Accept As Solution" button on his reply so others can easily find it. Thank you!
08/08/2022 04:33 AM
08/08/2022 04:44 AM
08/08/2022 05:16 AM
Hi Rushikesh,
Thank you for your reply but we are getting the below error when selecting external connection .
If we are not selecting an external connection query is working fine.
Thanks & Regards,
Mamta
08/08/2022 05:41 AM
Please share query.
This error is regarding alias
08/08/2022 05:45 AM
Hi Rushikesh ,
Please find below query. Its working fine in data analyzer.
SELECT DISPLAYNAME as USR_DISPLAY_NAME,EMAIL as USR_EMAIL,DATE_FORMAT(CUSTOMPROPERTY25,'%m/%d/%Y') USR_UDF_EFFECTIVEDTE,CUSTOMPROPERTY24 as USR_UDF_TEMPTOPERMCONVERSION,CUSTOMPROPERTY23 as USR_UDF_TEMPCONTRACTORID,DATE_FORMAT(CUSTOMPROPERTY22, '%m/%d/%Y') USR_UDF_CONVERSIONDTE,CUSTOMPROPERTY21 as USR_UDF_ZONE,CUSTOMPROPERTY20 as USR_UDF_STOREMANAGER,CUSTOMPROPERTY19 as USR_STATUS,CUSTOMPROPERTY18 as USR_UDF_REGTEMP,CUSTOMPROPERTY17 as USR_POSTAL_ADDRESS, CUSTOMPROPERTY16 as USR_UDF_MANAGERLEVEL,CUSTOMPROPERTY15 as USR_UDF_LEGALNAME,CUSTOMPROPERTY14 as USR_UDF_JOBSUBFUNCTION,CUSTOMPROPERTY13 as USR_UDF_JOBFAMILY,CUSTOMPROPERTY12 as USR_HOME_POSTAL_ADDRESS,CUSTOMPROPERTY11 as USR_UDF_FUNCTIONALAREA,CUSTOMPROPERTY10 as USR_UDF_FIDOORGUNIT,CUSTOMPROPERTY9 as USR_UDF_FIDOJOBTITLE,CUSTOMPROPERTY8 as USR_UDF_EMPLOYEESTATUS,CUSTOMPROPERTY7 as USR_UDF_DIVISION,CUSTOMPROPERTY6 as USR_UDF_DISTRICTMANAGER,CUSTOMPROPERTY5 as USR_UDF_DISTRICT,CUSTOMPROPERTY4 as USR_UDF_DEPARTMENTFAMILY,CUSTOMPROPERTY3 as USR_UDF_CHAIN,CUSTOMPROPERTY2 as USR_UDF_CASHOFFICE,COMPANYNAME as USR_UDF_COMPANYNAME,LOCATIONDESC as USR_UDF_WORKLOCATIONDESC ,USERNAME as USR_LOGIN,STATE as USR_STATE,DATE_FORMAT(STARTDATE, '%m/%d/%Y') USR_UDF_SERVICEDTE,REGION as USR_UDF_REGION,REGIONCODE as USR_POSTAL_CODE,Owner as USR_MANAGER ,PHONENUMBER as USR_UDF_PHONE,MIDDLENAME as USR_MIDDLE_NAME,LASTNAME as USR_LAST_NAME ,FIRSTNAME as USR_FIRST_NAME,Location as USR_UDF_LOCATION,JOB_FUNCTION as USR_UDF_JOBFUNCTIONCODE,JOBDESCRIPTION as USR_TITLE ,JOBCODE as USR_JOB_CODE,DATE_FORMAT(TERMDATE, '%m/%d/%Y')USR_END_DTE,EMPLOYEETYPE as USR_EMP_TYPE,EMPLOYEEID as USR_EMP_NO,DEPARTMENTNAME as USR_UDF_DEPARTMENTNAME,DEPARTMENTNUMBER as USR_UDF_DEPARTMENT,City as USR_UDF_CITY, Manager as USR_MANAGER_KEY ,5 as ACT_KEY FROM users where UPDATEDATE > now() - interval 24 hour.
Thanks & Regards,
Mamta
08/08/2022 05:51 AM
if you are running query in data analyzer then you dont need to attach external connection
08/08/2022 05:54 AM
Hi ,
The same query is getting results through analytics.
Our requirement is to export the analytics report to external database.
Regards,
Mamta
08/08/2022 05:56 AM
to Export analytics report you can export from Analytics history open report action - export as csv/Excel
01/17/2023 02:54 AM
Hello Rushikesh,
We have similar requirements i.e. to export configuration analytics report to external database.
We have option to export to Elasticsearch database. Can we export directly to external database using DB connection from either Analytics page or using My Downloads page.
regards,
Sonali.
01/17/2023 05:25 AM
Follow same steps mentioned above
01/17/2023 11:07 PM
Above mentioned steps are to export data to csv / excel file but not to external database.
01/18/2023 04:30 AM
You can’t directly export
01/18/2023 05:51 AM
Above mentioned steps are to run the query against external database using saviynt analytics feature and then you can manually download the report from analytics history. You cannot directly export the data to external DB.
01/18/2023 11:41 PM
Thanks for the confirmation.
regards,
Sonali.