Defense in depth. Pantheon makes this expensive and inflexible.
Many co-ops use SQL Server. PHP does a poor job with this and other data sources. Integration projects are becoming more common.
Per project. Not turn-key. Not portable. Doesn't come with us if we leave Pantheon.
At their mercy for database drivers and infrastructure. Bluebonnet's outage webform broke for 3-4 months when Runtime 2 dropped ODBC support.
Tunnel is on Pantheon. Locked out locally. Push code, cross fingers, hope it works.
We have no way of easily gathering a list of SFTP users, whitelist tunnels or existing data integration projects.
DataGrid lets PHP do what it's good at (front-end display), and Python do what it's good at (data handling, API interop). We own the entire solution. No vendor lock-in. No surprise support drops.
SFTP, REST, JSONAPI, SOAP. Connects to Oracle, PostgreSQL, SQL Server and just about anything else.
Static IP attached to our VM. Co-ops can whitelist immediately.
Co-ops own this solution for as long as they're members. Not tied down to any vendor.
Deployed and working. You're on it right now!
Just need to migrate and build projects.
Just use Feeds. Clean, straightforward and dead-simple to set up by any SHiNE team member.
Devs can connect locally for development and debugging. No more crossing fingers.
All of our data integration projects live in one queryable space.
This is a data interchange layer that TSE and SHiNE can use for their data needs, too.
We can do serious data integration with tools designed for their systems.
Common interchange protocols. We speak their data languages.
Portable solution they own for as long as they're members. Not tied to any vendor.
Real-time static IP querying for uninterrupted service during migration.
Use and combine your data to communicate with your members.
SHiNE cybersecurity engineering team provides modern and effective threat deterrence.
A new tool that enlarges our digital footprint and technology leadership.
For co-ops who want to do more with their data and their site. We help them serve their members and not just display pictures and text.
Real-time data access turns co-op data into powerful member-facing features. DataGrid handles the technical complexity so we can focus on building compelling custom experiences that strengthen member engagement.
Co-ops will rely on DataGrid alongside SHiNE and our other offerings.
Each DataGrid enhancement creates natural opportunities for member relations engagement. Regular project touchpoints keep relationships active and deepen co-op partnerships over time.
DataGrid is a collection of data connection services, spearheaded by the DataGrid Python microservice. We're more than just SFTP server shares now.
DataGrid infrastructure invites expansion. Co-ops see what's possible and come back for enhancements, creating a steady pipeline of custom development work.
Hear "data integration" or "IP whitelisting"? You have a solution.
Co-ops start with one integration, then add more. Each DataGrid project creates momentum for the next, turning one-time builds into ongoing partnerships.
DataGrid is deployed and operational. The infrastructure is boring (in a good way). The exciting part is what we build on top of it.
View Live Dashboard to see it in action.
Python + FastAPI. SFTP on 4301. Connects to Oracle, PostgreSQL, SQL Server. Secure, isolated, read-only. Deployed on GCP. It just works.
Full technical documentation available for implementation teams who need it. For everyone else: it's infrastructure. It's supposed to be boring.