Project Name
Broken Tableau Connections, No DevOps, and Unconnected Portal Data Fixed for a US Telecom SaaS Company
A US-based telecom compliance SaaS company ran Salesforce and Tableau for approximately 60 users with three compounding problems: Tableau connections to SharePoint-hosted Excel files broke every time a file was saved, a PostgreSQL portal database replica had never been connected to Tableau, and all Salesforce changes were deployed directly to production with no sandbox. A compliance renewal and reseller partner automation backlog had no dedicated engineering resource. Applying its AI-First approach, Ksolves was engaged as the dedicated Salesforce and Tableau engineering partner to fix what was broken, build what was missing, and become the technical resource the team could rely on.
- Tableau Connections Regularly Breaking: SharePoint-hosted Excel files broke their Tableau connections every time a file was saved. Tableau binds to file metadata that changes on save. Leadership spent hours manually diagnosing failures and using AI tools to understand what changed.
- PostgreSQL Portal Database Not Connected to Tableau: A portal database replica had been created for analytics use but never connected to Tableau. Salesforce CRM data and portal data could not be combined in any dashboard.
- No Sandbox or DevOps Pipeline: All Salesforce changes were deployed directly to production with no sandbox, no staging, and no CI/CD pipeline. One misconfigured automation could break live operations for the entire team.
- Custom Portal API Requiring Deep Technical Partnership: The proprietary portal communicated with Salesforce through custom APIs. The team needed a partner who would learn these structures deeply and build automation logic that responded correctly when portal events triggered Salesforce actions.
- Compliance Renewal and Reseller Partner Backlog: A reseller partner automation project and compliance renewal customisation were queued with no dedicated engineering resource to deliver them.
- Agentforce Not Yet Evaluated: No Agentforce implementation existed and no evaluation had been conducted on how the existing configuration and portal API architecture would support AI agent deployment.
Ksolves deployed a senior Salesforce architect and Tableau specialist as the company's primary day-to-day technical partner, backed by a 100-person Salesforce practice. The engagement began with a structured health check and established flexible hour tiers with EST-aligned 8AM to 12PM coverage, Jira-integrated tracking, and Confluence documentation.
- Salesforce and Tableau Health Check: Structured audit covering Salesforce org architecture, Apex class quality, Tableau connection root cause analysis, HubSpot data flow validation, API configuration review, and DevOps posture assessment.
- Tableau PostgreSQL Connection via Tableau Bridge: Designed and implemented the Tableau Bridge connection for the PostgreSQL portal replica with live data refresh governance - Salesforce and portal data combinable in executive dashboards for the first time.
- Tableau Excel/SharePoint Connection Stabilisation: Identified the root cause (file metadata binding on save), implemented a durable connection strategy, and documented a maintenance protocol eliminating recurring breaks.
- DevOps Pipeline Build: Provisioned the company's first development sandbox, established a dev/QA/UAT/production release pathway, implemented change set governance, and integrated with Jira for tracked releases.
- Compliance Renewal and Reseller Partner Automation: Delivered reseller partner automation with custom workflow logic and differentiated communication triggers. Continued compliance renewal object enhancements and automated email reminders.
- Agentforce and Strategic Roadmap Planning: Monthly roadmap planning evaluating Salesforce configuration and portal API structure against Agentforce's agent framework - highest-impact AI use cases identified and sequenced.
Technology Stack
| Category | Technology |
|---|---|
| Platform | Salesforce Sales Cloud + Service Cloud |
| Analytics | Tableau + Tableau Bridge |
| Integration | Proprietary Portal API HubSpot |
| Integration | HubSpot |
| DevOps | Sandbox + CI/CD Pipeline Setup |
| Platform | Agentforce Strategic Roadmap |
- PostgreSQL Portal Data Connected to Tableau: Tableau Bridge connection established with live data refresh governance. Salesforce and portal data combined in executive dashboards for the first time with no production portal access risk.
- Recurring Tableau Connection Breaks Eliminated: Root cause identified and durable architecture implemented. Hours of non-technical leadership debugging returned to business decision-making.
- First Salesforce Sandbox and DevOps Pipeline: Development sandbox provisioned, dev/QA/UAT/production pathway established, change set governance implemented. Production deployment risk eliminated.
- Reseller Partner Automation Delivered: Custom workflow logic, tailored reporting, and differentiated communication triggers delivered from the backlog - reseller renewals managed at scale with full compliance rigour.
- Leadership Freed From Technical Debugging: Ksolves as the dedicated technical resource means leadership sends a message when something breaks and receives a structured resolution - no more manual debugging by non-technical staff.
A US telecom SaaS company with broken Tableau connections, an unconnected PostgreSQL portal database, and no Salesforce sandbox was given a dedicated technical engineering partner through Ksolves Salesforce managed services. Tableau Bridge connected portal and CRM data for the first time. Recurring connection breaks eliminated. First DevOps pipeline built from scratch. Reseller partner automation delivered from backlog. Leadership stopped debugging infrastructure and started using it. Agentforce roadmap scoped for the next phase.
Still Deploying Salesforce Changes Directly to Production With No Sandbox?
