Transitioning to a new ACL connector version

ACL data connectors provided by Insightsoftware (formerly Simba) in previous versions of Analytics have been removed from Analytics 18. The alternate CData connectors added in Analytics 17 are now the only option for connecting to the associated data sources. For a list of discontinued and replacement data connectors, see Affected connectors.

Any script that uses a Simba data connector to import data will not work in Analytics 18. You need to update the script to use the corresponding CData connector.

Update a script to use a CData connector

If any of your scripts currently use a Simba data connector, you need to update the script to use a CData connector before it can run in Analytics 18.

Note

To avoid disrupting any of your current data automation and data analysis processes, you can do the required script updating in Analytics 17 using a development copy of a production script. Once a development copy of a script is running successfully with a CData connector, it is ready for use in Analytics 18.

Follow these steps to update a script:

  1. In the Data Access window in Analytics 17 (or 18), manually import some data using the appropriate CData connector.

    In the Data Access window, in the New Connections tab, CData connectors are contained in the ACL DSN Connectors (Bundled) section.

    For more information about manually importing data, see Working with the Data Access window.

    Review the ACCESSDATA command in the existing production script for the tables and fields that need to be included in the manual data import.

  2. After a successful manual import, copy the ACLScript import syntax from the Analytics command log, and use it to update the data import syntax in the development copy of the script.

  3. Run the development copy of the script to test that it successfully imports data using the updated import syntax.

  4. Use the development copy of the script as the new production script in Analytics 18.

Identifying the version of a connector

For data connectors that have both a Simba version and a CData version, use the following methods to identify the version.

In a script

The form of the ACCESSDATA command differs depending on the connector version.

  • Simba version ACCESSDATA32 CONNECTOR NAME "connector_name"...

  • CData version ACCESSDATA32 ODBC "Dsn" NAME "DSN_name"...

In the Analytics 17 user interface

  • Simba version In the Data Access window, Simba connectors are contained in the ACL Connectors section.

  • CData version In the Data Access window, CData connectors are contained in the ACL DSN Connectors (Bundled) section.

In the Analytics 18 user interface

  • Simba version Simba data connectors do not exist in Analytics 18 and therefore do not appear in the user interface.

  • CData version In the Data Access window, CData connectors are contained in the ACL DSN Connectors (Bundled) section.

Note

Some connectors with only a CData version also use the native Analytics data connector syntax ( ACCESSDATA32 CONNECTOR NAME "connector_name"... ) and are contained in the ACL Connectors section in the Data Access window.

Continuing to use an old version of a data connector

The Simba data connectors will continue to work in Analytics 17, and earlier versions of Analytics, for as long as a specific connector and a data source remain compatible. Compatibility of a Simba data connector and a data source is beyond the control of Diligent. Given this uncertainty, the best course of action is to transition to using corresponding CData connectors as soon as possible.

Diligent will continue to support Analytics 17 and the Simba data connectors until the release of Analytics 19 (tentative release Fall 2025). Once Analytics 19 is released, Analytics 17 and the Simba data connectors will no longer be supported.

Key dates

Date Analytics version Details
Fall 2023 17.x

Includes: Both the old and the new versions of the connectors.

Support: Diligent supports both old and new versions of the connectors.

If any connector that you use is scheduled to be discontinued, start testing and transitioning to the new version of the connector.
Q1 2025 (tentative)

18.x

End of life for old versions of the connectors

Includes: Only the new versions of the connectors.

Support: Diligent supports both old and new versions of the connectors.

Any scripts that use syntax for old versions of the connectors will not run. Transition to the new version of the connector.
Q4 2025 (tentative)

19.x

End of support for old versions of the connectors

Includes: Only the new versions of the connectors.

Support: Diligent supports new versions of the connectors only. Old versions of the connectors are no longer supported.

Any scripts that use syntax for old versions of the connectors will not run. Transition to the new version of the connector.

Affected connectors

Discontinued Simba connector New CData version of the connector
Cassandra (v.1) Cassandra (v.2)
Concur (v.1) SAP Concur (v.2)
Couchbase (v.1) Couchbase (v.2)
Drill New version not available. Contact Diligent Support for guidance.
DynamoDB (v.1) DynamoDB (v.2)
Google BigQuery (v.1) Google BigQuery (v.2)
HBase (v.1) HBase (v.2)
Hive (v.1) Hive (v.2)
Impala (v.1) Impala (v.2)
MongoDB (v.1) MongoDB (v.2)
Oracle (v.1) Oracle (v.2)
Redshift (v.1) Redshift (v.2)
Salesforce (v.1) Salesforce (v.2)
Spark (v.1) Spark (v.2)
SQL Server (v.1) SQL Server (v.2)
Teradata (v.1) Teradata (v.2)