BookmarkSubscribeRSS Feed
🔒 This topic is locked. We are no longer accepting replies to this topic. Need further help? Please sign in and ask a new question.
twocanbazza
Quartz | Level 8

Hi.

Has anyone out there had any experiences extracting data from Guidewire Policy center for the use in a Data Warehouse.

I know very little about guidewire but understand it is not as easy as pulling data from the underlying table structure as guidewire is rules and event based

Any hints appreciated

Barry

16 REPLIES 16
LinusH
Tourmaline | Level 20

Sorry, not any experience. But the following quote from their web site gives a hint:

"Integration—provides a variety of integration mechanisms, including a web services API, event-based messaging, and the ability to add integration adapters at any point in the application; data can be exchanged in any format, including ACORD XML or IAA"

So if this is the access path that is available for your project, there is a concern about high data volumes and XML/service brokers.

I guess you have to do the usual steps for investigating any data source; meet up with the supplier, invstigate interfaces, and match with your user requirements.

Br

Linus

Data never sleeps
JasonBCoding
Calcite | Level 5

While we haven't had the experience extracting the policy center,  we however have extracted the tables from Claim Center of the Guidewire. Guidewire seems to like to use id/numeric value in their transaction tables, meaning you will often to look up the real value from another table to get the actual value of the id. Because of this, it could easily create up to thousand of tables in a system. Also, the underlying tables tend to be built based on its function rather than role, and this also make them to share the tables for different products easily, provided the function is the same.

The data dictionary should be helpful to understand the relationship of the tables and columns. Have you had any luck extracting the tables so far?

twocanbazza
Quartz | Level 8

Still in the inception stage of the project, so no data extracts yet....

Sounds like we are not going to the conventional ETL from the underlying tables and will an event messaging interface to get the deltas.... We'll see how it goes and will post our experiences....

Barry

JasonBCoding
Calcite | Level 5

Event messaging seems to be a preferred and standard way of getting the data these days, at least that's what I know how few different organisation are doing it. This is also the case for the the Policy Center too..

mcozz
Calcite | Level 5

Hi,

Could I ask about your experience with feeding data warehouse with data from Guidewire system? Did you chose their event-based messaging system as a way of data extraction? If yes, is it working without problems? Have you worked out alternative ways of re-extracting data from Policy Center Database in case of failure in sending some messages or such cases did not occur?

I'm facing similar problem of chosing correct approach (basically push vs. pull) and I will be grateful for any hints concerning Guidewire system.

Thanks

mcozz

twocanbazza
Quartz | Level 8

mcozz

Sorry just saw your response/questions...

I haven't got time today to respond.  Are you using Guidewire and trying to warehouse off it?

Barry

mcozz
Calcite | Level 5

Barry,

I am in the situation as described by you a year ago. My company introduces the Guidewire system and one part of the project is loading the data warehouse. Guidewire strongly recommends their messaging system instead of ETL approach to feed the staging area. As this is not typical way of doing this we weigh up the pros and cons. This is why I asked about your experience with Guidewire system (the questions are in my first post).

I look forward to hearing from you

mcozz

twocanbazza
Quartz | Level 8

Hi Mcozz,

Tried to send you a direct msg, but I didn't know how...

Do yo know how to contact me off-line from this topic, to discuss more...

Barry


mcozz
Calcite | Level 5

Hi Barry,

I clicked "follow" on your profile and I am waiting for your approval, then (I hope) it will be possible to send direct messages.

mcozz

twocanbazza
Quartz | Level 8

Have clicked

Approved Smiley Happy

TomKari
Onyx | Level 15

You mention feeding a data warehouse, which to my view implies large data volumes.

My experience with using messaging interfaces to try to pull large data volumes is that they are not designed for this, and are VERY slow. I suggest ensuring that you can meet the required volumes with your approach.

Would another alternative be to meet your analysis needs from whatever analysis resources Guidewire supplies? Let them do the heavy lifting?

Tom

mcozz
Calcite | Level 5

Thanks for replay.

Messaging interfaces in this approach are for sending messages to staging database in real-time (per transaction), so large volumes of data are spread throughout the day. The data warehouse is loaded from the staging area on daily basis with ETL tools (DI).

Has someone met similar solution for feeding data warehouse?

mcozz

Patrick
Opal | Level 21

If I understand this right then you will source your data from some tables in a staging area. How the data gets in there is from your point of view an upstream process and you don't have to worry about.

I've dealt already with "trickle feed". The main question here is: How do you make sure that the data you source from is in sync? Eg. if there are several tables with relationships how do you make sure that you don't pick up a record from one table with a related record in another table which hasn't been loaded yet?

It's a question you need to ask the guys loading your staging area. How are they controlling data integrity? There might be a load timestamp column and you might decide to only extract records loaded a certain time ago to make sure your extracts link up. You might then also maintain a control table where you protocoll what you've already extracted and what not. You might also need to validate your extracts before loading and only load records which link up.

Easiest would be if you would be given extracts as then the people loading the staging area are also responsible to provide you with correct data. After this it's standard ETL/ELT for delta load. If you have to do the extracts (the landing files): Make sure to also understand how you can identify deletes.

Maruthi
Calcite | Level 5

Hello folks, 

 

My request is a slight deviation from the discussion happening in the current. I am looking out for Guidewire Data Dictionary. It would be of great if someone can share a skeletal structure or a template of the same.  

 

Pardon me if I have posted my request in the wrong thread. 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 16 replies
  • 5708 views
  • 3 likes
  • 8 in conversation