Skip to main content

Use an AnySource Adapter in the Jet Data Manager

Overview

With the AnySource Adapter, the Jet Data Manager can connect to any data source that has an OLE DB or ADO provider installed the machine. This opens up a wide variety of third-party connectors for platforms such as Google Analytics, Facebook, Twitter, and many cloud based products.

To learn how to add and use Any Source adapters in the Jet Data Manager, see Adding AnySource Adapters to the Jet Data Manager.

Process

The setup for the AnySource adapter is similar for the OLE DB and ADO based adapter. To add an AnySource OLE DB or ADO data source, perform the following steps:

  1. On the Data tab, right click Data Source , click Data Sources and click Add AnySource OLE DB or Add AnySource ADO. The AnySource OLE DB or AnySource ADO window opens.

  2. In the Name box, type a name for the data source.

  3. In the Provider list, click the provider 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. Optionally, enter the number of seconds after which a command should timeout in Command Timeout

  6. Optionally, 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, type the Schema Name , Table Name , Column Name etc.  There is help available for finding the correct column names.

    Click Table Schema to have the JDM read and display the table schema and click Column Schema to have the JDM read and display the column schema from the first available table.

  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 AnySource OLE DB or AnySource ADO window and add the adapter.

    Note: On other data sources, you can use the preview feature in the JDM to view the content of a table on the source. This may not work on AnySource data sources since the JDM does not know exactly what the source is and what syntax to use. However, you can use the query tool to explore the content of a table.

Was this article helpful?

We're sorry to hear that.