YouTube Transcript:
BP Archiver Plus Version 2
Skip watching entire videos - get the full transcript, search for keywords, and copy with one click.
Share:
Video Transcript
Available languages:
View:
this is a demo of BPR Arch plus okay so
we have two interactive uh clients one
on the left here and one on the right
and you'll notice at the bottom here
right here this one on the left is
connect to BP archives right it's a
different system so well sort of but for
now I'll just assume it's different and
then you see on here BP prod okay so
typically in a customer environment here
you would have your day-to-day
operations where you manage sorry your
production uh environment and on the
left here you will you know this is the
archives uh system so if you have a
archiver set up what would happen is the
archiver would work in the background
right it will move data from production
to archives typically we want to keep
production as Slim as possible with data
or you're going to notice bad things
happen like uh your processes your blue
prism processes those sessions they'll
take a lot longer to complete and in a
very bad case you'll see Deadlocks and
timeouts and that's not good right so
you want to keep your data very slim
specifically the workc item data there
is a lot of iOS going on with work items
is customer data being loaded customer
data data being updated and then delete
it so there's a lot of operations there
you don't want to keep too much data or
loading data will take a very long time
right the more data it has to the
interactive client has to Channel
Through the uh longer it will take
that's why you want to offload completed
uh work you items over here to the
archive system when you set this up you
say I want to Archive anything older
than 7 days that has completed I want
you I want you blue prism archiver to
move that data over here to the archive
system so over time the archive system
will have a lot of data and over here
your production data you know it'll
always be current data only and that's a
good thing you know you'll notice when
you do your database maintenance such as
uh rebuilding of indexes you'll notice
that it's a lot quicker when you have
less data so just overall generally
extremely good idea and healthy to have
an archive system that just constantly
move this data out so now I'm going to
show you how it works under underneath
the hood so this is the presentation
layer the uh interactive client data is
either going to be here or here but not
both it's going to be in production or
archives but not both so underneath the
hood I'm going to show you the archives
database so when you install archiver
it'll walk you through how to set up a
database you'll notice over here this is
the let's assume this is the production
database so if I go to the tables tab
this should start looking familiar to
you you it has all the um the tables
that you typically would see when you
log into a blueprism database well if I
flip back over to the archives database
right here and I go to tables well
there's not a whole lot of tables what
happened there's only seven tables here
it starts to look familiar these are
your uh logging and session tables and
these are your work Q item tables if I
expand this folder here called synonyms
I'm I'm going to just expand that
here you will notice I we called this
synonym uh BPA active directory domains
what a synonym is is a uh a link it's a
linking object underneath the hood you
can you can name it whatever you want
and you can point it to whatever you
want I say that Loosely right there's
obviously some things you can't
generally speaking you can and what
we're going to name this one is BPA
active directly domains he's actually
going to the database the production
database prod even though we're in
archives we're still in archives
database but he's pointing to this
object right here vpa active directory
domains this is a table this object is a
table and um in the production database
so he's link linking this is a link we
gave that link the same
name by doing it this way I'm going to
hit okay here but let me show you where
it's actually pointing so this is
production that synonym is actually
pointing to this guy so you can do that
you can remotely refer to other objects
of other databases so that's what the
synonym do does internally here's the
beauty of archivers okay
internally the archive
just sees it as an internal table we
kind of tricked it really is a table in
production and if you look at this uh
these uh if I go to design here if you
here they are both pointing to the same
table which is the production uh
database table even though uh when I log
into the BP archives here I logged into
archives and I log into BP prod even
though I set it up as two different
connections to two different databases
they're referencing the same table by
doing so we're able to utilize
everything that production goes on in
production so if you add in a new
process in production you'll see it in
archives for example because it's the
same table right that's the beauty of
the way archives is set up it's very
easy it leverages off of existing
production tables such as your users
table so if I change my password over
here when I go over here I log in with
the same
credentials right because it's hitting
the same tables so you could have two
ic's open in parallel a controller in a
a operations room if they don't find
their data in here if they go to their
control room and they go to their Q
management and they can't find the data
here well they could go over
here and they can go to Q management
they and when they do a search for their
item right over here they do a search
then it'll show up in here if it's not
in here it's in here that's the beauty
of BPR archives the only thing that's
different is the actual data that we're
moving nothing else so you don't have to
worry about sinking process on one side
and the other nothing like that it's uh
we trick the interactive client to
utilize production tables when it think
is its own by doing so we're able to
have a clean split of the the data
either it's in production here or
archives everything else is the same
when you're a controller you can just
have two of these open if you want if
you can't find here just open a
connection and find it here now that we
know that where the data comes from and
where it goes what's actually doing the
work so here in my archives databas B
you here are the tables if I expand this
programability like so you'll notice
these three stored procedures right here
that is the process that actually moving
the data from prod to archives it runs
in the background and typically you
would set up a database job to run at
certain intervals to move that data and
that's how the data gets populated into archives
Click on any text or timestamp to jump to that moment in the video
Share:
Most transcripts ready in under 5 seconds
One-Click Copy125+ LanguagesSearch ContentJump to Timestamps
Paste YouTube URL
Enter any YouTube video link to get the full transcript
Transcript Extraction Form
Most transcripts ready in under 5 seconds
Get Our Chrome Extension
Get transcripts instantly without leaving YouTube. Install our Chrome extension for one-click access to any video's transcript directly on the watch page.
Works with YouTube, Coursera, Udemy and more educational platforms
Get Instant Transcripts: Just Edit the Domain in Your Address Bar!
YouTube
←
→
↻
https://www.youtube.com/watch?v=UF8uR6Z6KLc
YoutubeToText
←
→
↻
https://youtubetotext.net/watch?v=UF8uR6Z6KLc