This content has been marked as final. Show 9 replies
got to dac-setup-properties and set the server name if it is local server then add localhost
and test all the physical data sources via cling test option in child menu
please mark helpful,if found useful
Edited by: Rupesh Shelar on Apr 2, 2013 2:30 AM
Hi , This is DAC11g version, we will not have column or row like 'Server name'.
Here we have seperate set up for DAC server details that i have done successfully.
u can mark as helpful/correct to close the thread
Issue not at resolved
what u have configured at
dac-setup-properties-DAC Server Host.If it is local then add localhost
have u tested database connections?
where u rgetting error while starting the server or bulding the plan
ETL Management configuration is based on ODBC. oci or thin client may not work.
Try to use odbc and do the configuration.
I dont have oracle client installed, i have sql server on windows server and oracle database on linux server.
Can i connect / create ODBC with SQLServer (sqlserver - oracle database).
If so how?
Check this http://msdn.microsoft.com/en-us/library/cc879308(v=sql.105).aspx
or google it.
Edited by: Srini VEERAVALLI on Apr 2, 2013 7:45 AM
Just in case you might need this at config.bat file since you are using SQL Server 2008
check it once
Edited by: Srini VEERAVALLI on Apr 2, 2013 8:09 AM
Any updates on this?
Edited by: Srini VEERAVALLI on Apr 14, 2013 7:56 AM
just copy ojdbc14.jar file from the installation and paste it library file of the installation close confi. window reopen it and choose thin driver as 'thin'
nd test it
mark as correct, if answered
Edited by: Rupesh Shelar on Apr 2, 2013 6:00 AM