Creating the Rules Table and Connection - experianplc/experian-data-studio-connector-mulesoft GitHub Wiki

Creating the Rules Table

For ease of creating the tables, we've provided pre-made SQL for Table Creation that should facilitate the table creation process. In the Database of your choice, you will need to create a pandora_rules table with the specified attributes (see pre-made SQL).

Setting up a connection

Once you've created your table, you will need to setup a new connection. to do this, select Connections from the Home menu, right click and choose New. Once done you should see the Create Connection (new) prompt as shown below.

image

Once this is filled out be sure to check Include Tables and hit Save.

Setting up a new target

Once you have setup your Connection you should go to your new connection and right click pandora_rules selecting Target -> Save As. You should be prompt to a prompt similar to what's below:

image

The default settings that are filled in are fine. Hit Save and you're finished. You should move on to Exporting Rules from Pandora to Database

⚠️ **GitHub.com Fallback** ⚠️