Connect more data, get audience insights faster, activate your marketing platforms
Data Accelerator is a cloud-based data management solution that is quickly onboarded to allow for analysis, insights, and visualization of your data.
The ability to get your database environment deployed and functioning within weeks so you can build insights is a huge win. You can start small with your data management, then expand as needed.
Data Accelerator helps you:
With a modular approach to solving your marketing needs today and as they evolve, our Data Accelerators are pre-configured to get your data up and running from online and offline channels on the following platforms
Data Accelerator is available across several cloud platforms including Google Cloud Platform (GCP), Amazon Web Services (AWS) and Microsoft's Azure. The query tools that Data Accelerator offers include: Google Big Query, Amazon Redshift, Snowflake and Azure Query Editor.
Data Accelerator currently handles flat file data feeds that have fields either in a fixed width format or separated by a delimiter (comma, pipe, tab). In addition, Data Accelerator can extract data from existing database (SQL, Snowflake, Big Query, RedShift, Azure Data Warehouse) tables. For Data Accelerator clients who select Google Cloud Platform (GCP), there are numerous native Google platforms that can be pushed directly into Big Query using Data Transfer Service (DTS) or Storage Transfer Service (STS).
Data Accelerator is able to decompress files that are zipped as well as decrypt files that have been PGP encrypted. We recommend that any feeds that have PII, be transferred as encrypted using Merkle's Public Key (supplied by Merkle Data Accelerator team).
Before sending the new feed in the new layout, please email RALsupport@merkleinc.com and provide details such as the feed name and when the change will be made. The Data Accelerator Support team will work with you on making these changes and scheduling when the new feed will be productionalized.
If the feed contains any Pll, clients should not be sending this feed as ad hoc due to recent changes in US and EU laws. For non-Pll feeds, if you have a new set of data you want to push into Data Accelerator and it will not be a reoccurring data source, you can push this feed to Data Accelerator by uploading it to the assigned landing location.
Data Accelerator's automatic schema detection scans any unknown file it receives to evaluate each column of data and uses AI to assign the most appropriate datatype and stage the file into the database. This is not infallible and bad data in the source feed can throw it off. For Example: A column of data is called 'product_price' and 99% of the records are sent in a decimal format but 1% of the records are sent with the text "Free". Data Accelerator will assign this column a data type of 'string' and not 'float' since there was text detected.
Files should always have a date and time stamp in the filename (YYYYMMDDHHMMSS) and should not have any spaces in the name (Good: Order_Details_20190109110203.txt Bad: Order Details.txt).
Yes. SSH keys are preferred and if a client is sending data via a secure FTP without SSH, there will be a requirement to reset the sFTP password every 60 days. SSH Keys or approval from client’s Security Officer to remove the password expiration are necessary to relax this requirement.
Merkle’s Data Accelerator was built to be a centralized foundation to ingest and consolidate disparate data sets. The Data Accelerator can serve as a one-stop-shop for all data to flow into a client’s Activation layer (Salesforce, Adobe, etc.).