Step 4: Connections

    For Spreadsheet Server, a database connection must be created in order to access a Designer GL database, process Query Designer queries (GEXQ, GEXD, GEXS, or GEXI formulas, or subqueries), or set up unattended sign in for a General Ledger connection.

    Note: Use the appropriate host configuration, rather than a connection, for Infinium, JD Edwards, JDE_FXA Designer GL, SAP or SAP Designer GL databases. Additionally, database connections are not required for processing unattended sign in for Infinium, JD Edwards, or SAP, as this is determined in the user settings (see Step 3: Users for more information).

    For Budget Accelerator and Spreadsheet Analyst, a database connection may be created in order access a database. The Connection process allows users to create connections to the following data sources:

    • IBM DB2 (iSeries/AS400)
    • Microsoft Access
    • Oracle
    • Salesforce
    • SAP (32-bit environment only)
    • SQL Server
    • System DSNs with variable SQL Syntax

    This article describes how to set up and manage connections in Application Configurator for Reporting Intelligence for Other ERPs. Connections define how Reporting Intelligence for Other ERPs accesses your replicated ERP data.

    Note: Reporting Intelligence for Other ERPs connects to ERP data through Data Hub. Beginning with 26.3, connections created in Data Hub are automatically available in Reporting Intelligence for Other ERPs and Query Designer. You do not need to create a connection here unless you also want it available in Application Configurator. For more information, see Data Hub connections.

 

 

Was this article helpful?

We're sorry to hear that.