Desktop productivity for business analysts and programmers

SAS with Guidewire

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

SAS with Guidewire

Hi,,

 

I am currently working on Guidewire Datahub. I wanted to understand if SAS can be used to integrate to Guidewire and develop and run jobs.

Guidewire is an Insurance Suite with Claim Center, Billing Center and Policy Center. I am aware that SAP BODS can be used as the ETL tool with this product, but do you know SAS can be used instead of SAP BODS?

 

Thanks,

Sonal


Accepted Solutions
Solution
‎01-03-2018 09:57 PM
Respected Advisor
Posts: 4,545

Re: SAS with Guidewire

[ Edited ]

@SonalJ

The Guidewire site doesn't offer a lot of technical information but from what I've read I believe the DataHub is not meant to be accessed directly by 3rd party software. Such data would get published into a EDW and you would access it from there.

https://www.guidewire.com/sites/default/files/media/pdfs/DataHub_data_sheet_enabling_transformation_...

Capture.JPG

 

If you still want to try: SAS can interface with many data sources. You might want to contact Guidwire directly and ask them what technology they use and how Guidwire recommends to access their data.

View solution in original post


All Replies
Super User
Posts: 9,574

Re: SAS with Guidewire

You need to find out on which database platform Guidewire is implemented. Then you can either use the respective SAS/ACCESS module for direct access to the RDBMS, or unload the database tables to flatfiles and load them into SAS with data steps. Your approach will be determined mainly by how current the data warehouse needs to be.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
New Contributor
Posts: 3

Re: SAS with Guidewire

Posted in reply to KurtBremser

Thank you for the response.

 

Guidewire has their own database product called Datahub. The data processed in the Guidewire Application is stored in Datahub.

It has a standard table structure designed by Guidewire and customization is possible as per customer needs.

Currently I access the Datahub database using the SSMS.

Solution
‎01-03-2018 09:57 PM
Respected Advisor
Posts: 4,545

Re: SAS with Guidewire

[ Edited ]

@SonalJ

The Guidewire site doesn't offer a lot of technical information but from what I've read I believe the DataHub is not meant to be accessed directly by 3rd party software. Such data would get published into a EDW and you would access it from there.

https://www.guidewire.com/sites/default/files/media/pdfs/DataHub_data_sheet_enabling_transformation_...

Capture.JPG

 

If you still want to try: SAS can interface with many data sources. You might want to contact Guidwire directly and ask them what technology they use and how Guidwire recommends to access their data.

New Contributor
Posts: 3

Re: SAS with Guidewire

Thank you @Patrick and @KurtBremser.

 

The responses helped. I think Datahub->EDW->SAS would make sense. I will still contact GW to get more details. Thanks.

Respected Advisor
Posts: 4,545

Re: SAS with Guidewire

@SonalJ

Please let us know what GW tells you so we can all learn something new.

New Contributor
Posts: 3

Re: SAS with Guidewire

Posted in reply to KurtBremser

By default Guidewire uses H2 Database. Having said that, Guidewire is generally compatible with other legacy DBs 

New Contributor
Posts: 3

Re: SAS with Guidewire

Let us know if there was a response received from Guidewire. 

 

And it would be great if someone here has a Data Dictionary template for any of the Guidewire modules. 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 258 views
  • 0 likes
  • 4 in conversation