Skip to main content
To homepage To homepage

With the Any Source Adapter, you can connect to any data source that you have an OLE DB or ADO.NET provider installed on your server. Instead of waiting for us to create an adapter that enables you to connect to a specific system, you can now acquire a provider from the system developer or a third-party vendor.

Adding an Any Source OLE DB or ADO.NET Data Source

The setup for the Any Source adapter is similar for the OLE DB and ADO.NET-based adapter. To add an Any Source OLE DB or ADO.NET data source, follow the steps below.

  1. Open a business unit, right-click Data Sources, click Data Sources, and then click Add Any Source OLE DB/ Add Any Source ADO.NET. The Any Source OLE DB/Any Source ADO.NET window opens.
    1. Any Source OLE DB
    2. Any Source ADO.NET
  2. In the Name box, type a name for the data source.
  3. In the Provider list, click the provider you want to use.
  4. In the property sheet, edit the settings for the connection. See the documentation for the provider you are using for more information.
  5. (Optional) In Command Timeout, enter the number of seconds after which a command should time out.
  6. (Optional) In the Use Integration Services for Transfer list, click As Parent to use the same setting as the parent business unit or Yes or No to use or not use Integration Services for transfer, respectively.
  7. Click Test Connection to verify that the connection is working.
  8. Click Advanced settings to access additional settings. The Advanced Data Source Properties window opens.
  9. In the Query Formatting list, type the Prefix, Suffix, and Separator used in the source. Click Read Value to fill in the values automatically if possible.
  10. In the Character Replacements list, you can type a Replace Character to replace with the Replace Value in data from the data source.
  11. In the Schema Properties list, you can choose the Schema Name, Table Name, Column Name, etc by clicking on the Table Schema, View Schema, or Column Schema button.

    Any changes made in this menu will affect the Schema properties name list.

  12. In the Object Filtering list, you can choose to filter the tables you receive from the provider using regular expressions or different string comparisons. Click Table or Schema in the Object Type list, click a filter type in the Filter Type list, and type a value in the Filter Value List.
  13. Click OK to close the Advanced Data Source Properties window.
  14. Click OK to close the Any Source OLE DB/Any Source ADO.NET window and add the data source.

Specific guides for Any Source OLE DB/Any Source ADO

Be the first to reply!

Reply


Terms and ConditionsCookie settings