Well, a couple of months ago, I made Navajo County’s Parcel Search start getting data from the new Assessor’s database. They have moved from the Arizona Department of Revenue’s CCIS to Colorado Customware Inc’s RealWare product, affectionately known as CCI. All things said and done, it wasn’t too bad of a process.
Obstacle 1
Where is the data located?
With a lot of help from Mohave County’s Systems & Database Admin, Gary Waters, this step wasn’t too bad. I realized what I needed was the DataMart schema… but I didn’t quite understand how I was supposed to populate it. Gary kept telling me about this job they have that populates it nightly, but I couldn’t even find (in Oracle Enterprise) where Oracle keeps it’s jobs. I eventually found a query that would list them for me, but we had no such job.
The next day, or thereabouts, Jeff, one of the other Navajo County programmers, noted that he had found a DataMart application and had populated the schema. As he was explaining how to install it (it’s included in the advanced RealWare install), I realized I had seen it there when I was installing RealWare on my machine, duh. Oh well, all in a day’s work, I guess.
With the help of the SQL scripts that Gary sent along, I started to piece together how the data was arranged in the database. On to… (Continue reading…)
Sphere: Related Content