Use the Create OLE DB Table Function wizard to create an OLE DB
user-defined table function that allows you import data from a database that
supports the OLE DB format.
To create a UDF for OLE DB:
- Switch to the Data perspective.
- Click File > New > Other to open the New
dialog.
- Select Data and choose User-Defined
Function.
- Click Next. The wizard
opens.
- On the Specify a Project page, choose to
use a new project or select an existing data development project.
- Click Next. The Name
and Language page opens.
- In the Language field, select OLE DB.
- Complete the necessary steps of the wizard.
- Click Finish.
The user-defined function is created and added to the data development
project that you specified, and the user-defined function is deployed and
registered on the database server.