Odi - put quotation marks on the owner / tables

Oracle Business Intelligence, Oracle Warehouse Builder OWB, Oracle Discoverer, BI Publisher, XML Publisher, OLAP, Data Mining, ODI Oracle Data Integrator, etc
Post Reply
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Hello

Do you know how to do odi put double quotation marks on the owner or tables / fields?

I have an Owner called Abc-tes [/ u], and at the time of the temporary tables, it gives an error.

Select all

CREATE TABLE abc-tes.tabelax
should be

Select all

CREATE TABLE "abc-tes".tabelax
because it does not accept the less signal.

:?
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

I discovered !!!

In Topology Manager, click the physical connection schema, and there has a "Local Object Mask" field.

Before.:

Select all

%CATALOG.%SCHEMA.%OBJECT
After:

Select all

"%CATALOG".%SCHEMA.%OBJECT
(I put double quotation marks in the catalog )

Now, it generates the scripts correctly!

Select all

create table "newgraph-tst".dbo.C$_0TESTE_ODI_COMPK 
( 
	C1_NUM	INT NULL, 
	C2_FIRSTNAME	VARCHAR(20) NULL 
)
PS: All this because the head that created the sqlserver base did not think a special character could give some problem. Fortunately, Odi was prepared for that kind of thing! : -) [/i]
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

The above alter ended by generating other problems. This is because ODI generates scripts at run time, including Java.

In case, see the line below (with error)

Select all

 readTrg =  stmtTrg.executeQuery("select * from "newgraph-tst".dbo.I$_TESTE_ODI_COMPK where 1=2")    '))
The dual owner aspa above is generating error in the select above. .

Result, I requested the staff of the bases to rename the Owner to NewGraph_Tst. Then it worked: - /
Trevisolli
Moderador
Moderador
Posts: 2016
Joined: Wed, 12 Jan 2005 3:25 pm
Location: Araraquara - SP
Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Brother, bzinha?

Dude, as I am studying and starting to work with ODI (nice pacas), I would like to take a doubt, from beginner:
  • would have as, instead of changing the baseer of the base, so I understand, change the code of Knowledge Module (seems to be the IKM in this case) and Does this double quotes? [/ list]

    only one doubt. I'm thinking of reproducing in my testing environment here.

    that embrace,
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Yes, you can move the IKM!
I'vê never moved, but they're there as a base. Can be adapted as needed.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 3 guests