The package is ready to be imported into SQL Server Management Studio. If it the package is not working, look up the section “frequents errors” to try to solve your problem. If the package is working, you should see this: The package can be tested by clicking on the green arrow in the toolbar: …or in a new table with the same structure than the source table: You have two solutions to import data from Oracle: You can either import the data into an existing table or view… Create a new connection such as “SQL Server Native Client 10.0”, enter the name of the server, choose the authentication mode and the database. Click Ok.ĭouble click on the SQL Server destination. Choose the table or view to be transferred to SQL server. If the test connection is successfull, click Ok. Otherwise, use an OLE DB Destination.ĭouble click on the Oracle Source to configure it.Įnter the name of the connection and the following information: TNS service name and Oracle account. Set up an Oracle Source and a SQL Server Destination if SSIS is on the same server than Database Engine. Click OK and Attunity components are availables in the toolbox. Find the Oracle Source, Oracle Destination, or both of them in the list and select the check box for the components you want to add to the toolbox.Ĥ. In the Toolbox, right-click on either Data Flow destinations or Data Flow Sources and select Choose items.Ģ. If these components are not available, do the following to add them.ġ. In the new package, click on the Data Flow tab and create a new one.Īfter installing the Oracle Connector, the Oracle source and destination should be available in the toolbox area of BIDS. Now, you can create a new Integration Services project with Microsoft Visual Studio or Business Intelligence Development Studio (BIDS). To finish the installation, SQL Server Integration Services service must be restarted. Launch the executable and follow the instructions, set the installation path and confirm the installation. The connector can be downloaded at this address:
The connector has to be installed on the same server than SSIS. You will need Microsoft Visual Studio or Business Intelligence Development Studio (BIDS) from SQL Server 2008, connector is not compatible with SQL 2005.Īn Oracle Client has to be installed and you have to define a TNS Service Name. You have to use Microsoft SQL Server Enterprise Edition. Unsupported types: Oracle Database Data Types Undermentioned is the array of the supported types : Oracle Database Data Types The connector does not support all types of data (~50%). Software: SQL Server 2008 R2 SP1 (Engine, Integration Services & Microsoft Visual Sutdio)Īttunity connector dose not work with all version of SQL Server, be sure that all prerequisites are met.ArchitectureĪll along this blog, I have used this 2 virtual machines: So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle.
0 kommentar(er)
