Unanswered

Oracle Connector table limit

(0) Share

Report

Posted on by imabigdog

I'm want to use powerapps to connect to Oracle 11g tables. But seem the Oracle connector is limited to the first 150 tables (alphabetically) . Is there any way to:
1. Up the limit?

2. Specify the 150 tables instead of it just getting the first 150?

Thanks All

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (0)

ConstructionBI 6 on at

Like (0)

Report
Copy link

Link copied!

In my case I did the following:

1. Created a new flow from blank template
2. Setup a recurring schedule (but could be setup with different trigger)
3. added an action of type 'Oracle Database - Get Rows'
4. If i remember correctly, it then asks you for your db connection info and credentials
5. Clicked the 'Table name' dropdown and scrolled to the bottom and selected 'Enter custom value'

After this, I tested the flow run and it successfully pulled rows. But i ran into the 512 row limit after this step.

Was this reply helpful? Yes No
benatmic 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you ConstructionBI for your help.

When you write your using Flow, do you first create the connection via the main menu 'Connections', and choose for Oracle Database the table or view you want ?

Was this reply helpful? Yes No
ConstructionBI 6 on at

Like (0)

Report
Copy link

Link copied!

I am not actually making the Oracle connection directly from PowerApps, so not sure what the user experience there is like. I am using Flow directly. I was assuming the connector would have the same experience between PowerApps and Flow, but that may not be the case.

Maybe try 'TEST.PART_TAB' (without the [])?

And i didn't try and other tables first.

Was this reply helpful? Yes No
benatmic 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer, I'm a bit disappointed by those connexion issues.

I'm using PowerApps on line, not in Visual Studio :
is it the reason why I don't see 'enter custom value' choice on the bottom ?

When I make my formular, I insert an object 'Data table'
which I connect to the Oracle connector, selecting a whatever table (one of the firsts table of my database).
Then for this Data table inserted on my window, I select 'Advanced' properties.
For 'Data Items', I change the value for '[TEST].[PART_TAB]'.
==> It doesn't worked : I have an error 'Invalid name'

Do you try also connexions on other tables than the firsts given in the list ?

Was this reply helpful? Yes No
ConstructionBI 6 on at

Like (0)

Report
Copy link

Link copied!

Have you tried selecting the 'enter custom value' choice at the bottom and manually entering the view name (the format would be namespace.view)? I was able to connect to views doing this. But then I get stuck because the connector only returns 512 rows and setting the 'maximum get count' doesn't seem to work.

Was this reply helpful? Yes No
benatmic 6 on at

Like (0)

Report
Copy link

Link copied!

Hello,
this limit of the 150 tables in Oracle still exists on september 2017 and we also don't have access to the views.
This is a major issue for my company. Due to that limit we will not use PowerApps.

Was this reply helpful? Yes No
v-monli-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @imabigdog,

It seems that this is the current limitaion in flow. Consider to post an idea to see if this could be considered into future release:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,

Mona Li

Was this reply helpful? Yes No