Brian Dandeneau's Professional Profile

Badges

User Activity

Almost 4 years ago

Answered a question: Looking for advice on how to invoke a select script through ODI?

I know I'm late to the party but here are my comments to this I would ask what version of ODI are you running, but for the most part it doesn't matter. I will say that since you are saying Mapping which is new terminology to 12c or higher. Also remember that ODI runs best…

Over 4 years ago

Answered a question: What are the biggest challenges in master data management implementation?

One of the best things that you can do is identify the stakeholders for Master Data Management. Once that group is identified you have that group assign a leads to be on the governance committee. Assign one person on this committee to be the overall lead so there is one…

Over 5 years ago

Contributed a review of Talend Data Management Platform: You can create a separate file for your business users to review

Over 5 years ago

Commented on I have used it to improve run-times of many corporations' overall integration run-times.

Alan Yves. Thanks for the comment. I would agree that definitely ODI can capture simple things like missing columns or the fact that you can create custom error handling. What I was referring to is out-of-the-box error handling. If you were to hook source file to a target…

About 6 years ago

Commented on Besides loading data, we do most of our transformations in it. However, the stability of the software could be improved.

Check the java heap size in the ODI params file to keep it from failing To the issue: You should be able to set the status in the operator to success. Without seeing what is happening that’s all I can offer. I would be happy to setup a quick session to dig in. I offer one…

About 6 years ago

Commented on In addition to the ETL challenges, it allows us to do DBA activitities, scripting and many other tasks.

Thanks for the review and keep them coming I like what you put in here for improvements. However, don't hold your breath for Oracle Cloud integration. Most Oracle ETL/ELT tools don't have direct cloud integration yet and its not on the roadmap for a few years. V/r, Brian…

About 6 years ago

Commented on A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened. The solution can be deployed into the cloud through Data Factory

First Great review and thanks for posting. There are a few things you can do to lessen the crippling effect of a change to the source. Use variables to loosen the grip the source has, making it more dynamic. I would agree that unless you have been doing this for years…

Over 6 years ago

Commented on Besides loading data, we do most of our transformations in it. However, the stability of the software could be improved.

What portion of ODI crashes? This sounds like an infrastructure issue rather then a tool issue.

Over 6 years ago

Answered a question: Which is better, Informatica PowerCenter or SSIS?

Would have to ask the additional question of what are we trying to do? IPC is much better are larger implementations as SSIS is much better for smaller scale operations because of speed of development and price However, ODI is better than both of these tools. Even if its…

About 7 years ago

Commented on It allows us to create scripts and share them across multiple data load processes.

1. There is a as of date in the properties. The second recommendation of using the space ODI provides to document when object have been updated. There are a few other ways to make sure that you track changes. You can even compare versions 2. You are right. Project level…

About 7 years ago

Answered a question: Difference between informatica and SAP

Can you be more specific on what you are trying to accomplish?

About 7 years ago

Commented on It allows us to create scripts and share them across multiple data load processes.

All my response can be used for any version of ODI You can create users with multiple levels of access. Security can be wide open or very granular. You can use versioning and even create reports from the repository to have a full audit. You should have one master…

Over 7 years ago

Answered a question: Test Cases for MDM Implementation

Seems to not be working. Lets do this. https://www.facebook.com/appliedgovernance/ you can send me a message through my company's facebook page.

Over 7 years ago

Answered a question: Test Cases for MDM Implementation

under my profile there is a messages section.

Over 7 years ago

Answered a question: Test Cases for MDM Implementation

Sent you a private message

Over 7 years ago

Answered a question: What is the best GUI tool for development and management of a PostgreSQL database?

Will you be on windows or mac computer?

About 8 years ago

Answered a question: When evaluating Datacenter Virtualization, what aspect do you think is the most important to look for?

CPU and RAM is where you want to consider first when evaluating DataCenter Virtualization. Once you figure that out you can start looking at other things like Storage and Networking. Without the foundation of good CPU and RAM there would be no point in looking at anything…

About 8 years ago

Commented on It was a easily adaptable to our group. The scalability needs some improvement.

I think it is a game changer of they can bump up the Scalability. On if it is feasible or not, anything can happen. I have seen other ETL tools totally revamp their solutions and become leaders in the space.

About 8 years ago

Commented on It was a easily adaptable to our group. The scalability needs some improvement.

Scalability is still lacking a bit. If you are looking to run Millions of records in seconds this isn't the tool for the job. If you are looking to run a few hundred thousand in a min then this will work.

Over 8 years ago

Commented on The features that we have applied to our project have helped to reduce manual effort and increase our scalability.

What is your favorite Valuable Feature? I personally like Reusable Mappings and Knowledge Module (KM) Customization.

Over 8 years ago

Contributed a review of Oracle Data Relationship Management: All your hierarchy/metadata information can be accessed and maintained in one central location.

Over 8 years ago

Contributed a review of Oracle Data Relationship Management: It provides a central place to maintain hierarchies that are pushed to multiple applications.

Over 8 years ago

Commented on It handles metadata management efficiently and exports data loads from our ERP system to our finance data warehouse.

Great review. I agree that it can streamline the Metadata loading process for EPM applications. Especially if you have DRM installed you can automate the front to end process just by kicking off a few batch scripts. You just have to make sure you have the licensing to do it.

Over 8 years ago

Answered a question: What is your favorite Feature of ODI 12c? (Compared to 10g or 11g)

I'm a long time user of ODI and specifically ODI12c. If that makes me a addict; then sign me up for the meeting. I love the reusable mapping but the best part of this 12c is that its now Flow based. I would also have to agree with Michael Rainey on all the points that he…

Over 8 years ago

Asked a question: What is your favorite Feature of ODI 12c? (Compared to 10g or 11g)

Over 8 years ago

Commented on Heterogeneous technologies can be integrated with ODI, including the latest web services.

This is a great way of describing ODI. Thanks for putting this on ITCentralStation and getting the word out about ODI.

Over 8 years ago

Commented on It allows us to create scripts and share them across multiple data load processes.

What are your thoughts on ODI 12c? Did you think that the GUI improved? Do you think that its more in line with the other ETL tools out there?

Over 8 years ago

Commented on I just have to configure the knowledge module to perform data extractions from multiple sources. I think that job scheduling can be improved.

This is great thanks for posting. Have you completed this in ODI12c? It would be interesting to see how the approach changes because of the differences in the versions.

Over 8 years ago

Answered a question: A recent review wrote that PowerCenter has room for improvement. Agree or Disagree?

WIth Cloud implementations there are plenty of analytics that you can reference when moving data using ETL tools. Even outside of the Cloud space I think that there are plenty of options as long as you are on Oracle Products to do this type of analytics. But really what it…

Over 8 years ago

Contributed a review of SSIS: It was a easily adaptable to our group. The scalability needs some improvement.

Over 8 years ago

Commented on The Knowledge Module is the heart of this solution. If you have nicely written Knowledge Modules, then you will not have any performance issues.

This is a great review. Speaks well to the purpose, flexibility, and overall strength of ODI.

Over 8 years ago

Commented on I have used it to improve run-times of many corporations' overall integration run-times.

Let me know if you have any questions.

Over 8 years ago

Answered a question: Experiences with Oracle GoldenGate vs. Oracle Data Integrator?

Both are good products. Really depends on what you want to do. If you are looking to run a product that can run something like a brokerage project, with little configuration, then you should go with GoldenGate. If you are looking to run daily operations for Integration then…

Over 8 years ago

Answered a question: When evaluating Data Integration, what aspect do you think is the most important to look for?

When evaluating data integration, think about versioning and audibility. Other ETL/ELT tools preach it, however ODI lives and breaths it. Also, look at reusability. 12c especially has lots of cool reusable parts that will make development easy and quick. Security should…

Over 8 years ago

Contributed a review of Oracle Data Integrator (ODI): I have used it to improve run-times of many corporations' overall integration run-times.

Projects

Over 8 years ago

Created Data Flows For Point of Sales Reporting

Created Data Flows For Point of Sales Reporting from iTunes

Over 8 years ago

Governance

Using Data Relationship Governance (DRG) we were able to create workflows that could be used by the business to manage the hierarchy information in Data Relationship Management. This was one of the first 11.1.2.4 implementations of DRG, so we had to work with the development…

Over 7 years ago

DRM to Classic HFM, Planning, and Essbase

Over 6 years ago

ODI 11g Training

Over 6 years ago

Data Warehousing

Over 5 years ago

Managed a project to implement DRM

Managed a project to implement DRM/DRG. Implemented DRM/DRG for multiple business group across the clients corporation. Being an international business many conversations, negotiations, and compromises needed to be lead.

Over 4 years ago

Boston Scientific DRG implementation

Boston Scientific DRG implementation I have done multiple DRM projects for Boston Scientific and we had always talked about doing DRG to put a governance process in place. They had a governance spreadsheet but it was more work then really it needed to be. We at a high level…

Reviews

Over 5 years ago

Talend Data Management Platform

You can create a separate file for your business users to review

Over 8 years ago

Oracle Data Relationship Management

All your hierarchy/metadata information can be accessed and maintained in one central location.

Over 8 years ago

Oracle Data Relationship Management

It provides a central place to maintain hierarchies that are pushed to multiple applications.

Over 8 years ago

SSIS

It was a easily adaptable to our group. The scalability needs some improvement.

Over 8 years ago

Oracle Data Integrator (ODI)

I have used it to improve run-times of many corporations' overall integration run-times.

Questions

Answers

Almost 4 years ago

Data Integration

Looking for advice on how to invoke a select script through ODI?

Over 4 years ago

Master Data Management (MDM) Software

What are the biggest challenges in master data management implementation?

Over 6 years ago

Data Integration

Which is better, Informatica PowerCenter or SSIS?

About 7 years ago

Data Virtualization

Difference between informatica and SAP

Over 7 years ago

Master Data Management (MDM) Software

Test Cases for MDM Implementation

Over 7 years ago

Master Data Management (MDM) Software

Test Cases for MDM Implementation

Over 7 years ago

Master Data Management (MDM) Software

Test Cases for MDM Implementation

Over 7 years ago

Database Development and Management

What is the best GUI tool for development and management of a PostgreSQL database?

About 8 years ago

Data Virtualization

When evaluating Datacenter Virtualization, what aspect do you think is the most important to look for?

Over 8 years ago

Data Integration

What is your favorite Feature of ODI 12c? (Compared to 10g or 11g)

Over 8 years ago

Data Integration

A recent review wrote that PowerCenter has room for improvement. Agree or Disagree?

Over 8 years ago

Data Integration

Experiences with Oracle GoldenGate vs. Oracle Data Integrator?

Over 8 years ago

Data Integration

When evaluating Data Integration, what aspect do you think is the most important to look for?

Comments

Over 5 years ago

Data Integration

I have used it to improve run-times of many corporations' overall integration run-times.

About 6 years ago

Data Integration

Besides loading data, we do most of our transformations in it. However, the stability of the software could be improved.

About 6 years ago

Data Integration

In addition to the ETL challenges, it allows us to do DBA activitities, scripting and many other tasks.

About 6 years ago

Data Integration

A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened. The solution can be deployed into the cloud through Data Factory

Over 6 years ago

Data Integration

Besides loading data, we do most of our transformations in it. However, the stability of the software could be improved.

About 7 years ago

Data Integration

It allows us to create scripts and share them across multiple data load processes.

About 7 years ago

Data Integration

It allows us to create scripts and share them across multiple data load processes.

About 8 years ago

Data Integration

It was a easily adaptable to our group. The scalability needs some improvement.

About 8 years ago

Data Integration

It was a easily adaptable to our group. The scalability needs some improvement.

Over 8 years ago

Data Integration

The features that we have applied to our project have helped to reduce manual effort and increase our scalability.

Over 8 years ago

Data Integration

It handles metadata management efficiently and exports data loads from our ERP system to our finance data warehouse.

Over 8 years ago

Data Integration

Heterogeneous technologies can be integrated with ODI, including the latest web services.

Over 8 years ago

Data Integration

It allows us to create scripts and share them across multiple data load processes.

Over 8 years ago

Data Integration

I just have to configure the knowledge module to perform data extractions from multiple sources. I think that job scheduling can be improved.

Over 8 years ago

Data Integration

The Knowledge Module is the heart of this solution. If you have nicely written Knowledge Modules, then you will not have any performance issues.

Over 8 years ago

Data Integration

I have used it to improve run-times of many corporations' overall integration run-times.

About me

Over 8 years experience as project manager
Over 10 years experience with database analysis and data mining
Over 8 years of PL/SQL, HTML, and Java Scripting
Over 6 years experience with Oracle, DRM, Oracle Data Integrator and other ETL tools
Over 3 years experience with using ESSBASE applications for data mining

Interesting Projects and Accomplishments

Over 8 years ago

Created Data Flows For Point of Sales Reporting

Over 8 years ago

Governance

Over 7 years ago

DRM to Classic HFM, Planning, and Essbase

Over 6 years ago

ODI 11g Training

Over 6 years ago

Data Warehousing

Over 5 years ago

Managed a project to implement DRM

Over 4 years ago

Boston Scientific DRG implementation