SAGE X3 API PASSWORD

Use the Add Pipeline as Union of Tables option from the Add Pipelines drop-down menu, to add a single pipeline created from a union of the selected tables. Use the Add Pipelines button to add tables as individual pipelines. To add the pipelines to the data model, there is three options: Select tables to be added as pipelines using the check box column. To add tables from the Sage X3 Cloud database to the Data Model:

If necessary, click Next to continue to the Select Data step.

Or, click the ➕ Dimensions button to create the individual financial dimensions, but remain on the Configure Model screen.

Select the financial dimensions to include in the data model.Ĭreate a dimension pipeline for each of the selected financial dimensions by:Ĭlicking the Next button to create the selected dimensions and proceed to the Select Data step.

The selected financial dimensions are automatically configured to relate to pipelines from the Sage Enterprise Management Cloud. Select the financial dimensions to be included in the data model. They are used to classify data in financial reports.Ī list of financial dimensions is extracted from the 'Analytical entry lines' table (CPTANALIN) in Sage X3 Cloud.

Click Next to continue to the Configure Model step.įinancial dimensions are used to store information such as cost center, department, and project.

Select the Primary Company to indicate the primary entity (if there is more than one entity).

Specify which entities to include for analysis by selecting or clearing the check box beside the entity names.

To specify which entities (or companies) should be available for analysis in Data Hub:

Click Next to continue to the Configure Source step.

Return to Data Hub and click Test Connection.

Go to Administration > Users > Security profiles, and make sure the ‘third Parties’ line ensure that ‘Create’, ‘Read’ and ‘Write’ are checked.

SAGE X3 API PASSWORD

In the Sage X3 Cloud pop-up screen, enter your user-name and password and click Sign in.Įnsure that X3 user(s) have the correct security profile:.At the time of writing, Sage X3 Cloud supports two main API Gateway endpoints based on your region: Europe ( ), North America ( ). API Gateway Specify the API Gateway used by the Sage X3 source. Use the fully-qualified domain name ( FQDN) for the Sage X3 Cloud server. For more information on Data Gateways, see: Using Data Gateways. Leave this item set to None unless you are using a Data Gateway. To set up the connection between Data Hub and Sage X3 Cloud: From the source type pop-up, click Connect on the Sage X3 Cloud entry tagged Data Source.Under the Apps (API) section, select Sage X3Cloud.Open an existing Data Model from the RESOURCE EXPLORER.To add a Sage X3 Cloud data source to an existing Data Model:

Select the API gateway that applies to the region where your X3 configuration is hosted.Ī Sage X3 Cloud data source can be added to a new or existing Data Model.įor information on creating a new Data Model and selecting an initial data source, see: Accessing the Model Creation Wizard and Selecting a Data Source.Open the Navigation menu and click Register in SBC.Single-tenant customer instances of Sage X3 Cloud must be registered to Sage Business Cloud as follows:.Sage X3 Cloud was previously know as Sage Enterprise Management Cloud. Connecting to a Sage X3 Cloud Data Source

Sage x3 api