en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Adriano  
#1 Posted : Tuesday, October 8, 2019 6:35:29 PM(UTC)
Adriano
Rank: Newbie

Groups: extranet\Forum
Joined: 10/8/2019(UTC)
Posts: 1

Hello,

I'm new on Targit universe and, naturally, I'm having problems to access Oracle database. First of all, let me explain what I already did.


1 - I have installed Targit Decision Suite on a specific server, 10.11.1.67, for example.

2 - My Oracle database is in another server, 10.11.1.69, for example.

3 - Now, I'm trying to create an InMemory database based on my Oracle database.

4 - After I set Data Source informations to point to Oracle database, I built my ETL using Data Source, Script and Save options.

5 - Targit InMemory ETL Studio generated the following code:
LOAD ASSEMBLY 'Oracle.ManagedDataAccess.dll'
DATASOURCE [Oracle] = DOTNET CONNECTION 'Oracle.ManagedDataAccess.Client.OracleConnection' 'data source=(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.1.69)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = oratst.int)));User Id = UCGDES; Password = ******'
DECLARE @teste AS STRING
SET @teste = 'SELECT * FROM CGS_MOVIMENTO'
IMPORT [MOVIMENTO] = [Oracle].{@@query}
SAVE

6 - When I RUN it, it gave me the following output message:

----- Build started at 12:04:35.267 -----

----- Build: 1 succeeded, 0 failed, 0 skipped at 12:04:35.272 -----

========== Publish started: Project: Adriano ==========

12:04:35.280 Publishing files

12:04:35.280 C:\Users\adriano.cerino\Documents\Adriano\Adriano.impd

12:04:36.291 Start time: 12:04:35 PM    End time: 12:04:36 PM    Total: 1 second

========== Publish: 1 succeeded, 0 failed, 0 skipped ==========

7 - My tnsnames file is as we see below:
ORATST.INT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.1.69)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oratst)
)
)

8 - The Oracle database connection works with SQLPLUS, SQLDBX and Oracle Server Developer




Well, I expected that the InMemory would read the Oracle database and could generate a .targitdb file. But it didn't happen.

I would appreciate if someone could give some help. If more information is needed, please, feel free to ask me.

Thanks in advance,

Adriano Lima
Ole  
#2 Posted : Tuesday, October 22, 2019 5:38:38 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 503

Hi Adriano,

The log, at "12:04:35.280 Publishing files" seems to indicate that nothing is being published to the Scheduler Service.

So, your problem is most likely linked to your publishing options.

Not sure if it is related to your problem, but I have seen cases where the TARGIT InMemory Scheduler Service wasn't able to run with just the Local system account - I needed to use a named account for it to run.

BR / Ole

Edited by user Tuesday, October 22, 2019 5:39:32 AM(UTC)  | Reason: Not specified

Ole Dyring
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok