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