About Managing Data Connections
You can connect to a variety of data sources and remote applications to provide the background information for reports. You can blend the additional data from the various data sources with the ready-to-use datasets to enhance business analysis.
Oracle Fusion Analytics Warehouse can connect to other pre-validated data sources such as Oracle Object Storage, cloud applications such as Google Analytics, and on-premises applications such as Oracle E-Business Suite.
You can view the usage of capacity for custom data that is loaded into Oracle Fusion
Analytics Warehouse through the connectors in the Custom
Data Usage dashboard available in the Common folder. The dashboard shows data loaded
daily and monthly from each of the activated external data sources.
Topics
- About Date and Timestamp Formatting for CSV File-based Extractors
- Create a Data Connection Type
- Edit a Data Connection Type
- Delete a Data Connection Type
- Create a Data Connection
- Test a Data Connection
- Update a Data Connection
- Delete a Data Connection
- Connect With On-premises Sources
- Connect with Cloud File Storage Sources
- Connect With Cloud Sources
Create a Data Connection Type
Connection Type specifies the source to which you are connecting. A connection type can have multiple connections.
Edit a Data Connection Type
If the properties or parameters for a data connection type change, you can edit them.
Delete a Data Connection Type
You can delete a data connection type if you don't need it anymore.
Note:
After you delete a connection type, you can't create new data connections to it.- Sign in to your service.
- In Oracle Fusion Analytics Warehouse Console, click Data Configuration under Application Administration.
- On the Data Configuration page, click Manage Connections under Configurations.
- On the Manage Connections page, click Connections and then select or search for the connection you want to test.
- Click the Action menu for the connection and select Delete.
- In the Delete Connection dialog box, click Delete.
Create a Data Connection
You create a data connection to a data source to load data from that source into Oracle Fusion Analytics Warehouse. You can create a connection for any available connection type.
Test a Data Connection
After you create a data connection, you should test it to ensure it works properly.
- Sign in to your service.
- In Oracle Fusion Analytics Warehouse Console, click Data Configuration under Application Administration.
- On the Data Configuration page, click Manage Connections under Configurations.
- On the Manage Connections page, click Connections, then select or search for the connection you want to test.
- Click the Action menu for the connection and select Test Connection.
- On the Request History page, check the status of the request to test the connection.
Update a Data Connection
When you first make a data connection, or when you make changes, you need to initialize and refresh it.
Delete a Data Connection
You can delete a custom data connection if you don't need it anymore.
Note:
You can't update or load data from deleted data connections to the warehouse.- Sign in to your service.
- In Oracle Fusion Analytics Warehouse Console, click Data Configuration under Application Administration.
- On the Data Configuration page, click Manage Connections under Configurations.
- On the Manage Connections page, click Connections, then select or search for the connection you want to test.
- Click the Action menu for the connection and select Delete.
- In the Delete Connection dialog box, click Delete.
Connect With On-premises Sources
Connect with your on-premises applications to provide the background information for reports.
You can blend the additional data from these data sources with the ready-to-use datasets to enhance business analysis.
Set up the Remote Agent to Load Data into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use an extract service remote agent to connect to your on-premises systems such as E-Business Suite, Peoplesoft, and JD Edwards, load data from these on-premises systems into Oracle Fusion Analytics Warehouse, and then use the on-premises data to create data augmentations.
Note:
After configuring the remote agent on the Data Configuration page, wait for few minutes, refresh the remote agent page, and when you see the Agent Initialised message, you can proceed with other operations such as testing the connection to the remote agent, testng the connection to the remote source like EBusiness Suite, and refreshing the metadata. This enables you to run these jobs without timeout failures because data pipeline has a default timeout of 15 minutes.Ensure that Remote Agent is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from On-premises E-Business Suite into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use an extract service remote agent to connect to your on-premises Oracle E-Business Suite system.
Ensure that Oracle E-Business Suite On-Prem is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from On-premises MySQL Database into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use an extract service remote agent to connect to your on-premises MySQL database.
Ensure that MySQL On-Prem is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use an extract service remote agent to connect to your on-premises Oracle PeopleSoft system.
- Oracle PeopleSoft On-Prem - Campus Solutions
- Oracle PeopleSoft On-Prem - Financials
- Oracle PeopleSoft On-Prem - Human Resources
- Oracle PeopleSoft On-Prem - Learning Management
Load Data from On-premises JD Edwards into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use an extract service remote agent to connect to your on-premises JD Edwards system and use the JD Edwards data to create data augmentations.
Ensure that Remote Agent and Oracle JD Edwards On-Prem are enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from SQL Server into Oracle Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Oracle Fusion Analytics Warehouse extract service to acquire data from SQL Server and use it to create data augmentations.
Ensure that SQL Server is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Connect with Cloud File Storage Sources
Connect with your file storage-based cloud sources to provide the background information for reports.
You can blend the additional data from these data sources with the ready-to-use datasets to enhance business analysis.
About Date and Timestamp Formatting for CSV File-based Extractors
Extractors such as Secure FTP (SFTP), Amazon Simple Storage Service (AWS S3), and Oracle Object Storage Service use CSV data files that have date and timestamp fields.
For the CSV file-based extractors, use these format examples to provide the values in the CSV Date Format, and CSV Timestamp Format fields while entering the source connection details:
Example | Pattern |
---|---|
1/23/1998 | MM/dd/yyyy |
1/23/1998 12:00:20 | MM/dd/yyyy hh:mm:ss |
12:08 PM | h:mm a |
01-Jan-1998 | dd-MMM-yyyy |
2001-07-04T12:08:56.235-0700 | yyyy-MM-dd'T'HH:mm:ss.SSSZ |
Letter | Meaning |
---|---|
M | Month |
d | Day |
y | Year |
h | Hour (0-12) |
H | Hour (0-23) |
m | Minute |
s | Second |
S | Milli Second |
a | AM/PM |
Z | Timezone |
Load Data from Amazon Simple Storage Service into Oracle Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Oracle Fusion Analytics Warehouse extract service to acquire data from Amazon Simple Storage Service (AWS S3) and use it to create data augmentations.
Ensure that AWS S3 is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from Oracle Object Storage into Fusion Analytics Warehouse
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from Oracle Object Storage Service and use it to create data augmentations.
The recommended approach is to create one augmentation from one source table after acquiring data from Oracle Object Storage Service. After completion of augmentation, Fusion Analytics Warehouse renames the source table in this case and if you create more than one augmentation from the same source, all other augmentations may fail with a message that the source file wasn't found.
Load Data from a Secure FTP Source into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from a secure FTP source (SFTP) and use it to create data augmentations.
Ensure that SFTP is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Connect With Cloud Sources
Connect with your cloud applications to provide the background information for reports.
You can blend the additional data from these data sources with the ready-to-use datasets to enhance business analysis.
Load Data from Azure SQL into Oracle Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Oracle Fusion Analytics Warehouse extract service to acquire data from Azure SQL and use it to create data augmentations.
Ensure that Azure SQL is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Connect with Your Oracle Eloqua Data Source
If you’ve subscribed for Oracle Fusion CX Analytics and want to load data from your Oracle Eloqua source into Fusion Analytics Warehouse, then create a connection using the Eloqua connection type.
The Oracle Eloqua data that you load into Fusion Analytics Warehouse enables you to augment the data in your warehouse and create varied customer experience-related analytics. Ensure that Oracle Eloqua is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
- In Oracle Fusion Analytics Warehouse Console, click Data Configuration under Application Administration.
- On the Data Configuration page, click Manage Connections under Global Configurations.
- On the Manage Connections page, click Create and then click Connection.
- In Create Connection, select Eloqua as the connection type.
- In the dialog for the Eloqua connection, select Standard in Connectivity Type, enter an email address to receive notifications in Notification Email, and the credentials to connect with the Eloqua source in User Name and Password.
- In URL, enter the URL for your Eloqua server in this sample format:
https://<your eloqua server>/api/odata/1.0
.
Description of the illustration fawag_eloqua_create_connection.gif - Click Save.
Load Data from Enterprise Data Management Cloud into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Enterprise Data Management Cloud instance and use it to create data augmentations.
Ensure that Oracle Enterprise Data Management Cloud is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Enterprise Performance Management (EPM) SaaS instance and use it to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases.
- Financial Close and Consolidation (FCCS)
- Planning and Budgeting (PBCS)
- Profitability and Cost Management (PCMCS)
You can only manually extract the incremental data because, for incremental extraction, you must update the results file in EPM before starting the next extraction for the updated data. Update the results file by running the integration using Data Exchange and then access the new results file from the EPM connector in Fusion Analytics Warehouse.
- Oracle EPM - Financial Close and Consolidation
- Oracle EPM - Planning and Budgeting
- Oracle EPM - Profitability and Cost Management
Load Data from EPM Export Data Instance into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from EPM Export Data instance and use it to create data augmentations.
- Financial Close and Consolidation (FCCS)
- Planning and Budgeting (PBCS)
- Profitability and Cost Management (PCMCS)
You can only manually extract the incremental data because, for incremental extraction, you must update the results file in EPM before starting the next extraction for the updated data. Update the results file by running the integration using Data Exchange and then access the new results file from the EPM connector in Fusion Analytics Warehouse.
- EPM Financial Close and Consolidation Data Export
- EPM Planning and Budgeting Data Export
- EPM Profitability and Cost Management Data Export
Load Data from Google Analytics into Fusion Analytics Warehouse
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Google Analytics SaaS instance and use it to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases.
- Fusion Analytics Warehouse supports Google Analytics extractor for GA4 properties and doesn’t support the previous version – Google Universal Analytics (UA) properties.
- DataStores are the list of GA4 properties.
- DataStore columns are the list of Dimensions and Metrics for a GA4 property.
- DataExtract runs the report based on user selection for a GA4 property as DataStore and Dimensions and Metrics as DataStore columns.
- MetaExtract fetches metadata for all the available GA4 properties (DataStores) and its Dimensions and Metrics (DataStoreColumns).
Load Data from Mongo Database into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Mongo database and use it to create data augmentations.
Ensure that MongoDB is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from MySQL Cloud Database into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the MySQL Cloud database and use it to create data augmentations.
Ensure that MySQL Cloud is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from Salesforce into Fusion Analytics Warehouse
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Salesforce SaaS instance and use it to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases.
This version of the Salesforce Connector supports version 57.0 of the API from Salesforce.
Load the Bureau of Labor Statistics Data into Fusion Analytics Warehouse
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Bureau of Labor Statistics (BLS) and use it to create data augmentations for various Enterprise Resource Planning, Human Capital Management and Supply Chain Management use cases.
BLS is a repository of many datasets created by the government of United States. It includes almost 100 public datasets such as Consumer Price Index, Producer Price Indexes, Import and Export Price Indexes, Consumer Price Index, Pay and Benefits, Unemployment, Employment, and Labor Productivity.
Since the government datasets don't have timestamp for partial changes to datasets and the government publishes the entire datasets including changes entirely, you must perform a full extract each time.
Load Data from Shopify into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Shopify SaaS instance and use it to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases.
Ensure that Shopify is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from Oracle Autonomous Database into Oracle Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Oracle Fusion Analytics Warehouse extract service to acquire data from Oracle Autonomous Database and use it to create data augmentations.
You can create connections to five autonomous databases. Depending on the number of connections, ensure that options such as Oracle Autonomous Database 1, Oracle Autonomous Database2 are enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from Snowflake into Oracle Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Oracle Fusion Analytics Warehouse extract service to acquire data from a Snowflake instance.
You can later use this data to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases. Establish the connection from Fusion Analytics Warehouse to your Snowflake instance to start data acquisition followed by augmentation.
Ensure that Snowflake is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from Taleo into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Taleo instance and use it to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases.
Ensure that Taleo is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from Oracle Analytics Publisher into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the Analytics Publisher reports and use it to create data augmentations for various use cases.
Note:
The BI Publisher Reports connector only supports the Analytics Publisher in Oracle Fusion Cloud Applications for data augmentation.Ensure that BI Publisher Reports is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from Oracle Database Using JDBC into Fusion Analytics Warehouse (Preview)
As a service administrator, you can use an extract service remote agent to connect to an Oracle database using JDBC and use the data to create data augmentations.
Ensure that Remote Agent and Oracle JDBC are enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.
Load Data from QuickBooks Online into Oracle Fusion Analytics Warehouse (Preview)
As a service administrator, you can use the Oracle Fusion Analytics Warehouse extract service to acquire data from QuickBooks Online and use it to create data augmentations.
Ensure that QuickBooks Online is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.