![informatica sql server connection string informatica sql server connection string](https://i.stack.imgur.com/CAmlz.png)
Severity Timestamp Node Thread Message Code MessageĮRROR 08:01:03 node01 READER_3_1_1 RR_4036 Error connecting to database [ĭie von der Anmeldung angeforderte Cognos-Datenbank kann nicht geöffnet werden. P:S using an ODBC as I did in the source profile and as first attempt gave me the error:
![informatica sql server connection string informatica sql server connection string](https://datadominance.files.wordpress.com/2015/10/2015-10-13_16-49-17.png)
Or as second option use the one created at developer? There is a way to use the connection create at the administration pannel into the PowerCenter Workflow?
#Informatica sql server connection string driver#
JDBC Driver Class Name : Ĭonnection String: jdbc:sqlserver4://myslqserverinstance:1433 SelectMethod=cursor databaseName=DBName , where it is clear the only work around is to use a Java transformation as suggested from the support,but is limited to mapping(where in case of teh SQL Server I did not have problem connecting to the source via ODBC): JDBC connection in Informatica Powercenter Moreover I did have put the jdbc driver into the appropiate folder(D:\Informatica\10.1.0\server\bin\javalib).Īfter a few search I was able to find only this post:
![informatica sql server connection string informatica sql server connection string](https://miro.medium.com/max/913/1*AEII782Nur42ThUtLLnxJw.jpeg)
Moreover I already set a Native MSSQL server with JDBC string connection configured(tested and working) from the Informatica Developer that can be seen into Informatica Administration pannel(as for all of them as stated into Informatica online help). Unfortunately I am binded to such and cannot develop the project into the Informatica Developer. That would not be a problem if I could use the Informatica Developer, where any kind of connection can be configured,but from there I am getting that I miss the driver(I guess I have to add it locally, though I added at the server level where Informatica is installed) but unfortunately I am not able to setting/create such connection in the PowerCenter workflow. I am working in a project where I need to integrate data coming from Oracle DB instance and SQL Server.Īll was fine till I runned the workflow and I got the ORA-009242 error that told me that the schema(on the SQL Server) was not found.Īfter few search I realized that though I was able to get the same schema(actually a single table) in the Source Analyzer with a ODBC connection, for getting the data I need to use a JDBC.