Report export to external database?

padma03
New Contributor III
New Contributor III

Hi Team,

Is there a way to export a Saviynt report to external database?

Thanks

Padmalochan

17 REPLIES 17

rushikeshvartak
All-Star
All-Star
  1. create DB Connection
  2. Create Analytics & attach external connection as target database rushikeshvartak_0-1658501912203.png

     

padma03
New Contributor III
New Contributor III

 

Thanks Rushikesh for the inputs.

Dave
Community Manager
Community Manager

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!

mamta_juyal
New Contributor II
New Contributor II

Hi @rushikeshvartak 

Could you please explain it in detail?

Thanks& regards,

Mamta

 

 

 

  • Create analytics report using SQL query Sample Query : select username from DBA_USERS
  • Consider database is oracle database. 
  • Create DB connection with required parameters like connection name, url, username, password & driver
  • Now attach above DB connection to analytics which will connect to target database

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.

mamta_juyal_0-1659960877804.png

Thanks & Regards,

Mamta

Please share query.

This error is regarding alias 

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

if you are running query in data analyzer then you dont need to attach external connection

Hi ,

The same query is getting results through analytics.

Our requirement is to export   the analytics report to external database.

Regards,

Mamta

to Export analytics report you can export from Analytics history open report action - export as csv/Excel

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.

Follow same steps mentioned above

Above mentioned steps are to export data to csv / excel file but not to external database.

You can’t directly export

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.


Regards,
Saathvik

sonalimathkar
New Contributor II
New Contributor II

Thanks for the confirmation.

regards,

Sonali.