In Dexibit, you can integrate data for disparate source systems to consolidate a single data view across multiple often silo systems, complete with automation for hands free data flow and managed data lineage for transparency and control.
In Dexibit, you can integrate:
Footfall (including manual counts) and location analytics
Reservations and ticketing
Membership and season passes, via Customer Relationship Management (CRM)
Merchandise, hospitality or similar, via Point of Sale (POS) including that of third parties and for ecommerce
Website analytics
Social media
Digital reviews
Email marketing
Weather (included by default via Dexibit)
Additional systems by arrangement (such as for finance or evaluation)
Additional third party data by arrangement (such as for census)
For digital systems such as website and social media, you can connect these yourself in a few clicks. For everything else requiring a more complex integration, we're here to help.
If we are receiving data via an external system, we prefer to receive tabular data in parquet format, if the system supports it. Otherwise, JSON or CSV/TSV files are totally acceptable. When using CSV please ensure fields are quoted correctly, datatypes are applied consistently, and all columns are present. We are well placed to detect integrity issues quickly and happy to work with you to resolve any gremlin.
In terms of data content, the more the merrier! We love transactional data rich with categorical information. Refer to our https://intercom.help/dexibit/en/articles/8512522-source-system-data-requirements for more information.
We support a variety of integration patterns that will work alongside your systems and business and IT practices.
Push based: your system pushes data to ours. We'll set up a dedicated end-point and expect you to upload new data at your desired cadence
SFTP
S3
Webhook
Pull based: we connect to your systems to pull data. You'll need to provide us credentials and network access to your preferred end-point and we'll query for data at your desired cadence.
System provided SDK
API access (HTTP, GraphQL, SOAP)
SFTP
S3 (via cross-account access or dedicated user)
Direct access: you provide a bastion system, internal to your network, that we can use to access your systems/databases directly
Bastion/Windows host
Direct database/cloud warehouse access (SQL)
What might influence the method of integration?
IT access restrictions
Frequency of data updates desired
Capabilities of the system
The approach of your integrations will be depend on which your software or vendor supports. The complexity of these often depends on how productized versus customized the system is, whether the system is cloud based versus on premise and the degree to which you've configured your data structures to adapt to your organization's purposes.
Your Success Manager will manage the integration of your various systems across your data landscape. For complex systems, this will involve an integration process where we'll gather the inputs, handshake credentials, confirm design, implement the adapter and then accept integrity. This may include a variety of integration techniques depending on your source system vendors and what level of automation they support.
For these sorts of systems, it is usual to go through several iterations of data integrity review, particularly if we need to iron out data lineage, cleansing or other treatments to get your data looking just how you want it.