If your database is at your place of work, a copy of tsanames.ora provided by the DB admin or whomever.You have a basic understanding of writing SQL commands.You have at least a basic understanding of C# and have written code in it or some other language such as C++ or Java.In order to properly use the information contained in this article, I am going to assume the following: The idea behind this article was prompted because I found only one article that deals with C# and Oracle on this site (which is unrelated to my needs), and I haven't been able to find any articles anywhere else on the internet regarding this specific topic and platform. If you have questions, visit TechCommunity.This is actually my first CodeProject article and my first attempt at writing C# code, so if I have made any mistakes along the way, please feel free to comment.In the Properties pane, set the OracleHome or OracleHome64 property with the full path to the Oracle home directory. To set the OracleHome and OracleHome64 properties:įrom the Connection Manager area, right-click the Oracle connection manager you are working with and select Properties. (Optional)Ĭustom properties are not listed in Oracle Connection Manager Editor. OracleHome64: Specify 64-bit Oracle Home name or folder to be used by the connector when running in 64-bit mode. OracleHome: Specify 32-bit Oracle Home name or folder to be used by the connector. There are following custom connection manager properties in the Oracle connection manager:
SERVER= USERNAME= PWD= WINAUTH=0 Custom properties If you wanna specify ConnectionString directly, here is the sample with Oracle Authentication: Password: Type the Oracle database password for the user entered in the user name field. User name: Type the user name used to connect to the Oracle database. If you use this authentication, enter your Oracle credentials as follows:
Use Oracle Authentication: Select this to use Oracle database authentication. Use Windows Authentication: Select this to use Windows authentication. The connect descriptor name defined in the tnsnames.ora file that located in the admin folder of the Oracle client.ĮzConnect format: hostįor more information, see the Oracle documentation. Input the name of the Oracle database you work with.
The default name is Oracle Connection Manager. Use the Oracle Connection Manager Editor dialog box to add a connection to an Oracle data source.Įnter information about the Oracle connection. Oracle Connection Manager configuration changes will be resolved by Integration Services at runtime. Configuring the Oracle Connection Manager The ConnectionManagerType property for the Oracle Connection Manager is set to ORACLE. Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data FactoryĪn Oracle Connection Manager is used to enable a package to extract data from Oracle Databases and load data into Oracle Databases.
0 kommentar(er)
