Data Extraction for Sub-sets of Accounts.

Migrating sets of data to support testing has been an issue on a number of projects that I have been involved in, with most sites requiring a method of transferring subsets of accounts from Production to other CC&B environments.

The ConfigLab framework supports the ability to perform Account Sync actions, but these have a couple of limitations:

  1. the transfer is expected to be performed via ConfigLab database links, so both CC&B instances must be visible to each other via Database links.
  2. whilst the process is quick for small amounts of accounts (< 100), performance degrades very quickly if large amounts of accounts are scheduled to be processed.
  3. The changes required to ensure that the resulting data does not contain any customer-specific identifiers can be onerous (i.e. difficulty in producing anonymous data).

As a result I have been working on a set of extract tools which will generate SQL insert statements, which can then be zipped and transferred to a separate CC&B instance, to be used when populating the target database (i.e. offsite development, system testing, etc).

This should enable mass transfers, with the only limitation being the resulting size of the resulting SQL script, and your ability to transfer it to the target database.

Drop me a quick comment if you would like more details..

Comments:

Hi Stuart

I'm really intersting in your extract tools. Is it possible to send it by email?

Best Regards
Nicolas

Posted by Nicolas C. on September 25, 2012 at 07:11 AM EST #

Hi Stu,

I'm interested to know more details with regards to how you constructed the query for the extract tool.

Cheers!
-Topeng

Posted by Topeng on December 12, 2012 at 10:24 AM EST #

Hello Stu,
I too am interested in more information related to your extract tools.
Thanks,
Larry

Posted by guest on February 10, 2013 at 02:36 AM EST #

Hello
I came across some similar PL/SQL in the past and have used it successfully. I was wondering if your solution would be similar, or perhaps easier/more efficient.

Thanks
David

Posted by David on August 17, 2013 at 04:24 AM EST #

Hello Stu,

I am also interested in more details regarding your extract tools.

Posted by guest on April 08, 2014 at 01:52 AM EST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Stuart Ramage

I am a Consulting Technical Manager for Oracle Corporation, and a member of the OU Black Belt Team, based in Hobart Tasmania.
I have worked in the Utility arena since 1999 on the Oracle UGBU product line, in a variety of roles including Conversion, Technical and Functional Architect.

Contact me on:

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today