Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP.NET and PowerPivot for Excel

cromaApr 14 2015 — edited Apr 14 2015

Hi All, very new to Oracle and Oracle Community, I hope I'm asking a legitimate question in the right place, if not please tell me.

Scenario:

Windows 7 x64 with MS Office ProPlus 2013 x86

Hoping to be able to connect to a remote Oracle DB from a PowerPivot connection, without installing Oracle Client and without configuring TNSNAMES.

In PP going through 'Get External Data' -> 'From other sources' -> 'Oracle' and selecting 'Advanced' properties I've seen in 'Providers' combo the choice "Oracle Data Provider for .NET".

Therefore I downloaded ODP.NET_Managed121020 folder and performed xcopy/deployment running install_odpm_bat [platform:both] [machine wide:true].

After that, choosing 'Oracle Data Provider for .NET' in PP/Excel I still see the message "Unable to find the requested .Net Framework Provider. It may no be installed'.

The Question: is it possible what I'm trying to achieve? Anyone knows to which Oracle .NET provider PP refers to?

More Info:

I successfully developed an alternative VSTO solution with Excel connecting through Oracle.ManagedDataAccess.dll (auto deployed with ClickOnce) from inside the workbook code.

But that way I'm limited cause I can only fill Excel Tables with data from Oracle and link them in PP.

I'd like to avoid that and creating the Data Model in PowerPivot directly.

Thanks in advance for any info.

Comments

Jose Cruz

Excellent Article!!!

user12184782

With all due respect, Lambda expression is like a Goto statement:

Cute workaround/semi-patch for poor planning.

Having one or two Lambda expressions in piece of code might sound reasonable, at first glance. Same is with goto-statements. And if the code is yours, you are pretty sure what is going on.

In case there are a lot of Lambda expressions, number of line-codes is decreased, by having more statements in one single line. This might lead to decreased readability and maintainability of code - which is quite the opposite of initial idea.

(Concerning Lambda expression, I'm starting to have a feeling that Java is being polluted by bad ideas, recycled from C#.)

C used to be famous for its poor/chaotic readability (multiple statements in one line, etc). If we want to adopt mono-line coding style (multiple statements in one line), then we might go back one step (I don't think this can be named 'progress').

I read the article, and I respect the effort and the idea. However, I'm not convinced, that Lambda expression is good. Proper architectural planning and modeling should/must be made, in order to avoid any necessity for Lambda expression.

PraveenM90

wah, Excellent Article is i felt lambda expressions too hard in beginning after few work am getting its OK but not clear. after reading this article Completely clear crystal clear sharp explanation

Lambda expressions using is good for one or two instances yes its too worse when enter into maintenance but some times it will make so much impotence suppose if we take swing components or Android development event handling those are very clearly handled by IDE like studio its good idea but at the same time also....

Thanks for this Article..

Praveen :-)

user13279423

seems that the formatting in the code is incorrect such as: Listing 9. Java clienti. The code is just displayed on a single line which is mostly unreadable.

Mohan Basavarajappa

seems that the formatting in the code is incorrect such as: Listing 9. Java clienti. The code is just displayed on a single line which is mostly unreadable.

hi

thanks for pointing out. will check with moderator whether we can take care of formatting so that it's readable.

Mohan Basavarajappa

With all due respect, Lambda expression is like a Goto statement:

Cute workaround/semi-patch for poor planning.

Having one or two Lambda expressions in piece of code might sound reasonable, at first glance. Same is with goto-statements. And if the code is yours, you are pretty sure what is going on.

In case there are a lot of Lambda expressions, number of line-codes is decreased, by having more statements in one single line. This might lead to decreased readability and maintainability of code - which is quite the opposite of initial idea.

(Concerning Lambda expression, I'm starting to have a feeling that Java is being polluted by bad ideas, recycled from C#.)

C used to be famous for its poor/chaotic readability (multiple statements in one line, etc). If we want to adopt mono-line coding style (multiple statements in one line), then we might go back one step (I don't think this can be named 'progress').

I read the article, and I respect the effort and the idea. However, I'm not convinced, that Lambda expression is good. Proper architectural planning and modeling should/must be made, in order to avoid any necessity for Lambda expression.

hi

appreciate your point of view. functional programming idioms are there for quite sometime. java was late in joining the party and took time for incorporating it as language feature. there were lot of discussions on this whether or not to include.

This article is to understand the nuances, appreciate good aspects and avoid bad patterns. Just because a language feature is available, force-fitting it to all context and usage will surely lead of bad patterns what you've highlighted. Agree to your point that planning and architectural aspects have to be in-place and just language features alone can't solve all the problem.

Usage of any feature should be based on fitment rather than compulsion. This might not be good for all cases or scenario's but might serve well for specific cases

We are in the process of fixing the code format. Unfortunately, we need more time. Yolande

jwenting

hi

thanks for pointing out. will check with moderator whether we can take care of formatting so that it's readable.

The problem is that the ( i ) is being rendered by the html generator as a symbol. Putting spaces around the "i" should hopefully prevent that.

jwenting

With all due respect, Lambda expression is like a Goto statement:

Cute workaround/semi-patch for poor planning.

Having one or two Lambda expressions in piece of code might sound reasonable, at first glance. Same is with goto-statements. And if the code is yours, you are pretty sure what is going on.

In case there are a lot of Lambda expressions, number of line-codes is decreased, by having more statements in one single line. This might lead to decreased readability and maintainability of code - which is quite the opposite of initial idea.

(Concerning Lambda expression, I'm starting to have a feeling that Java is being polluted by bad ideas, recycled from C#.)

C used to be famous for its poor/chaotic readability (multiple statements in one line, etc). If we want to adopt mono-line coding style (multiple statements in one line), then we might go back one step (I don't think this can be named 'progress').

I read the article, and I respect the effort and the idea. However, I'm not convinced, that Lambda expression is good. Proper architectural planning and modeling should/must be made, in order to avoid any necessity for Lambda expression.

Yes, I have the same apprehensions about lambdas in Java. While a nice idea in some scenarios (like replacing anonymous inner classes) overall it feels wrong, a way for overly smart people to show how smart they are by writing highly obfuscated code, exactly the thing that Java was originally intended to make harder (in part by forcing a somewhat more verbose way of writing code than e.g. C does).

Mohan Basavarajappa

The problem is that the ( i ) is being rendered by the html generator as a symbol. Putting spaces around the "i" should hopefully prevent that.

it happened due to some migration which oracle did few months back. this site went through some migration stuff and most of content had these issues is what i understand from community manager. hope they fix it!

Kashif Sohail

I was using Lambda Expressions in C#, while I switched to java, and feeling very happy to see it in java too.

unknown-3341152

Lambda is great, but Java is still cumbersome. I made a library to make lambda more useful:

http://wp.me/p7lGfP-1u

Have a look!

1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 12 2015
Added on Apr 14 2015
0 comments
881 views