Automate Reporting
      Back to home
      1. Help Center
      2. Bionic for Agencies
      3. Automate Reporting

      Integrate With Other BI Tools

      Here's How to Integrate with Other Systems Using Bionic for Agencies.

       If you already have a dashboard system, Bionic is happy to support many of the leading dashboard systems.

      In this article, we'll cover:

      1. Setup Nightly Data Feed
      2. Integrate with Amazon S3
      3. Integrate with Google Cloud Storage
      4. Integrate with FTP

      Setup Nightly Data Feed

      Getting data out of Bionic into other tools is critical for your media planning. To support this Bionic offers two data exports.

      One data export is of your Media Plan data. The other export is of your Orders data. These files can be delivered to you as a JSON file or a CSV file.

      Please see an example of media plan and order sample files below.

      Media Plan Sample Files:

      Order Sample Files:

      NOTE: Please reach out to your Client Success Manager or Bionic Customer Support to setup a daily delivery of your files. 

      Integrate with Amazon S3

      To setup an AWS S3 feed Please reach out to Bionic Customer Support with the following information:

      1.     bucketName: '<bucket name>', //eg bionic/data
      2.     region: '<region name>',  //eg us-east-1
      3.     accessKeyId: '<IAM_USER_KEY>', //IAM_USER_KEY                                                                                                    
      4.     secretAccessKey: '<IAM_USER_SECRET>' //IAM_USER_SECRET

      As a reminder, to get the access information, your team should create a special reduced privilege user in your AWS organization that can only write to the S3 bucket.  Once you send the information, Bionic will configure the feeds to deliver the data to the S3 bucket, and then perform a test to verify the process is working properly.

      Integrate with Google Cloud Storage

      To setup an GCS feed, please reach out to Bionic Customer Support with the following information:

      1. Create a "service account" and grant it create & update permissions to a Cloud Storage bucket.  

      2. Send us the fully qualified bucket name and the keys.json file generated for that service account.  

      3. Bionic will run a test upload to verify the connection.

      4. Once confirmed, the nightly feed will be set up for delivery.

      Integrate with FTP

      To setup an FTP feed, please reach out to Bionic Customer Support with the following information:

      1. IP Address of FTP Server
      2. Port for the FTP Server  
      3. Username for the FTP Server 
      4. Password for the FTP Server

      Please note that you may need to whitelist the Bionic CDIR to access your FTP site:

      216.251.255.100/30