Billing and Revenue Management

Cloning BRM and Pipeline Environments for Development and Testing

Many times when working on multiple projects for a client, it is necessary to be able to reproduce a BRM/Pipeline environment containing customizations and test data. Multiple environments can be used … Read More »

More Posts from this Category

Data Management

Data Warehouse Design: Star Schema vs. Snowflake Schema

Star and snowflake schemas are similar at heart: a central fact table surrounded by dimension tables. The difference is in the dimensions themselves. In a star schema each logical dimension is … Read More »

More Posts from this Category »

The Intersection

Cloning BRM and Pipeline Environments for Development and Testing

Many times when working on multiple projects for a client, it is necessary to be able to reproduce a BRM/Pipeline environment containing customizations and test data. Multiple environments can be used to test different branches of code, various releases or different levels of staging. This blog series uses Linux command line tools and Oracle Data Pump to clone a BRM/Pipeline schema and BRM … Read More »

Workplace Wellness

Sitting is the new smoking of our generation. As you can imagine, we SSGers experience a lot of that sedentary lifestyle. Hey, we're technology consultants! If we aren't hunkered down at our desks and solving hard problems behind a computer screen, we're settled in an airplane seat (still behind a computer screen) on the way to see our clients. So are you surprised we made the news because we … Read More »

Data Warehouse Design: Star Schema vs. Snowflake Schema

Star and snowflake schemas are similar at heart: a central fact table surrounded by dimension tables. The difference is in the dimensions themselves. In a star schema each logical dimension is denormalized into one table, while in a snowflake, at least some of the dimensions are normalized. Star: Snowflake: A snowflake design can be slightly more efficient in terms of database space, … Read More »

Customizing BRM Credit Card Payments for Level 2 Data

By default, Oracle BRM's pin_collect utility (in conjunction with the support opcodes and data manager) does not send or retrieve Level 2 data from a payment processor. Consequently, your business may be incurring unnecessary transaction fees associated with higher data interchange rates maintained by Visa and MasterCard for their credit card payment solutions. In the second post of our series, … Read More »

Save Money with BRM Credit Card Payments

Did you know it is possible to save on transaction costs by providing Level 2 or Level 3 data to the credit card payment processor? IntroductionIn the first post of this mini-series we show how to minimize transaction costs by including Level 2 or Level 3 data in requests sent to a payment processor.We will follow this by showing how to configure the BRM credit card payment type to implement Level … Read More »